Snowflake · Schema

Account

Snowflake account object.

Data LakesData SharingData WarehousingDatabaseSQL

Properties

Name Type Description
organization_name string Name of the organization.
region_group string Region group where the account is located. Note - This column is only displayed for organizations that span multiple region groups.
region string 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
edition string Snowflake Edition of the account.
created_on string Date and time the account was created.
account_url string Preferred Snowflake account URL that includes the values of organization_name and account_name.
account_locator string System-assigned identifier of the acccount.
account_locator_url string Legacy Snowflake account URL syntax that includes the region_name and account_locator.
managed_accounts integer Indicates how many managed accounts have been created by the account.
consumption_billing_entity_name string Name of the consumption billing entity.
marketplace_consumer_billing_entity_name string Name of the marketplace consumer billing entity.
marketplace_provider_billing_entity_name string Name of the marketplace provider billing entity.
old_account_url string 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
comment string Optional comment in which to store information related to the account.
is_org_admin boolean Indicates whether the ORGADMIN role is enabled in an account. If TRUE, the role is enabled.
retention_time integer Number of days that historical data is retained for Time Travel.
dropped_on string Date and time the account was dropped.
scheduled_deletion_time string Date and time when the account is scheduled to be permanently deleted. Accounts are deleted within one hour after the scheduled time.
restored_on string Date and time when the account was last restored.
account_old_url_saved_on string 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 string 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 string 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, th
organization_old_url_saved_on string 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 string 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 UR
organization_URL_expiration_on string 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 will be dropped. Drop
moved_on string Date and time when the account was moved to a different organization.
is_events_account boolean Indicates whether an account is an events account. For more information, see Set up logging and event sharing for an application.
moved_to_organization string If the account was moved to a different organization, provides the name of that organization.
admin_name string Name of the account administrator.
admin_password string Password for the account administrator.
admin_rsa_public_key string RSA public key for the account administrator.
admin_user_type string User type of the account administrator.
first_name string First name of the account administrator.
last_name string Last name of the account administrator.
email string Email address of the account administrator.
must_change_password boolean Indicates whether the account administrator must change the password at the next login.
polaris boolean Indicates whether the account is a Polaris account.
View JSON Schema on GitHub