Multi-account and organization management in Snowflake - Mini Project: Build & Apply

Multi-account and Organization Management in Snowflake

📖 Scenario: You are working as a cloud administrator for a company that uses Snowflake for data warehousing. The company wants to organize its Snowflake accounts into an organization to manage billing and access centrally. You will create a structure to represent multiple Snowflake accounts and configure organization-level settings.

🎯 Goal: Build a Snowflake organization structure with multiple accounts and configure a shared resource monitor for the organization.

📋 What You'll Learn

Create a dictionary called accounts with three Snowflake accounts and their regions

Create a variable called default_region set to 'US_WEST_2'

Create a list called active_accounts containing accounts in the default region

Create a configuration dictionary called org_config with a shared resource monitor named 'ORG_MONITOR'

💡 Why This Matters

🌍 Real World

Companies using Snowflake often manage multiple accounts across regions. Organizing these accounts helps centralize billing and resource management.

💼 Career

Cloud administrators and data engineers need to manage multi-account setups and configure organization-wide settings in Snowflake.

1

Create the Snowflake accounts dictionary

Create a dictionary called accounts with these exact entries: 'account1': 'US_WEST_2', 'account2': 'EU_CENTRAL_1', 'account3': 'US_WEST_2'.

Snowflake

# Create the accounts dictionary with exact entries
# Your code here

Need a hint?

Use curly braces to create a dictionary with keys as account names and values as regions.

2

Set the default region variable

Create a variable called default_region and set it to the string 'US_WEST_2'.

Snowflake

accounts = {'account1': 'US_WEST_2', 'account2': 'EU_CENTRAL_1', 'account3': 'US_WEST_2'}
# Create the default_region variable
# Your code here

Need a hint?

Assign the string 'US_WEST_2' to the variable named default_region.

3

Filter accounts by default region

Create a list called active_accounts that contains the keys from accounts where the value equals default_region. Use a list comprehension with account as the iterator variable.

Snowflake

accounts = {'account1': 'US_WEST_2', 'account2': 'EU_CENTRAL_1', 'account3': 'US_WEST_2'}
default_region = 'US_WEST_2'
# Create active_accounts list with accounts in default_region
# Your code here

Need a hint?

Use a list comprehension to select account names where their region matches default_region.

4

Create organization configuration with shared resource monitor

Create a dictionary called org_config with a key 'shared_resource_monitor' set to the string 'ORG_MONITOR'.

Snowflake

accounts = {'account1': 'US_WEST_2', 'account2': 'EU_CENTRAL_1', 'account3': 'US_WEST_2'}
default_region = 'US_WEST_2'
active_accounts = [account for account, region in accounts.items() if region == default_region]
# Create org_config dictionary with shared_resource_monitor
# Your code here

Need a hint?

Create a dictionary with the key 'shared_resource_monitor' and value 'ORG_MONITOR'.