Skip to main content

TTL

Table Metadata

PropertyConfiguration
Natural Key(s)key_hash, closed_at
Partition Field(s)closed_at (MONTH partition)
Clustered Field(s)last_modified_ledger, key_hash
Documentationdbt docs

Column Details

NameDescriptionData TypeDomain ValuesRequired?Notes
key_hashLedger key hash used to identify expiring contract data or contract code ledger entriesstringYes
live_until_ledger_seqLedger sequence the contract or wasm will live untilintegerYes
last_modified_ledgerThe ledger sequence number when the ledger entry (this unique signer for the account) was modifiedintegerYes
ledger_entry_changeCode that describes the ledger entry change type that was applied to the ledger entryintegerYes
deletedIndicates whether the ledger entry (balance id) has been deleted or not. Once an entry is deleted, it cannot be recoveredbooleanYes
batch_idString representation of the run id for a given DAG in AirflowstringYes
batch_run_dateThe start date for the batch interval. When taken with the date in the batch_id, the date represents the interval of ledgers processeddatetimeYes
batch_insert_tsThe timestamp in UTC when a batch of records was inserted into the databasetimestampYes
closed_atThe UNIX timestamp of the sequence number's agetimestampYes
ledger_sequenceThe unsigned 32-bit ledger number of the sequence number's ageintegerYes