Trustlines - Stellar Developer Docs

Table Metadata

Property	Configuration
Natural Key(s)	account_id, asset_type, asset_issuer, asset_code, liquidity_pool_id, closed_at
Partition Field(s)	batch_run_date (MONTH partition)
Clustered Field(s)	account_id, asset_id, liquidity_pool_id, last_modified_ledger
Documentation	dbt docs

Column Details

Name	Description	Data Type	Domain Values	Required?	Notes
ledger_key	The unique ledger key when the trust line state last changed	string		Yes
account_id	The account address	string		Yes
asset_type	The identifier for type of asset code held by the trustline: an alphanumeric code of 4 or 12 characters, or a liquidity pool share.	string	credit_alphanum4 credit_alphanum12 pool_share	Yes	Trustlines never report `native`. XLM is held directly on the account and is reported in the `accounts` table, not here. `pool_share` identifies a trustline holding shares in a liquidity pool.
asset_issuer	The account address of the original asset issuer that created the asset held by this account	string		No
asset_code	The 4 or 12 character code representation of the asset held by this account	string		No
liquidity_pool_id	If the asset held is part of a liquidity pool share, the unique pool id from which the asset balance originates	string		No
balance	The number of units of an asset held by this account	float		Yes
trust_line_limit	The maximum amount of this asset that this account is willing to accept. The limit is specified when opening a trust line	integer		Yes
buying_liabilities	The sum of all buy offers owned by this account for non-native assets	float		Yes
selling_liabilities	The sum of all sell offers owned by this account for non-native assets	float		Yes
flags	Denotes the enabling and disabling of certain asset issuer privileges	integer	0 - None, Default 1 - Authorized 2 - Authorized to Maintain Liabilities 4 - Clawback Enabled	Yes	Flags are set on the issuer accounts for an asset. When user accounts trust an asset, the flags applied to the asset originate from this account
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	0 - Ledger Entry Created 1 - Ledger Entry Updated 2 - Ledger Entry Deleted 3 - Ledger Entry State	Yes	Valid entry change types are 0, 1, and 2 for ledger entries of type `trust_lines`.
deleted	Indicates whether the ledger entry (trust line) has been deleted or not. Once an entry is deleted, it cannot be recovered	boolean		Yes
closed_at	Timestamp in UTC when this ledger closed and committed to the network. Ledgers are expected to close ~every 5 seconds	timestamp		Yes
ledger_sequence	The sequence number of this ledger. It represents the order of the ledger within the Stellar blockchain. Each ledger has a unique sequence number that increments with every new ledger, ensuring that ledgers are processed in the correct order.	integer		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	The table is partitioned on batch_run_date. It is recommended to always include the batch_run_date in the filter if possible to help reduce query cost.
batch_insert_ts	The timestamp in UTC when a batch of records was inserted into the database	timestamp		Yes
sponsor	The account address that is sponsoring the base reserves for the trust line	string		No
asset_id	Unique identifier for asset_code, asset_issuer	integer		No
liquidity_pool_id_strkey	The StrKey (`L...`) representation of the liquidity pool id.	string		No	Same pool as `liquidity_pool_id`, StrKey-encoded rather than hex. StrKey encoding is defined by SEP-23.