cosmos.core Table: dim_tokens Type: Base Table
Contains token metadata for assets on the Cosmos blockchain. This table was sourced from an API and
may not contain every token.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCKCHAIN | TEXT | In this table, always Cosmos. Used to join to cross-chain tables. |
| ADDRESS | TEXT | Address unique to an individual wallet, validator, or token. |
| CREATOR | TEXT | Name of the label creator - for now, this will always be “Flipside.” |
| LABEL_TYPE | TEXT | A broad category that describes what a label is representing. |
| LABEL_SUBTYPE | TEXT | Adds more detail to the label type. |
| LABEL | TEXT | The label or name of the address. |
| PROJECT_NAME | TEXT | The name of the project the label belongs to. |
| ALIAS | TEXT | A secondary address for the token, where available |
| DECIMAL | NUMBER | Divide amount by decimal to get the actual amount of currency being transferred. |
| RAW_METADATA | ARRAY | Additional details about the validator or token in json format. |
| UNIQUE_KEY | TEXT | The unique key of the table |
| DIM_TOKENS_ID | TEXT | The unique identifier for each row in the table. |
| 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. |