Managed Account Commands: Changes to Output

Attention

This behavior change is in the 2023_05 bundle.

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

In the current release, the output of the SHOW MANAGED ACCOUNTS and CREATE MANAGED ACCOUNT commands display account URLs consistently across all Snowflake accounts.

Previously

The output of the SHOW MANAGED ACCOUNTS and CREATE MANAGED ACCOUNT commands varied slightly depending on the Snowflake account. The output in some accounts still displayed the legacy account locator URL in the url column and did not include the account_locator_url column.

Currently

Executing SHOW MANAGED ACCOUNTS or CREATE MANAGED ACCOUNT always includes the account name format of the account URL in the url column. The account identifier in this format follows the pattern orgname-account_name.

As part of this change, the account locator format of the URL appears in the account_locator_url column.

Ref: 1193