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