crosschain.cosmos Table: dim_base_address Type: View
What
This table contains the common base address across all cosmos chains. This table is sourced from available chains and IBC transfers to build the population of known addresses. The bases address is the first 32 characters of the address after the chain prefix has been removed.Columns
| Column Name | Data Type | Description |
|---|---|---|
| BASE_ADDRESS | TEXT | The common base address across all chains |
| BLOCKCHAIN | TEXT | The name of the blockchain |
| ADDRESS | TEXT | The full address |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The MAX blocktimestamp where this address was found on a txfrom address or part of a transfer |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was inserted into the table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was last modified. |
| DIM_BASE_ADDRESS_ID | TEXT | The unique identifier for each row in the table. |