SHOW AVAILABLE LISTINGS and DESCRIBE LISTING commands: Reformat the regions column in output (Preview)¶

Attention

This behavior change is in the 2025_04 bundle.

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

When this behavior change bundle is enabled, the regions column that’s returned in the SHOW AVAILABLE LISTINGS and DESCRIBE AVAILABLE LISTING commands includes the region group prefix.

Before the change:: SHOW AVAILABLE LISTINGS and DESCRIBE AVAILABLE LISTING return a regions column that contains a comma-separated string list of regions in the format snowflake_region. For example: AWS_US_WEST_2.
After the change:: SHOW AVAILABLE LISTINGS and DESCRIBE AVAILABLE LISTING return a reformatted regions column. These commands still return a comma-separated string list of regions, but the format is now region_group.snowflake_region. For example: PUBLIC.AWS_US_WEST_2.

Note

If you have any scripts that call SHOW AVAILABLE LISTINGS or DESCRIBE AVAILABLE LISTING, be sure to parse the regions column to handle this new format.

Ref: 1926