snowflake_query_compilation_time_avg

Time spent executing the query

Dimensions:None

Technical Annotations (28)

Configuration Parameters (2)

STATEMENT_TIMEOUT_IN_SECONDSrecommended: 3600

Sets maximum query execution time; increase for long operations

WAREHOUSE_SIZErecommended: LARGE

Scale up for resource-intensive queries

Error Signatures (3)

100038error code

Query Execution Timeoutlog pattern

version mismatch errorserror code

CLI Commands (4)

ALTER SESSION SET STATEMENT_TIMEOUT_IN_SECONDS = 3600;remediation

ALTER WAREHOUSE my_warehouse SET WAREHOUSE_SIZE = 'LARGE';remediation

EXPLAIN PLANdiagnostic

SELECT SYSTEM$CLUSTERING_INFORMATION('test2', '(col1, col3)');diagnostic

Technical References (19)

snowflake.account_usage.query_historycomponentpartitions_scannedconceptQuery ProfilecomponentQUERY_HISTORY viewcomponentQUERY_HISTORYcomponentACCOUNT_USAGEcomponentACCOUNTADMINcomponentmicro-partitioningconceptclustering keysconceptvirtual warehousescomponentauto-scalingcomponentclustered columnscomponentmaterialized viewscomponentquery profilescomponentmicro-partitionsconceptoverlap depthconceptconstant micro-partitionsconceptCartesian joinconceptpartition hotspotsconcept

Related Insights (12)

Slow queries exceeding 60 seconds indicate performance bottleneckswarning

▸

Query execution timeout exceeds statement limitwarning

▸

Query performance degradation without profiling analysiswarning

▸

Queries consuming excessive resources or execution timewarning

▸

Operations take extended time to complete during version mismatchwarning

▸

Runaway queries without timeout limits consume excessive creditswarning

▸

Poor query optimization degrades performance despite auto-partitioningwarning

▸

Oversized or undersized warehouses causing waste or bottleneckswarning

▸

Inefficient queries with unnecessary table scans and missing filterswarning

▸

Poor table clustering degrades query performancewarning

▸

Skewed joins and Cartesian products spike warehouse runtimewarning

▸

Unoptimized queries drive unpredictable Snowflake credit consumptionwarning

▸