Introduction to Organizations¶
An organization is a first-class Snowflake object that links the accounts owned by your business entity. Organizations simplify account management and billing, Replication and Failover/Failback, Snowflake Secure Data Sharing, and other account administration tasks.
This feature allows organization administrators to view, create, and manage all of your accounts across different regions and cloud platforms.
Benefits¶
A central view of all accounts within your organization. For more information, see Viewing a List of Organization Accounts.
Self-service account creation. For more information, see Creating an Account.
Data availability and durability by leveraging data replication and failover. For more information, see Introduction to Replication and Failover.
Seamless data sharing with Snowflake consumers across regions. For more information, see Sharing Data Securely Across Regions and Cloud Platforms.
Ability to monitor and understand usage across all accounts in the organization. For more information, see Organization Usage views.
ORGADMIN Role¶
The organization administrator (ORGADMIN) system role is responsible for managing operations at the organization level.
A user with the ORGADMIN role can perform the following actions:
Create an account in the organization. For more information, see Creating an Account.
View/show all accounts within the organization. For more information, see Viewing a List of Organization Accounts.
View/show a list of regions enabled for the organization. For more information, see Viewing a List of Regions Available for Your Organization.
View usage information for all accounts in the organization. For more information, see Organization Usage.
Enable database replication for an account in the organization. For more information, see Prerequisite: Enable Replication for Accounts in the Organization.
Note
Once an account is created, ORGADMIN can view the account properties but does not have access to the account data.
For information about working with the ORGADMIN role, see Enabling the ORGADMIN Role for an Account.
Organization DDL¶
To help manage organizations, including creating and listing accounts in the organization, Snowflake provides the following set of special DDL commands:
Organization Functions and Views¶
Snowflake provides historical usage data for all accounts in your organization via views in the ORGANIZATION_USAGE schema in a shared database named SNOWFLAKE. For information, see Organization Usage.
To enable database replication for an account in the organization, Snowflake provides the following SQL function: