crosschain.core Table: dim_tags Type: View
What
Holds data for our address tags.Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCKCHAIN | TEXT | The blockchain that the address belongs to. |
| CREATOR | TEXT | Who created the tag. ‘flipside’ for official flipside tags. |
| ADDRESS | TEXT | The address of the contract or wallet the tag describes. |
| TAG_NAME | TEXT | Tag name (sub-category). |
| TAG_TYPE | TEXT | Tag type (high-level category). |
| START_DATE | TIMESTAMP_NTZ | Date the tag first applies. For tags that are permanent, this might be the date the address had its first behavior that warrants its tag, or the addresses’ first transaction. |
| END_DATE | TIMESTAMP_NTZ | Date the tag no longer applies (for tags that are permanent or currently active, end_date can be NULL). |
| TAG_CREATED_AT | TIMESTAMP_LTZ | Date the tag was added to our data. |
| 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_TAGS_ID | TEXT | The unique identifier for each row in the table. |