SQL Post-hook executes a Snowflake query after the main query completes.
This query can look at the outcome of the main query and record telemetry information or shutdown idle warehouses. This query is executed in parallel to results return of the main query so main query latency should not be impacted. Additional user queries submitted immediately after the main query returns may be executed prior to or in parallel to this query. This query is typically run within 1-2s after the main query is completed.
- The text of the SQL to run after the user’s query completes
- A post-hook runs asynchronously after the user’s query completes, so if multiple are defined, their run order is undefined
CREATE SUNDECK FLOW MANAGE_WH
POST HOOK SHRINK_WH
CALL my_co.is_after_business_hours() INTO :is_open;
IF (is_open) THEN
ALTER WAREHOUSE my_wh SET warehouse_size=SMALL;
This example creates a flow with a post-hook that sets the warehouse size to
SMALL if running after business hours