| DIM_BLOCK_ID | TEXT | The surrogate key for the table. Will be unique and is used as a foreign key in other tables |
| BLOCK_ID | NUMBER | ID of the confirmed block |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | Timestamp of block minting(without a timezone) |
| BLOCK_DATE | DATE | Date of block minting(without a timezone) |
| BLOCK_HOUR | NUMBER | Date of block minting(without a timezone) |
| BLOCK_WEEK | NUMBER | Date of block minting(without a timezone) |
| BLOCK_MONTH | NUMBER | The numeric month of block minting(without a timezone) |
| BLOCK_QUARTER | NUMBER | The numeric quarter of block minting(without a timezone) |
| BLOCK_YEAR | NUMBER | The numeric year of block minting(without a timezone) |
| BLOCK_DAYOFMONTH | NUMBER | The numeric day of month of block minting(without a timezone) |
| BLOCK_DAYOFWEEK | NUMBER | The numeric day of week of block minting(without a timezone) |
| BLOCK_DAYOFYEAR | NUMBER | The numeric day of year of block minting(without a timezone) |
| TIMESTAMP | NUMBER | integer value of the block_teimstamp |
| HASH | BINARY | block hash |
| AGG_STATE | BINARY | AGG_STATE column |
| _INSERTED_TIMESTAMP | TIMESTAMP_NTZ | _INSERTED_TIMESTAMP column |
| _AUDIT_RUN_ID | TEXT | _AUDIT_RUN_ID column |
| 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. |
