Skip to main content
Skip table of contents

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:

DEFINITION
DEPLOYMENT.COMPUTE_CLUSTER: DDL_WH

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.