Properties
strategy
• strategy:"remote_statement" | "input_upload" | "residual"
provider
• provider:null | "snowflake" | "databricks" | "duckdb" | "clickhouse"
inputs
• inputs: {table: string ; fields: string[] ; parameter_rows?: number ; predicate_fields?: string[] }[]
output
• output: {name: string ; kind: null | string ; nullable: boolean ; optional: boolean }[]
fragments
•Optional fragments: { id: { kind: "rows" | "aggregate_state" ; node: number } ; node: number ; tables: string[] ; provider: "snowflake" | "databricks" | "duckdb" | "clickhouse" ; output: { name: string ; kind: null | string ; nullable: boolean ; optional: boolean }[] ; validations: ("complete_result" | "exact_cells" | "required_values" | "integer_sum_overflow" | "join_cardinality" | "integer_arithmetic")[] }[]
Source subtrees completed before the remaining cross-source computation.
compute
•Optional compute: Object
Byte budgets of isolated query compute; rows are not a separate budget.
Type declaration
parameter_count
• parameter_count:number
alternatives
•Optional alternatives: { logical_alternative: number ; fragments: { kind: "rows" | "aggregate_state" ; node: number }[] ; join_filters: { build_table: string ; build_field: string ; probe_table: string ; probe_field: string }[] ; join_filter_pricing: null | "overflow" | "estimated" | "unknown_selectivity" | "fragment_estimate_unknown" | "scan_estimate_unknown" | "key_statistics_unknown" | "key_width_unknown" | "dependency_cycle" ; statements: number ; pushed_nodes: number ; estimated_output_bytes: null | number ; estimated_source_work_bytes: null | number ; estimated_source_micros: null | number ; estimated_micros_range?: { few: null | number ; many: null | number } ; compute: { model: "fixed_prior" ; input_micros: null | number ; operator_micros: null | number ; validation_micros: null | number ; spill_micros: null | number ; working_bytes: null | number ; spill_io_bytes: null | number } ; local_input_bytes: number ; selected: boolean }[]
search_budget_exhausted
•Optional search_budget_exhausted: boolean
search
•Optional search: Object
Deterministic search evidence; absent for whole-source execution.
Type declaration
cardinalities
•Optional cardinalities: { tables: string[] ; rows: null | number ; output_bytes: null | number ; basis: "unknown" | "statistics" | "heuristic" | "override" }[]
Estimated rows per relation set of the query. Estimates, never bounds.
statistics
•Optional statistics: { table: string ; status: "unavailable" | "fetched" | "cached" | "local" | "withheld" | "observed_restricted" | "not_requested" ; rows: null | number ; rows_origin: null | "observed" | "local" | "catalog" | "analyzed" | "feedback" ; data_bytes: null | number ; observed_columns: number ; columns?: { field: string ; distinct: null | "observed" | "local" | "catalog" | "analyzed" | "feedback" ; null_fraction: null | "observed" | "local" | "catalog" | "analyzed" | "feedback" ; bounds: null | "observed" | "local" | "catalog" | "analyzed" | "feedback" }[] ; age_ms: null | number ; versioned: boolean ; analysis?: { age_ms: number ; versioned: boolean } ; filtered?: { origin: "observed" | "feedback" ; fields: string[] ; min_rows: number ; max_rows: number ; samples: number ; age_ms: null | number ; versioned: boolean } }[]
Source statistics behind the estimates. Whole-table values appear only
for unrestricted reads; an observed_restricted input’s values describe
exactly its restricted read.
selection
•Optional selection: "single_source_observation" | "comparable_cost_estimate" | "robust_cost_estimate" | "structural_preference" | "qualification_alternative"
Why the complete implementation was selected. Estimates never imply authority.
rules
•Optional rules: { tables: string[] ; rule: "aggregate_before_join" | "join_reorder" | "predicate_pushdown" | "derived_predicate" | "top_n_pushdown" }[]
Transformations applied to the selected logical expression.
constraints
•Optional constraints: { tables: string[] ; reason: "parameter_relation_unsupported" | "validation_barrier" | "operator_unsupported" | "disclosure_refused" | "input_shape_bound" }[]
Execution properties that an offered source implementation could not satisfy.
calibration
•Optional calibration: { tables: string[] ; provider: "snowflake" | "databricks" | "duckdb" | "clickhouse" ; profile: { statement_micros: number ; statement_origin: "prior" | "measured" ; bytes_per_ms: number ; throughput_origin: "prior" | "measured" ; work_bytes_per_ms: number ; work_origin: "prior" | "measured" ; samples: number ; usable_samples: number } ; recorded: number }[]
The total response profile each source connection’s statements were priced
with: fitted from its recorded statements (measured) or the provider’s
fixed prior. Estimates, never bounds.
logical_alternatives
•Optional logical_alternatives: { origin: "written" | "memo" ; enumeration: null | "exact" | "bounded" ; tree: string ; statements: number ; estimated_source_micros: null | number ; estimated_compute_micros: null | number ; selected: boolean }[]
Retained logical alternatives, the written expression first. Complete implementations
identify their logical alternative and its negotiated fragments.
max_rows
• max_rows:number
max_bytes
• max_bytes:number
validations
• validations: ("complete_result" | "exact_cells" | "required_values" | "integer_sum_overflow" | "join_cardinality" | "integer_arithmetic")[]
crossings
•Optional crossings: { crossing: { kind: "rows" ; fields: string[] ; from: string ; to: { site: “compute”; } } | { kind: "state" ; fields: string[] ; from: string ; to: { site: “compute”; } } | { kind: "keys" ; fields: string[] ; from: string ; to: { target: string; source: string; site: “source”; } } | { kind: "range" ; fields: string[] ; from: string ; to: { target: string; source: string; site: “source”; } } | { kind: "values" ; fields: string[] ; from: null | string ; to: { target: string; source: string; site: “source”; } } ; decision: "refused" | "admitted" | "implied" | "unasked" ; estimated_bytes: null | number }[]
What the plan moves between sites and how each crossing was decided:
field names, never values. implied crossings follow from admitted rows
or keys of the same fields.