Creating a Snowflake account and workspace - Try It Yourself

Creating a Snowflake account and workspace

📖 Scenario: You are starting a new cloud data project and need to set up a Snowflake account and workspace. This workspace will allow you to store and analyze data securely in the cloud.

🎯 Goal: Create a Snowflake account and set up a workspace with a database and a warehouse to prepare for data loading and querying.

📋 What You'll Learn

Create a Snowflake account variable with the exact name account_name and value my_snowflake_account.

Create a variable user_name with the value admin_user.

Create a variable role_name with the value SYSADMIN.

Create a database named MY_DATABASE.

Create a warehouse named MY_WAREHOUSE with size SMALL and auto suspend after 300 seconds.

Use the variables to configure the session.

💡 Why This Matters

🌍 Real World

Setting up a Snowflake workspace is the first step in managing cloud data storage and analytics for businesses.

💼 Career

Cloud engineers and data engineers often need to configure Snowflake accounts and workspaces to enable data pipelines and analytics.

1

Set up Snowflake account variables

Create three variables: account_name with value my_snowflake_account, user_name with value admin_user, and role_name with value SYSADMIN.

Snowflake

# Create variables for account_name, user_name, and role_name
# Your code here

Need a hint?

Use simple assignment statements to create the variables with the exact names and values.

2

Configure Snowflake session

Create a Snowflake connection configuration dictionary named connection_config using the variables account_name, user_name, and role_name. Include warehouse and database keys with values MY_WAREHOUSE and MY_DATABASE respectively.

Snowflake

account_name = 'my_snowflake_account'
user_name = 'admin_user'
role_name = 'SYSADMIN'
# Create connection_config dictionary using the variables
# Your code here

Need a hint?

Use a dictionary to hold the connection settings, referencing the variables you created.

3

Create database and warehouse SQL commands

Create two string variables: create_database_sql with the SQL command to create a database named MY_DATABASE, and create_warehouse_sql with the SQL command to create a warehouse named MY_WAREHOUSE of size SMALL that auto suspends after 300 seconds.

Snowflake

account_name = 'my_snowflake_account'
user_name = 'admin_user'
role_name = 'SYSADMIN'
connection_config = {
    'account': account_name,
    'user': user_name,
    'role': role_name,
    'warehouse': 'MY_WAREHOUSE',
    'database': 'MY_DATABASE'
}
# Create SQL commands to create database and warehouse
# Your code here

Need a hint?

Write the exact SQL commands as strings to create the database and warehouse.

4

Finalize workspace setup commands

Add a variable use_database_sql with the SQL command to use the database MY_DATABASE. Then add a variable use_warehouse_sql with the SQL command to use the warehouse MY_WAREHOUSE.

Snowflake

account_name = 'my_snowflake_account'
user_name = 'admin_user'
role_name = 'SYSADMIN'
connection_config = {
    'account': account_name,
    'user': user_name,
    'role': role_name,
    'warehouse': 'MY_WAREHOUSE',
    'database': 'MY_DATABASE'
}
create_database_sql = 'CREATE DATABASE MY_DATABASE'
create_warehouse_sql = 'CREATE WAREHOUSE MY_WAREHOUSE WITH WAREHOUSE_SIZE = SMALL AUTO_SUSPEND = 300'
# Add SQL commands to use the database and warehouse
# Your code here

Need a hint?

Write the exact SQL commands as strings to switch to the database and warehouse.