Skip to main content

Table Details

PropertyValue
Table Namekatana.bridges.bridge_aggregators_inbound_transfers
Table StatusProduction-Ready
Unique Keyblock_timestamp::date, unique_id
Clustering Key(s)block_timestamp::date

Table Columns

Column NameData TypeDescription
projectVARCHAR(16777216)Project or application associated with this record.
protocolVARCHAR(16777216)Protocol associated with this record.
contract_addressVARCHAR(16777216)Contract address that emitted this event.
event_nameVARCHAR(16777216)Name of the onchain event that produced this record.
directionVARCHAR(16777216)Direction of the bridge transfer relative to this chain (inbound or outbound).
source_chainVARCHAR(16777216)Chain the bridged assets originated from.
destination_chainVARCHAR(16777216)Chain the bridged assets are being sent to.
sender_addressVARCHAR(16777216)Address that initiated the transfer.
recipient_addressVARCHAR(16777216)Address that received the transferred assets.
token_typeVARCHAR(16777216)Token standard or category (e.g. erc20, erc721, native).
token_addressVARCHAR(16777216)Contract address of the token. On EVM chains native currency is represented as the zero address.
token_nameVARCHAR(16777216)Human-readable name of the token.
token_symbolVARCHAR(16777216)Ticker symbol of the token.
token_idVARCHAR(16777216)Identifier for non-fungible or semi-fungible tokens. Each unique token_id within a collection represents a distinct asset.
amount_rawVARCHAR(16777216)Token amount in the smallest indivisible unit (not decimal-adjusted).
amountVARCHAR(16777216)Decimal-adjusted amount of tokens involved in this record.
usd_amountFLOATUSD value of the amount, computed using the token’s USD exchange rate at the record’s timestamp.
fee_token_addressVARCHAR(16777216)Contract address of the token used to pay the bridge fee.
fee_token_nameVARCHAR(16777216)Name of the token used to pay the bridge fee.
fee_token_symbolVARCHAR(16777216)Symbol of the token used to pay the bridge fee.
fee_amount_rawVARCHAR(16777216)Bridge fee in the token’s smallest indivisible unit.
fee_amountVARCHAR(16777216)Decimal-adjusted bridge fee charged for this transfer.
fee_usd_amountFLOATUSD value of the bridge fee.
fee_detailsVARIANTStructured breakdown of the fees charged for this transfer.
extra_fieldsVARIANTAdditional protocol-specific fields captured for this transfer.
transaction_from_addressVARCHAR(16777216)Sender (msg.sender) of the transaction that produced this record.
transaction_to_addressVARCHAR(16777216)Destination address of the transaction that produced this record (may be a smart contract).
transaction_hashVARCHAR(16777216)Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain.
transaction_indexNUMBER(38,0)Zero-based position of the transaction within its block. The first transaction in a block has index 0.
log_indexNUMBER(38,0)Zero-based position of this event log within its transaction. The first log emitted by a transaction has index 0.
block_numberNUMBER(38,0)Sequential number of the block that contains this record. Starts at 0 (genesis) and increments by 1 per block.
block_timestampTIMESTAMP_NTZ(9)Timestamp (UTC) of the block that contains this record.
block_hashVARCHAR(16777216)Cryptographic hash of the block header that contains this record. Uniquely identifies a block.
unique_idVARCHAR(16777216)Allium’s deterministic unique identifier for this row, generated from the fields that uniquely identify the record. Stable across full refreshes.
_created_atTIMESTAMP_NTZ(9)Timestamp of when the entry was created in the database.
_updated_atTIMESTAMP_NTZ(9)Timestamp of when the entry was last updated in the database.