Try Opteryx

System Variables

Opteryx exposes 54 system variables. Use SHOW VARIABLES to see the ones your session can read, and SET to change the ones you are permitted to change.

!!! note Most system variables are not settable from SQL. A session runs at the USER tier, so only USER-owned variables are reachable by SET at all, and those marked RESTRICTED additionally require the platform_admin entitlement. Everything else is fixed by the server or stamped per session.

Settable by any session

Variable Type Default
like_selectivity_decay FLOAT64 env LIKE_SELECTIVITY_DECAY
match_threshold FLOAT64 env MATCH_THRESHOLD
trace BOOLEAN env OPTERYX_TRACE

Settable with platform_admin

These are USER-owned but RESTRICTED, so they are hidden from SHOW VARIABLES and refused by SET unless the caller holds the platform_admin entitlement.

Variable Type Default
disable_http2 BOOLEAN env OPTERYX_HTTP_DISABLE_HTTP2
disable_http_multiplexing BOOLEAN env OPTERYX_HTTP_DISABLE_MULTIPLEXING
http_max_connections_per_host INT64 env OPTERYX_HTTP_MAX_HOST_CONNECTIONS
http_max_retries INT64 env OPTERYX_HTTP_MAX_RETRIES
http_min_bandwidth_mbps FLOAT64 env OPTERYX_HTTP_MIN_BW_MBPS
http_pipewait BOOLEAN env OPTERYX_HTTP_PIPEWAIT
http_request_timeout_floor_ms INT64 env OPTERYX_HTTP_TIMEOUT_FLOOR_MS
max_execution_workers INT64 env MAX_EXECUTION_WORKERS
parquet_gcs_io_workers INT64 env PARQUET_GCS_IO_WORKERS
parquet_io_coalesce_max_bytes INT64 env PARQUET_IO_COALESCE_MAX_BYTES
parquet_io_coalesce_waste_ratio FLOAT64 env PARQUET_IO_COALESCE_WASTE_RATIO
parquet_io_in_flight_limit INT64 env PARQUET_IO_IN_FLIGHT_LIMIT
parquet_local_io_workers INT64 env PARQUET_LOCAL_IO_WORKERS

Not settable from SQL

Read-only from a session. Server-owned values are fixed when the server starts; session-identity values are stamped from the connection.

Variable Type Default
access_policies ARRAY per session
architecture ARRAY detected from the host
array_agg_max_values_per_group INT64 env ARRAY_AGG_MAX_VALUES_PER_GROUP
billing_account VARCHAR per session
character_set_client VARCHAR utf8
cpu_count INT64 detected from the host
default_storage_engine VARCHAR rugo-parquet
disable_gc_during_query BOOLEAN env OPTERYX_DISABLE_GC_DURING_QUERY
disable_optimizer BOOLEAN env DISABLE_OPTIMIZER
external_user VARCHAR per session
footer_remote_location VARCHAR env OPTERYX_FOOTER_CACHE_LOCATION
gcp_project_id VARCHAR env GCP_PROJECT_ID
instrument_engine BOOLEAN env OPTERYX_INSTRUMENT_ENGINE
job_retention_days INT64 14
kvstore_key_prefix VARCHAR env KVSTORE_KEY_PREFIX
kvstore_location VARCHAR env KVSTORE_LOCATION
local_store_root VARCHAR env OPTERYX_LOCAL_STORE
manifest_cache_bytes INT64 env OPTERYX_MANIFEST_CACHE_BYTES
manifest_cache_path VARCHAR env OPTERYX_MANIFEST_CACHE_PATH
manifest_remote_location VARCHAR env OPTERYX_MANIFEST_CACHE_LOCATION
max_consecutive_cache_failures INT64 env MAX_CONSECUTIVE_CACHE_FAILURES
max_execution_time INT64 1200
max_sql_length INT64 256000
memory_limit_bytes INT64 detected from the host
operating_system VARCHAR detected from the host
opteryx_debug BOOLEAN env OPTERYX_DEBUG
parquet_late_materialization_abandon_after INT64 env PARQUET_LATE_MATERIALIZATION_ABANDON_AFTER
parquet_late_materialization_max_selectivity FLOAT64 env PARQUET_LATE_MATERIALIZATION_MAX_SELECTIVITY
physical_memory_bytes INT64 detected from the host
python_version VARCHAR detected from the host
result_retention_days INT64 7
sql_mode VARCHAR opteryx
sql_select_limit INT64 1073741824
system_time_zone VARCHAR UTC
user_entitlements ARRAY per session
user_memberships ARRAY per session
validate_optimizer_plans BOOLEAN env VALIDATE_OPTIMIZER_PLANS
version VARCHAR from the build

Where defaults come from

  • env KEY — read from that environment variable when the server starts. The shipped fallback lives in the engine's configuration, not here: recording a value generated on one machine would describe that machine rather than the product.
  • detected from the host — derived at startup (CPU count, memory limits, platform).
  • per session — identity asserted by the connecting service, not configuration. See SHOW USER and SHOW GRANTS.