solana.price Table: dim_asset_metadata Type: View
A comprehensive dimensional table holding asset metadata and other relevant details pertaining to
each id, from multiple providers. This data set includes raw, non-transformed data coming directly
from the provider APIs and rows are not intended to be unique. As a result, there may be data
quality issues persisting in the APIs that flow through to this dimensional model. If you are
interested in using a curated data set instead, please utilize ez_asset_metadata.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| TOKEN_ADDRESS | TEXT | The specific address representing the asset on a specific platform. This will be NULL if referring to a native asset. |
| ASSET_ID | TEXT | The unique identifier representing the asset. |
| SYMBOL | TEXT | The symbol of asset. |
| NAME | TEXT | The name of asset. |
| BLOCKCHAIN | TEXT | The Blockchain, Network, or Platform for this asset. |
| BLOCKCHAIN_ID | TEXT | The unique identifier of the Blockchain, Network, or Platform for this asset. |
| PROVIDER | TEXT | The provider or source of the data. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp when this transaction record was first inserted into the analytics database. Used for data freshness tracking and incremental model logic. Format: YYYY-MM-DD HH:MI:SS. Not derived from the blockchain, but from the ETL process. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp when this transaction record was last updated in the analytics database. Used for tracking updates and supporting incremental model logic. Format: YYYY-MM-DD HH:MI:SS. Not derived from the blockchain, but from the ETL process. |
| DIM_ASSET_METADATA_ID | TEXT | A unique, stable identifier for each record in this table. The primary key (PK) ensures that every row is uniquely identifiable and supports efficient joins, lookups, and data integrity across models. The PK may be a natural key (such as a blockchain transaction hash) or a surrogate key generated from one or more fields, depending on the table’s structure and requirements. |