Skip to main content

Interface: SnowflakeWarehouseProps

Defined in: packages/depot-cdk/src/stage-depot-common.ts:26

Interface to represent a Snowflake Warehouse resource's properties.

Properties​

autoSuspend?​

readonly optional autoSuspend?: number

Defined in: packages/depot-cdk/src/stage-depot-common.ts:57

Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.

maxClusterCount?​

readonly optional maxClusterCount?: number

Defined in: packages/depot-cdk/src/stage-depot-common.ts:51

1-10 - Specifies the maximum number of clusters for a multi-cluster warehouse. For a single-cluster warehouse, this value is always 1.

maxConcurrencyLevel?​

readonly optional maxConcurrencyLevel?: number

Defined in: packages/depot-cdk/src/stage-depot-common.ts:60

Object parameter that specifies the concurrency level for SQL statements (i.e. queries and DML) executed by a warehouse cluster.

minClusterCount?​

readonly optional minClusterCount?: number

Defined in: packages/depot-cdk/src/stage-depot-common.ts:48

1-10 - Specifies the minimum number of clusters for a multi-cluster warehouse (only applies to multi-cluster warehouses).

name​

readonly name: string

Defined in: packages/depot-cdk/src/stage-depot-common.ts:28

Warehouse name

scalingPolicy?​

readonly optional scalingPolicy?: "STANDARD" | "ECONOMY"

Defined in: packages/depot-cdk/src/stage-depot-common.ts:54

Specifies the policy for automatically starting and shutting down clusters in a multi-cluster warehouse running in Auto-scale mode.

size?​

readonly optional size?: "XSMALL" | "SMALL" | "MEDIUM" | "LARGE" | "XLARGE" | "XXLARGE" | "XXXLARGE" | "X4LARGE" | "X5LARGE" | "X6LARGE"

Defined in: packages/depot-cdk/src/stage-depot-common.ts:32

Specifies the size of the virtual warehouse. The size determines the amount of compute resources in each cluster in the warehouse and, therefore, the number of credits consumed while the warehouse is running

statementQueuedTimeoutSeconds?​

readonly optional statementQueuedTimeoutSeconds?: number

Defined in: packages/depot-cdk/src/stage-depot-common.ts:63

Object parameter that specifies the time, in seconds, a SQL statement (query, DDL, DML, etc.) can be queued on a warehouse before it is canceled by the system.

statementTimeoutSeconds?​

readonly optional statementTimeoutSeconds?: number

Defined in: packages/depot-cdk/src/stage-depot-common.ts:66

Amount of time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system.

warehouseType?​

readonly optional warehouseType?: "STANDARD" | "SNOWPARK-OPTIMIZED"

Defined in: packages/depot-cdk/src/stage-depot-common.ts:45

Specifies the warehouse type