Snowflake · Schema

Account

Snowflake account object.

Data LakesData SharingData WarehousingDatabaseSQL

Properties

Name	Type	Description
organization_name	string	Name of the organization.
name	object	User-defined name that identifies an account within 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

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "#/components/schemas/Account",
  "title": "Account",
  "type": "object",
  "description": "Snowflake account object.",
  "properties": {
    "organization_name": {
      "type": "string",
      "readOnly": true,
      "description": "Name of the organization.",
      "example": "example_value"
    },
    "name": {
      "$ref": "./common.yaml#/components/schemas/Identifier",
      "description": "User-defined name that identifies an account within the organization."
    },
    "region_group": {
      "type": "string",
      "description": "Region group where the account is located. Note - This column is only displayed for organizations that span multiple region groups.",
      "example": "example_value"
    },
    "region": {
      "type": "string",
      "description": "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).",
      "example": "example_value"
    },
    "edition": {
      "type": "string",
      "description": "Snowflake Edition of the account.",
      "enum": [
        "STANDARD",
        "ENTERPRISE",
        "BUSINESS_CRITICAL"
      ],
      "example": "STANDARD"
    },
    "created_on": {
      "type": "string",
      "format": "date-time",
      "readOnly": true,
      "description": "Date and time the account was created.",
      "example": "2026-01-15T10:30:00Z"
    },
    "account_url": {
      "type": "string",
      "readOnly": true,
      "description": "Preferred Snowflake account URL that includes the values of organization_name and account_name.",
      "example": "https://www.example.com"
    },
    "account_locator": {
      "type": "string",
      "readOnly": true,
      "description": "System-assigned identifier of the acccount.",
      "example": "example_value"
    },
    "account_locator_url": {
      "type": "string",
      "readOnly": true,
      "description": "Legacy Snowflake account URL syntax that includes the region_name and account_locator.",
      "example": "https://www.example.com"
    },
    "managed_accounts": {
      "type": "integer",
      "readOnly": true,
      "format": "int64",
      "description": "Indicates how many managed accounts have been created by the account.",
      "example": 10
    },
    "consumption_billing_entity_name": {
      "type": "string",
      "readOnly": true,
      "description": "Name of the consumption billing entity.",
      "example": "example_value"
    },
    "marketplace_consumer_billing_entity_name": {
      "type": "string",
      "readOnly": true,
      "description": "Name of the marketplace consumer billing entity.",
      "example": "example_value"
    },
    "marketplace_provider_billing_entity_name": {
      "type": "string",
      "readOnly": true,
      "description": "Name of the marketplace provider billing entity.",
      "example": "example_value"
    },
    "old_account_url": {
      "type": "string",
      "readOnly": true,
      "description": "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",
      "example": "https://www.example.com"
    },
    "comment": {
      "type": "string",
      "description": "Optional comment in which to store information related to the account.",
      "example": "example_value"
    },
    "is_org_admin": {
      "type": "boolean",
      "readOnly": true,
      "description": "Indicates whether the ORGADMIN role is enabled in an account. If TRUE, the role is enabled.",
      "example": true
    },
    "retention_time": {
      "type": "integer",
      "readOnly": true,
      "description": "Number of days that historical data is retained for Time Travel.",
      "example": 10
    },
    "dropped_on": {
      "type": "string",
      "format": "date-time",
      "readOnly": true,
      "nullable": true,
      "description": "Date and time the account was dropped.",
      "example": "2026-01-15T10:30:00Z"
    },
    "scheduled_deletion_time": {
      "type": "string",
      "format": "date-time",
      "readOnly": true,
      "nullable": true,
      "description": "Date and time when the account is scheduled to be permanently deleted. Accounts are deleted within one hour after the scheduled time.",
      "example": "2026-01-15T10:30:00Z"
    },
    "restored_on": {
      "type": "string",
      "format": "date-time",
      "readOnly": true,
      "nullable": true,
      "description": "Date and time when the account was last restored.",
      "example": "2026-01-15T10:30:00Z"
    },
    "account_old_url_saved_on": {
      "type": "string",
      "format": "date-time",
      "readOnly": true,
      "description": "If the original account URL was saved when the account was renamed, provides the date and time when the original account URL was saved.",
      "example": "2026-01-15T10:30:00Z"
    },
    "account_old_url_last_used": {
      "type": "string",
      "format": "date-time",
      "readOnly": true,
      "description": "If the original account URL was saved when the account was renamed, indicates the last time the account was accessed using the original URL.",
      "example": "2026-01-15T10:30:00Z"
    },
    "organization_old_url": {
      "type": "string",
      "readOnly": true,
      "description": "If the account\u2019s 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.",
      "example": "https://www.example.com"
    },
    "organization_old_url_saved_on": {
      "type": "string",
      "readOnly": true,
      "format": "date-time",
      "description": "If the account\u2019s 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.",
      "example": "2026-01-15T10:30:00Z"
    },
    "organization_old_url_last_used": {
      "type": "string",
      "readOnly": true,
      "format": "date-time",
      "description": "If the account\u2019s 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.",
      "example": "2026-01-15T10:30:00Z"
    },
    "organization_URL_expiration_on": {
      "type": "string",
      "format": "date-time",
      "readOnly": true,
      "nullable": true,
      "description": "If the account\u2019s 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. Dropped URLs cannot be used to access the account.",
      "example": "2026-01-15T10:30:00Z"
    },
    "moved_on": {
      "type": "string",
      "format": "date-time",
      "readOnly": true,
      "nullable": true,
      "description": "Date and time when the account was moved to a different organization.",
      "example": "2026-01-15T10:30:00Z"
    },
    "is_events_account": {
      "type": "boolean",
      "readOnly": true,
      "description": "Indicates whether an account is an events account. For more information, see Set up logging and event sharing for an application.",
      "example": true
    },
    "moved_to_organization": {
      "type": "string",
      "readOnly": true,
      "description": "If the account was moved to a different organization, provides the name of that organization.",
      "example": "example_value"
    },
    "admin_name": {
      "type": "string",
      "description": "Name of the account administrator.",
      "writeOnly": true,
      "nullable": true,
      "example": "example_value"
    },
    "admin_password": {
      "type": "string",
      "description": "Password for the account administrator.",
      "writeOnly": true,
      "format": "password",
      "example": "example_value"
    },
    "admin_rsa_public_key": {
      "type": "string",
      "description": "RSA public key for the account administrator.",
      "writeOnly": true,
      "format": "password",
      "example": "example_value"
    },
    "admin_user_type": {
      "type": "string",
      "description": "User type of the account administrator.",
      "writeOnly": true,
      "example": "example_value"
    },
    "first_name": {
      "type": "string",
      "description": "First name of the account administrator.",
      "writeOnly": true,
      "example": "example_value"
    },
    "last_name": {
      "type": "string",
      "description": "Last name of the account administrator.",
      "writeOnly": true,
      "example": "example_value"
    },
    "email": {
      "type": "string",
      "description": "Email address of the account administrator.",
      "writeOnly": true,
      "nullable": true,
      "example": "user@example.com"
    },
    "must_change_password": {
      "type": "boolean",
      "description": "Indicates whether the account administrator must change the password at the next login.",
      "default": false,
      "writeOnly": true,
      "example": true
    },
    "polaris": {
      "type": "boolean",
      "description": "Indicates whether the account is a Polaris account.",
      "default": false,
      "writeOnly": true,
      "example": true
    }
  },
  "required": [
    "name",
    "admin_name",
    "email",
    "edition"
  ]
}