SHOW ORGANIZATION ACCOUNTSΒΆ

Lists the organization account of the organization.

Important

Previously, this command was used to list all accounts in the organization, but has been repurposed to list the organization account. If you want to list all accounts in the organization, use SHOW ACCOUNTS.

See also:

CREATE ORGANIZATION ACCOUNT, ALTER ORGANIZATION ACCOUNT

SyntaxΒΆ

SHOW ORGANIZATION ACCOUNTS [ LIKE '<pattern>' ]
Copy

ParametersΒΆ

LIKE 'pattern'

Optionally filters the command output by object name. The filter uses case-insensitive pattern matching, with support for SQL wildcard characters (% and _).

For example, the following patterns return the same results:

... LIKE '%testing%' ...
... LIKE '%TESTING%' ...

. Default: No value (no filtering is applied to the output).

Usage notesΒΆ

  • Only users with the GLOBALORGADMIN role can run this command, which means it can only be run from the organization account.

OutputΒΆ

The command output provides global account properties and metadata in the following columns:

Column

Description

organization_name

Name of the organization.

account_name

User-defined name that identifies an account within the organization.

region_group

Region group where the account is located. Note: This column is only displayed for organizations that span multiple region groups.

snowflake_region

Snowflake Region where the account is located. A Snowflake Region is a distinct location within a cloud platform region that is isolated from other Snowflake Regions. A Snowflake Region can be either multi-tenant or single-tenant (for a Virtual Private Snowflake account).

edition

Snowflake Edition of the account.

account_url

Preferred Snowflake account URL that includes the values of organization_name and account_name.

created_on

Date and time when the account was created.

comment

Comment for the account.

account_locator

System-assigned identifier of the acccount.

account_locator_url

Legacy Snowflake account URL syntax that includes the region_name and account_locator.

managed_accounts

Indicates how many managed accounts have been created by the account.

consumption_billing_entity_name

Name of the consumption billing entity.

marketplace_consumer_billing_entity_name

Name of the marketplace consumer billing entity.

marketplace_provider_billing_entity_name

Name of the marketplace provider billing entity.

old_account_url

If the original account URL was saved when the account was renamed, provides the original URL. If the original account URL was dropped, the value is NULL even if the account was renamed.

is_org_admin

Indicates whether the ORGADMIN role is enabled in an account. If TRUE, the role is enabled.

account_old_url_saved_on

If the original account URL was saved when the account was renamed, provides the date and time when the original account URL was saved.

account_old_url_last_used

If the original account URL was saved when the account was renamed, indicates the last time the account was accessed using the original URL.

organization_old_url

If the account’s organization was changed in a way that created a new account URL and the original account URL was saved, provides the original account URL. If the original account URL was dropped, the value is NULL even if the organization changed.

organization_old_url_saved_on

If the account’s organization was changed in a way that created a new account URL and the original account URL was saved, provides the date and time when the original account URL was saved.

organization_old_url_last_used

If the account’s organization was changed in a way that created a new account URL and the original account URL was saved, indicates the last time the account was accessed using the original account URL.

is_events_account

Indicates whether an account is an events account. For more information, see Configure logging and event tracing for an app.

ExamplesΒΆ

Show information about the organization account:

SHOW ORGANIZATION ACCOUNTS;
Copy