Multi-account and organization management in Snowflake - Commands & Configuration

Introduction

Managing multiple Snowflake accounts and organizing them helps companies control access, billing, and resources efficiently across teams and projects.

When your company has different departments needing separate Snowflake accounts for data isolation.

When you want to centralize billing and user management across multiple Snowflake accounts.

When you need to apply consistent security policies across several Snowflake accounts.

When you want to monitor usage and costs for multiple accounts from one place.

When you want to simplify user access by managing roles and permissions across accounts.

Commands

This command creates a new organization named 'my_org' to group multiple Snowflake accounts under one management umbrella.

Terminal

CREATE ORGANIZATION my_org;

Expected Output

Organization 'my_org' created successfully.

This command creates a new Snowflake account named 'my_account1' inside the 'my_org' organization in the US East region.

Terminal

CREATE ACCOUNT my_account1 WITH ORGANIZATION = 'my_org' REGION = 'us-east-1';

Expected Output

Account 'my_account1' created successfully in organization 'my_org'.

This command lists all Snowflake accounts that belong to the 'my_org' organization to verify account creation.

Terminal

SHOW ACCOUNTS IN ORGANIZATION my_org;

Expected Output

name         region     status

my_account1  us-east-1  ACTIVE

This command grants the 'org_admin' role permission to manage accounts within the 'my_org' organization.

Terminal

GRANT MANAGE ACCOUNTS ON ORGANIZATION my_org TO ROLE org_admin;

Expected Output

Grant succeeded.

Switches to the 'org_admin' role to perform organization-level management tasks.

Terminal

USE ROLE org_admin;

Expected Output

No output (command runs silently)

Key Concept

If you remember nothing else from this pattern, remember: grouping accounts into an organization lets you manage users, billing, and policies centrally.

Common Mistakes

Trying to create accounts without first creating an organization.

Accounts must belong to an organization for multi-account management features to work.

Always create an organization first using CREATE ORGANIZATION before adding accounts.

Not assigning proper roles to manage the organization and accounts.

Without the right roles, users cannot perform management tasks on accounts or the organization.

Grant the MANAGE ACCOUNTS privilege on the organization to appropriate roles.

Using inconsistent regions for accounts without planning.

Accounts in different regions may have latency or compliance implications.

Choose regions carefully when creating accounts to match your data residency and performance needs.

Summary

Create an organization to group multiple Snowflake accounts.

Add accounts to the organization specifying region and settings.

Grant roles permissions to manage accounts within the organization.

Use SHOW ACCOUNTS to verify accounts in the organization.

Switch roles to perform organization-level management tasks.