- Schema:
ACCOUNTS view¶
The ACCOUNTS view in the ORGANIZATION_USAGE schema can be used to obtain details about the accounts in an organization.
Columns¶
Column |
Data Type |
Description |
---|---|---|
ORGANIZATION_NAME |
VARCHAR |
Name of the organization. |
ACCOUNT_NAME |
VARCHAR |
User-defined name that identifies an account within the organization. |
CREATED_ON |
TIMESTAMP |
Date and time when the account was created. |
REGION |
VARCHAR |
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). |
REGION_GROUP |
VARCHAR |
Region group where the account is located. |
EDITION |
VARCHAR |
Snowflake Edition of the account. |
IS_ORG_ADMIN |
BOOLEAN |
Indicates whether the ORGADMIN role is enabled in an account. An account with the ORGADMIN role enabled is called the ORGADMIN account. |
IS_LOCKED |
BOOLEAN |
Indicates whether the account is locked. To determine if it was locked because it was dropped, look for a date and time in the SCHEDULED_DELETION_TIME column. If an account is unexpectedly locked, contact Snowflake Support. |
ACCOUNT_URL |
VARCHAR |
Preferred Snowflake account URL that includes the values of organization_name and account_name. |
ACCOUNT_OLD_URL |
VARCHAR |
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. |
ACCOUNT_OLD_URL_LAST_USED |
VARCHAR |
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 |
VARCHAR |
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_LAST_USED |
VARCHAR |
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. |
ACCOUNT_LOCATOR |
VARCHAR |
System-assigned identifier of the account. |
MANAGED_ACCOUNTS |
VARCHAR |
Indicates how many reader accounts have been created by the account. |
IS_MANAGED |
BOOLEAN |
Indicates whether the account is a reader account. If |
PARENT_ACCOUNT |
VARCHAR |
For reader accounts, provides the name of the parent account that is providing the reader account to consumers. |
CONSUMPTION_BILLING_ENTITY_NAME |
VARCHAR |
Name of the consumption billing entity associated with an account. |
MARKETPLACE_CONSUMER_BILLING_ENTITY_NAME |
VARCHAR |
Name of the marketplace consumer billing entity associated with an account. |
MARKETPLACE_PROVIDER_BILLING_ENTITY_NAME |
VARCHAR |
Name of the marketplace provider billing entity associated with an account. |
ALTERED_ON |
TIMESTAMP |
Date and time of the most recent change to the account. |
SCHEDULED_DELETION_TIME |
TIMESTAMP |
Date and time when a dropped account will be permanently deleted. |
DELETED_ON |
TIMESTAMP |
Date and time when the account was permanently deleted. |
MOVED_ON |
TIMESTAMP |
Date and time when the account was moved from the current organization to a different one. |
COMMENT |
VARCHAR |
Comment associated with the account. |
IS_EVENTS_ACCOUNT |
BOOLEAN |
Indicates whether an account is an events account. For more information, see Configure logging and event tracing for an app. |
Usage notes¶
Latency for the view may be up to 24 hours.
Deleted accounts are removed from the view after one year.