CREATE, ALTER, and CREATE OR ALTER WAREHOUSE commands: Behavior change with new columns in output (Pending)¶
When this behavior change bundle is enabled, warehouse DDL commands use the GENERATION parameter to identify the generation of a warehouse. You can no longer use the RESOURCE_CONSTRAINT parameter values ‘STANDARD_GEN_1’ or ‘STANDARD_GEN_2’ to identify the generation of a warehouse.
- Before the change:
Using any of CREATE WAREHOUSE, ALTER WAREHOUSE, or CREATE OR ALTER WAREHOUSE to SET the RESOURCE_CONSTRAINT property to STANDARD_GEN_1 or STANDARD_GEN_2, or to UNSET it from those values, was allowed.
- After the change:
Warehouses that used the RESOURCE_CONSTRAINT parameter to identify the warehouse generation retain their values and settings. Use the GENERATION parameter to create new warehouses or alter existing warehouses. Existing records are not affected.
When enabled, this behavior change also adds new columns to the output of the WAREHOUSE_EVENTS_HISTORY view in the ACCOUNT_USAGE schema and the QUERY_HISTORY view in the ORGANIZATION_USAGE schema and ACCOUNT_USAGE schema:
WAREHOUSE_EVENTS_HISTORY in the ORGANIZATION_USAGE and ACCOUNT_USAGE schemas:
Column name |
Data type |
Description |
|---|---|---|
|
TEXT |
The type of warehouse generation.
|
QUERY_HISTORY in the ORGANIZATION_USAGE and ACCOUNT_USAGE schemas:
Column name |
Data type |
Description |
|---|---|---|
|
TEXT |
One of:
This value is only available for WAREHOUSE_CONSISTENT events. Otherwise, this value is NULL. |
The following behavior change is introduced:
Using CREATE WAREHOUSE, ALTER WAREHOUSE, or CREATE OR ALTER WAREHOUSE to SET the RESOURCE_CONSTRAINT property to STANDARD_GEN_1 or STANDARD_GEN_2, or to UNSET it from those values, generates an SQL error similar to:
Ref: 2225