Table Details
| Property | Value |
|---|---|
| Table Name | osmosis.raw.blocks |
| Table Status | Production-Ready |
| Unique Key | timestamp, height |
| Clustering Key(s) | to_date("timestamp") |
| Search Optimization | height, hash |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| height | NUMBER(38,0) | The sequential number of the block in the blockchain. |
| timestamp | TIMESTAMP_NTZ(9) | The timestamp when the block was created. |
| hash | VARCHAR(16777216) | The hash of the block. |
| parent_hash | VARCHAR(16777216) | The hash of the parent block. |
| proposer_address | VARCHAR(16777216) | The address of the proposer who created the block. |
| transaction_count | NUMBER(38,0) | The number of transactions included in the block. |
| consensus_hash | VARCHAR(16777216) | The hash of the block’s consensus state. |
| app_hash | VARCHAR(16777216) | The hash of the application state. |
| block_id | VARIANT | The block identifier as a JSON object. |
| chain_id | VARCHAR(16777216) | The identifier of the blockchain. |
| data | VARIANT | The block data as a JSON object. |
| data_hash | VARCHAR(16777216) | The hash of the block’s data. |
| evidence | VARIANT | Evidence associated with the block as a JSON object. |
| evidence_hash | VARCHAR(16777216) | The hash of the evidence associated with the block. |
| last_block_id | VARIANT | The previous block identifier as a JSON object. |
| last_commit | VARIANT | The last commit information as a JSON object. |
| last_commit_hash | VARCHAR(16777216) | The hash of the last commit. |
| last_results_hash | VARCHAR(16777216) | The hash of the last results. |
| next_validators_hash | VARCHAR(16777216) | The hash of the next set of validators. |
| validators_hash | VARCHAR(16777216) | The hash of the current set of validators. |
| version | VARIANT | The version information as a JSON object. |
| block_result | VARIANT | The block result as a JSON object. |
| block_event_count | NUMBER(38,0) | The number of block events in the block. |
| block_event_attribute_count | NUMBER(38,0) | The number of block event attributes in the block. |
| _created_at | TIMESTAMP_NTZ(9) | The timestamp when the entry was created. |
| _updated_at | TIMESTAMP_NTZ(9) | The timestamp when the entry was updated. |