| program_id | VARCHAR(44) | Base58-encoded public key of the Solana program that processed this instruction (e.g. TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA for SPL Token). |
| program_name | VARCHAR(40) | Human-readable name of the Solana program (e.g. “spl_token”, “system_program”, “jupiter_v6”). Resolved from Allium’s program registry. |
| min_date | VARCHAR(23) | Earliest block timestamp from which decoding is attempted for this program. |
| use_live_idl | BOOLEAN | Config flag: fetch and apply the IDL directly from the onchain IDL account in real-time. |
| use_latest_idl | BOOLEAN | Config flag: always use the latest known IDL version regardless of deployment history. |
| use_override_idls | BOOLEAN | Config flag: use manually defined override IDLs instead of auto-detected onchain ones. |
| use_deconflicted_idl_source | BOOLEAN | Config flag: use the curated deconflicted IDL source instead of the live onchain IDL when both are available. |
| use_microbatch_via_var | BOOLEAN | Config flag: enable microbatch ingestion strategy via dbt variable for this program. |
| warehouse_override | VARCHAR(10) | Optional override for the Snowflake warehouse used to process this program’s data. |
| decoder_type | VARCHAR(6) | Decode strategy for this program: anchor for standard Anchor IDL decoding, or a custom program-specific decoder. |
| tags | ARRAY | Original category tokens from API |
| events_variant | VARCHAR(11) | Variant name for the event decode configuration, allowing multiple event schemas per program version. |
| effective_idl_source | VARCHAR(16777216) | IDL source actually used for decoding: anchor (onchain), manual (override), or live (realtime fetch). |
| idl | VARIANT | Full Interface Definition Language (IDL) JSON schema for this program version, used to decode instruction and event data. |
| idl_sig | VARCHAR(16777216) | Hash signature of the IDL JSON content, used for integrity checking and deduplication. |
| idl_updated_at | TIMESTAMP_NTZ(9) | Timestamp when this IDL was registered or last updated in Allium’s decoder registry. |
| idl_index | NUMBER(18,0) | Sequence number of this IDL version within this program’s history. |
| idl_min_pseudo_global_order | NUMBER(38,0) | Lowest pseudo-global order value of instructions decoded using this IDL. Used to determine IDL applicability range. |
| idl_max_pseudo_global_order | NUMBER(38,0) | Highest pseudo-global order value of instructions decoded using this IDL. Used to determine IDL applicability range. |
| config_status | VARCHAR(18) | Validation status of the program’s decode configuration (valid, invalid, or pending). |
