SHOW WAREHOUSES command: New column in output (Preview)¶

Attention

This behavior change is in the 2025_07 bundle.

For the current status of the bundle, refer to Bundle History.

When this behavior change bundle is enabled, the SHOW WAREHOUSES command output includes the following new column:

Column name	Data type	Description
`generation`	VARCHAR	A positive integer, currently either `1` or `2`. The VARCHAR type enables keyword values to be used in the future.

This new column lets you check which of your standard warehouses are Gen1 or Gen2.

Ref: 2110