Skip to main content
If your existing Snowflake account is in the wrong region or cloud provider, you’ll need to create a sub-account in AWS US-EAST-1 to access Flipside data shares.

Why create a sub-account?

Snowflake data sharing requires both accounts to be:
  • On the same cloud provider (AWS)
  • In the same region (US-EAST-1)
Creating a sub-account lets you:
  • Keep your existing Snowflake setup unchanged
  • Access Flipside data shares in the correct region
  • Manage multiple accounts under one organization

Prerequisites

Organization required: You need an existing Snowflake organization to create sub-accounts. If you’re a new customer, sign up for a free trial in AWS US-EAST-1 instead.

Step-by-step guide

1

Access your organization admin

Log in to your Snowflake account with ORGADMIN privilegesIf you don’t have ORGADMIN access, contact your Snowflake administrator
2

Navigate to account management

  1. Click Admin in the left sidebar 2. Select Accounts from the menu 3. Click + Account (top right)
3

Configure the new account

Fill in the account details:Account name:
  • Choose a descriptive name (e.g., flipside_datashares)
  • Lowercase letters, numbers, and underscores only
Cloud provider:
  • Select Amazon Web Services (AWS)
Region:
  • Select US East (N. Virginia) / us-east-1
Edition:
  • Select Enterprise (required for data sharing)
  • Or Business Critical if needed
Snowflake release:
  • Leave as default (Enterprise or higher)
4

Review and create

  1. Review your configuration 2. Click Create Account 3. Wait for provisioning (usually 1-2 minutes)
5

Access your new account

Once created: 1. You’ll see the new account in your accounts list 2. Click the account name to switch to it 3. Or use the account locator URL provided
6

Verify the setup

Log in to your new account and run:
-- Check region
SELECT CURRENT_REGION();
-- Expected: AWS_US_EAST_1

-- Check edition
SHOW PARAMETERS LIKE 'EDITION' IN ACCOUNT;
-- Expected: ENTERPRISE

-- Get your data sharing identifier
SELECT CURRENT_ORGANIZATION_NAME() || '.' || CURRENT_ACCOUNT_NAME();
-- Save this for requesting premium shares

Official Snowflake documentation

For detailed instructions and troubleshooting, see:

Snowflake: Creating Accounts

Official guide to creating and managing accounts in your organization

Next steps

Troubleshooting

Contact your Snowflake administrator or account owner to:
  • Grant you ORGADMIN privileges, or
  • Create the sub-account on your behalf
Provide them with these requirements:
  • Cloud: AWS
  • Region: US-EAST-1
  • Edition: Enterprise or higher
Ensure your organization has accounts enabled in AWS. If you only see Azure or GCP regions, you may need to: - Contact Snowflake support to enable AWS regions - Or create a new organization on AWS
Sub-accounts:
  • Share credits with your organization (no separate billing)
  • Only incur costs when actively used
  • Can be suspended when not in use to avoid idle costs
Data shares:
  • No storage costs (zero-copy sharing)
  • Only pay for compute (queries you run)