Table Details
| Property | Value |
|---|---|
| Table Name | filecoin.raw.sector_events |
| Table Status | Beta 🌱 |
| Unique Key | tipset_timestamp, unique_id |
| Clustering Key(s) | to_date("tipset_timestamp") |
| Search Optimization | miner_address, message_cid |
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 |
| miner_address | VARCHAR(16777216) | Resolved Filecoin address of the storage provider (miner) |
| method_num | NUMBER(38,0) | Numeric identifier of the actor method called by this message |
| method_name | VARCHAR(16777216) | Human-readable name of the contract method called (e.g. transfer, swap). |
| event_type | VARCHAR(16777216) | Type or category of the onchain event that produced this record. The specific values depend on the model (e.g. transfer_single / batch_transfer for ERC-1155, deposit / withdraw for bridges). |
| 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. |
| epoch | NUMBER(38,0) | Epoch number. On Sui, epochs are ~24 hour periods used for validator rotation and staking rewards. On Solana, epochs are voting periods. On Cosmos, epoch is a governance/staking cycle. |
| 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. |