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.