POST

A POST load step is executed after automatically generated loads steps.

See also:

• PRE

• CONFIG_LOAD_TEMPLATES

• Variables

Usage

POST: sql_code

Notes

POST steps are used mainly with automatically generated loads but they can also be used with other load step types.

POST steps can be saved as part of a load template.

POST steps can use variables inside the SQL code.

Examples

Decrease Snowflake virtual warehouse size after a data load

Create a POST step to scale DEMO_WH virtual warehouse down to x-small after data load to minimize costs:

POST:

ALTER WAREHOUSE "DEMO_WH" 
SET WAREHOUSE_SIZE = 'x-small' 
AUTO_SUSPEND = 300 
AUTO_RESUME = TRUE 
MIN_CLUSTER_COUNT = 1 
MAX_CLUSTER_COUNT = 1 
COMMENT = 'standard-server warehouse for ETL and most analytics';

Executed SQL after load:

ALTER WAREHOUSE "DEMO_WH" 
SET WAREHOUSE_SIZE = 'x-small' 
AUTO_SUSPEND = 300 
AUTO_RESUME = TRUE 
MIN_CLUSTER_COUNT = 1 
MAX_CLUSTER_COUNT = 1 
COMMENT = 'standard-server warehouse for ETL and most analytics';