Queued Duration

Condition

Query is stuck in QUEUED status. It is usually caused by having too many queries trying to run in parallel on the same warehouse at the same time.

How to fix

• Consider using multi-cluster warehouse.

• Move workload to another warehouse.

• Add concurrency limits for ETL and reporting jobs.

One Snowflake warehouse instance can normally run up to 8 small queries in parallel with default settings. This amount can be increased.

Example

    QueuedDurationCondition(
        notice_duration=60 * 30,  # query was in queue for 30 minutes
    ),

Specific arguments

None. Only standard duration arguments are applied for this checker.