osmosis.core Table: dim_tokens Type: View
Contains token metadata for assets on the Osmosis 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 Osmosis. Used to join to cross-chain tables. This column will deprecate in all tables except core.fact_blocks soon. Please modify your queries to join to the blocks table to use this field. |
| 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 the amount by POW(10, decimal) to get the amount used in the transaction. This value can be NULL, as decimals are hand curated from an outside source and not found on-chain. |
| RAW_METADATA | ARRAY | Additional details about the validator or token in json format. |
| DIM_TOKENS_ID | TEXT | |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ |