Table Details
| Property | Value |
|---|---|
| Table Name | solana.decoded.programs |
| Table Status | Production-Ready |
| Unique Key | program_id |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| program_id | VARCHAR(44) | Base58-encoded public key of the Solana program that processed this instruction (e.g. TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA for SPL Token). |
| deploy_count | NUMBER(18,0) | Number of times this program has been deployed or upgraded via the BPF Loader. |
| first_deployed_block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of this program’s first deployment on-chain. |
| first_deployed_block_slot | NUMBER(38,0) | Slot number of the transaction containing this program’s first deployment. |
| first_deployed_txn_index | NUMBER(38,0) | Position of the first deployment transaction within its slot. |
| first_deployed_txn_id | VARCHAR(88) | Transaction signature of the program’s first deployment. |
| last_deployed_block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of this program’s most recent deployment or upgrade. |
| last_deployed_block_slot | NUMBER(38,0) | Slot number of the transaction containing this program’s most recent deployment or upgrade. |
| last_deployed_txn_index | NUMBER(38,0) | Position of the latest upgrade transaction within its slot. |
| last_deployed_txn_id | VARCHAR(88) | Transaction signature of the program’s most recent upgrade. |
| last_onchain_idl | VARIANT | Most recent IDL fetched directly from the program’s onchain IDL account. |
| last_onchain_idl_source | VARCHAR(6) | Source of the most recent onchain IDL (anchor, manual, or live). |
| last_onchain_idl_updated_at | TIMESTAMP_NTZ(9) | Timestamp of the most recent update to the onchain IDL account. |
| is_valid_idl | BOOLEAN | Whether this IDL passes basic structural validation (well-formed JSON with required fields). |
| idl_info | VARIANT | JSON object containing IDL metadata: source, version, and validation status. |