TTL
Table Metadata​
| Property | Configuration |
|---|---|
| Natural Key(s) | key_hash, closed_at |
| Partition Field(s) | closed_at (MONTH partition) |
| Clustered Field(s) | last_modified_ledger, key_hash |
| Documentation | dbt docs |
Column Details​
| Name | Description | Data Type | Domain Values | Required? | Notes |
|---|---|---|---|---|---|
| key_hash | Ledger key hash used to identify expiring contract data or contract code ledger entries | string | Yes | ||
| live_until_ledger_seq | Ledger sequence the contract or wasm will live until | integer | Yes | ||
| last_modified_ledger | The ledger sequence number when the ledger entry (this unique signer for the account) was modified | integer | Yes | ||
| ledger_entry_change | Code that describes the ledger entry change type that was applied to the ledger entry | integer | Yes | ||
| deleted | Indicates whether the ledger entry (balance id) has been deleted or not. Once an entry is deleted, it cannot be recovered | boolean | Yes | ||
| batch_id | String representation of the run id for a given DAG in Airflow | string | Yes | ||
| batch_run_date | The start date for the batch interval. When taken with the date in the batch_id, the date represents the interval of ledgers processed | datetime | Yes | ||
| batch_insert_ts | The timestamp in UTC when a batch of records was inserted into the database | timestamp | Yes | ||
| closed_at | The UNIX timestamp of the sequence number's age | timestamp | Yes | ||
| ledger_sequence | The unsigned 32-bit ledger number of the sequence number's age | integer | Yes |