A RetroSearch Logo

Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Search Query:

Showing content from https://docs.snowflake.com/en/sql-reference/sql/show-accounts below:

Website Navigation


SHOW ACCOUNTS | Snowflake Documentation

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 account.

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.

dropped_on [1]

Date and time when the account was last dropped.

scheduled_deletion_time [1]

Date and time when the account is scheduled to be permanently deleted. Accounts are deleted within one hour after the scheduled time.

restored_on [1]

Date and time when the account was last restored.

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.

moved_to_organization [1]

If the account was moved to a different organization, provides the name of that organization.

moved_on [1]

Date and time when the account was moved to a different organization.

organization_URL_expiration_on [1]

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. Dropped URLs cannot be used to access the account.

is_events_account

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

is_organization_account

Indicates whether an account is the organization account.


RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4