Multi-account and organization management in Snowflake - Step-by-Step Execution

Process Flow - Multi-account and organization management

Create Organization

↓

Add Accounts to Organization

↓

Define Roles and Permissions

↓

Manage Resource Access Across Accounts

↓

Monitor and Audit Activity

↓

End

This flow shows how an organization is created, accounts are added, roles set, resources managed, and activities monitored.

Execution Sample

Snowflake

CREATE ORGANIZATION my_org;
CREATE ACCOUNT my_account1;
ADD ACCOUNT my_account1 TO ORGANIZATION my_org;
GRANT ROLE ORGADMIN TO USER admin_user;
SHOW ORGANIZATION ACCOUNTS;

This code creates an organization, adds an account, assigns an admin role, and lists accounts in the organization.

Process Table

Step	Action	Command Result	State Change
1	Create organization 'my_org'	Organization 'my_org' created	Organization 'my_org' exists with no accounts
2	Create account 'my_account1'	Account 'my_account1' created	Account 'my_account1' exists, not linked
3	Add 'my_account1' to 'my_org'	Account 'my_account1' added to organization 'my_org'	'my_account1' linked to 'my_org'
4	Grant ORGADMIN role to 'admin_user'	Role ORGADMIN granted to user 'admin_user'	'admin_user' can manage organization
5	Show organization accounts	Lists: 'my_account1'	Confirms 'my_account1' is in 'my_org'
6	End	No further actions	Setup complete

💡 All steps executed; organization with one account and admin role configured

Status Tracker

Variable	Start	After Step 1	After Step 2	After Step 3	After Step 4	After Step 5	Final
Organization 'my_org'	None	Exists	Exists	Exists with 'my_account1'	Exists with 'my_account1'	Exists with 'my_account1'	Exists with 'my_account1'
Account 'my_account1'	None	None	Exists	Linked to 'my_org'	Linked to 'my_org'	Linked to 'my_org'	Linked to 'my_org'
User 'admin_user' roles	None	None	None	None	Has ORGADMIN role	Has ORGADMIN role	Has ORGADMIN role

Key Moments - 3 Insights

Why do we need to add accounts to the organization after creating them?

Creating an account alone does not link it to the organization. Step 3 shows adding the account to the organization to manage it centrally.

What does granting the ORGADMIN role to a user do?

Step 4 grants the ORGADMIN role, which allows the user to manage organization-wide settings and accounts, as shown in the variable tracker.

How can we confirm the account is part of the organization?

Step 5 runs 'SHOW ORGANIZATION ACCOUNTS' which lists accounts linked to the organization, confirming the state change.

Visual Quiz - 3 Questions

Look at the execution table, after which step is the account 'my_account1' linked to the organization?

A After Step 2

B After Step 4

C After Step 3

D After Step 5

💡 Hint

Check the 'State Change' column for Step 3 in the execution table.

According to the variable tracker, what roles does 'admin_user' have after Step 4?

A ORGADMIN role

B No roles assigned

C AccountAdmin role

D SYSADMIN role

💡 Hint

Look at the 'User admin_user roles' row after Step 4 in the variable tracker.

If we skipped Step 3, what would the 'SHOW ORGANIZATION ACCOUNTS' command display at Step 5?

A It would list 'my_account1'

B It would list no accounts

C It would show an error

D It would list all accounts in Snowflake

💡 Hint

Refer to the execution table Step 3 and Step 5 state changes.

Concept Snapshot

CREATE ORGANIZATION org_name;  -- creates an organization
CREATE ACCOUNT account_name;  -- creates an account
ADD ACCOUNT account_name TO ORGANIZATION org_name;  -- links account
GRANT ROLE ORGADMIN TO USER user_name;  -- assigns admin role
SHOW ORGANIZATION ACCOUNTS;  -- lists accounts in org
Use these commands to manage multiple accounts centrally.

Full Transcript

This visual execution traces how to manage multiple Snowflake accounts within an organization. First, an organization is created. Then, accounts are created separately and added to the organization to link them. Roles like ORGADMIN are granted to users to allow management of the organization. Finally, commands like SHOW ORGANIZATION ACCOUNTS confirm the setup. Variables track the existence and linkage of organizations, accounts, and user roles step-by-step.