Table Details
| Property | Value |
|---|---|
| Table Name | filecoin.raw.deal_proposals |
| Table Status | Beta 🌱 |
| Unique Key | tipset_timestamp, unique_id |
| Clustering Key(s) | to_date("tipset_timestamp") |
| Search Optimization | message_cid, client_address |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| tipset_height | NUMBER(38,0) | Filecoin tipset height (block height). A tipset is a set of blocks at the same height that form the canonical chain. |
| tipset_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the Filecoin tipset. |
| message_cid | VARCHAR(16777216) | The CID of the message containing the transfer. |
| message_tipset_index | NUMBER(38,0) | Position of this message within its tipset’s ordered message list |
| client_address | VARCHAR(16777216) | Resolved Filecoin address of the storage client |
| market_actor | VARCHAR(16777216) | Address of the Filecoin storage market actor involved in this deal or transaction |
| method_num | NUMBER(38,0) | Numeric identifier of the actor method called by this message |
| params_base64 | VARCHAR(16777216) | Base64-encoded raw bytes of the message parameters before decoding |
| gas_used | VARCHAR(16777216) | Actual number of gas units consumed by this transaction or trace. |
| deal_index | NUMBER(38,0) | Position of this deal within the block’s deal array |
| params_decoded | VARIANT | JSON-decoded message parameters for supported actor methods |
| _error | VARCHAR(16777216) | Internal error or exception recorded during data processing for this row. Null for successful rows. Used for debugging data pipeline issues. |
| unique_id | VARCHAR(16777216) | Allium’s deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |