Documentation Index
Fetch the complete documentation index at: https://docs.allium.so/llms.txt
Use this file to discover all available pages before exploring further.
Table Details
| Property | Value |
|---|---|
| Table Name | solana_testnet.raw.instructions |
| Table Status | Beta 🌱 |
| Unique Key | instruction_index, txn_id, block_timestamp |
| Clustering Key(s) | to_date("block_timestamp") |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| block_slot | NUMBER(38,0) | Slot of the block containing this instruction. |
| block_height | NUMBER(38,0) | Height of the block containing this instruction. |
| block_timestamp | TIMESTAMP_NTZ(9) | Estimated production time of the containing block, as Unix timestamp. |
| block_hash | VARCHAR(16777216) | Blockhash of the containing block. |
| txn_id | VARCHAR(16777216) | The transaction signature (id) this instruction belongs to. |
| txn_index | NUMBER(38,0) | Position of the transaction within its block. |
| instruction_index | NUMBER(38,0) | Position of this instruction within its transaction. |
| program_id | VARCHAR(16777216) | The program (smart contract) account that executes this instruction. |
| parsed | VARCHAR(16777216) | Parsed/decoded JSON form of the instruction data, if recognised by Solana’s parser. |
| program_name | VARCHAR(16777216) | Human-readable name of the program, if known. |
| accounts | VARIANT | List of account addresses referenced by this instruction (in order). |
| data | VARCHAR(16777216) | Raw instruction data, base58-encoded. |
| parsed_type | VARCHAR(16777216) | The instruction type tag from the parsed JSON (e.g. “transfer”, “createAccount”). |
| is_voting | BOOLEAN | True if the parent transaction is a consensus vote transaction. |
| parent_tx_success | BOOLEAN | True if the parent transaction succeeded. |
| parent_tx_signer | VARCHAR(16777216) | Primary signer (fee payer) of the parent transaction. |
| inner_instruction_count | NUMBER(38,0) | Number of inner instructions produced by this outer instruction. |
| data_hex | VARCHAR(16777216) | Raw instruction data as a hex string. |
| data_hex_first2 | VARCHAR(16777216) | First 2 hex characters (1 byte) of the data — commonly the instruction discriminator. |
| data_hex_first16 | VARCHAR(16777216) | First 16 hex characters (8 bytes) of the data — commonly the Anchor/borsh discriminator. |
| stack_height | NUMBER(38,0) | Cross-program invocation (CPI) stack depth at which this instruction executed. |
| _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. |