> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Bridge Aggregators Inbound Transfers

### Table Details

| Property          | Value                                                 |
| ----------------- | ----------------------------------------------------- |
| Table Name        | `katana.bridges.bridge_aggregators_inbound_transfers` |
| Table Status      | Production-Ready                                      |
| Unique Key        | `block_timestamp::date`, `unique_id`                  |
| Clustering Key(s) | `block_timestamp::date`                               |

### Table Columns

| Column Name                | Data Type         | Description                                                                                                                                       |
| -------------------------- | ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------------- |
| project                    | VARCHAR(16777216) | Project or application associated with this record.                                                                                               |
| protocol                   | VARCHAR(16777216) | Protocol associated with this record.                                                                                                             |
| contract\_address          | VARCHAR(16777216) | Contract address that emitted this event.                                                                                                         |
| event\_name                | VARCHAR(16777216) | Name of the onchain event that produced this record.                                                                                              |
| direction                  | VARCHAR(16777216) | Direction of the bridge transfer relative to this chain (inbound or outbound).                                                                    |
| source\_chain              | VARCHAR(16777216) | Chain the bridged assets originated from.                                                                                                         |
| destination\_chain         | VARCHAR(16777216) | Chain the bridged assets are being sent to.                                                                                                       |
| sender\_address            | VARCHAR(16777216) | Address that initiated the transfer.                                                                                                              |
| recipient\_address         | VARCHAR(16777216) | Address that received the transferred assets.                                                                                                     |
| token\_type                | VARCHAR(16777216) | Token standard or category (e.g. erc20, erc721, native).                                                                                          |
| token\_address             | VARCHAR(16777216) | Contract address of the token. On EVM chains native currency is represented as the zero address.                                                  |
| token\_name                | VARCHAR(16777216) | Human-readable name of the token.                                                                                                                 |
| token\_symbol              | VARCHAR(16777216) | Ticker symbol of the token.                                                                                                                       |
| token\_id                  | VARCHAR(16777216) | Identifier for non-fungible or semi-fungible tokens. Each unique token\_id within a collection represents a distinct asset.                       |
| amount\_raw                | VARCHAR(16777216) | Token amount in the smallest indivisible unit (not decimal-adjusted).                                                                             |
| amount                     | VARCHAR(16777216) | Decimal-adjusted amount of tokens involved in this record.                                                                                        |
| usd\_amount                | FLOAT             | USD value of the amount, computed using the token's USD exchange rate at the record's timestamp.                                                  |
| fee\_token\_address        | VARCHAR(16777216) | Contract address of the token used to pay the bridge fee.                                                                                         |
| fee\_token\_name           | VARCHAR(16777216) | Name of the token used to pay the bridge fee.                                                                                                     |
| fee\_token\_symbol         | VARCHAR(16777216) | Symbol of the token used to pay the bridge fee.                                                                                                   |
| fee\_amount\_raw           | VARCHAR(16777216) | Bridge fee in the token's smallest indivisible unit.                                                                                              |
| fee\_amount                | VARCHAR(16777216) | Decimal-adjusted bridge fee charged for this transfer.                                                                                            |
| fee\_usd\_amount           | FLOAT             | USD value of the bridge fee.                                                                                                                      |
| fee\_details               | VARIANT           | Structured breakdown of the fees charged for this transfer.                                                                                       |
| extra\_fields              | VARIANT           | Additional protocol-specific fields captured for this transfer.                                                                                   |
| transaction\_from\_address | VARCHAR(16777216) | Sender (msg.sender) of the transaction that produced this record.                                                                                 |
| transaction\_to\_address   | VARCHAR(16777216) | Destination address of the transaction that produced this record (may be a smart contract).                                                       |
| transaction\_hash          | VARCHAR(16777216) | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain.                                       |
| transaction\_index         | NUMBER(38,0)      | Zero-based position of the transaction within its block. The first transaction in a block has index 0.                                            |
| log\_index                 | NUMBER(38,0)      | Zero-based position of this event log within its transaction. The first log emitted by a transaction has index 0.                                 |
| block\_number              | NUMBER(38,0)      | Sequential number of the block that contains this record. Starts at 0 (genesis) and increments by 1 per block.                                    |
| block\_timestamp           | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the block that contains this record.                                                                                           |
| block\_hash                | VARCHAR(16777216) | Cryptographic hash of the block header that contains this record. Uniquely identifies a block.                                                    |
| unique\_id                 | VARCHAR(16777216) | Allium's deterministic unique identifier for this row, generated from the fields that uniquely identify the record. Stable across full refreshes. |
| \_created\_at              | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was created in the database.                                                                                          |
| \_updated\_at              | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was last updated in the database.                                                                                     |