DEPLOYMENT.COMPUTE_CLUSTER

Target database: Snowflake

DEPLOYMENT.COMPUTE_CLUSTER physical option enables defining the compute cluster to be used for running the DDL commands of an entity.

Usage

Prepare a warehouse in Snowflake and set it for an entity with physical option DEPLOYMENT.COMPUTE_CLUSTER.

Examples

Snowflake: Specifying a warehouse for running entity DDL commands

Prerequisites:

• Create a warehouse in Snowflake, e.g. "DDL_WH"

• Grant privileges on the warehouse to the role(s) used by Agile Data Engine

Set physical option for an entity:

DEPLOYMENT.COMPUTE_CLUSTER: DDL_WH

Entity DDLs will be executed in Snowflake with the defined warehouse.