Skip to content

Add new account to orginization

This tutorial will show how you can add a new Snowflake account under your organization.

Video

Requirement

  • Must be on a on-demand (Paying) or contracted account, you CAN NOT be on free trial. We also assume no complex security needs.

Walk Through

We first want to start by enabling the orgadmin role and go to the accounts page. Start by running the code below to enable orgadmin.

1
2
3
4
5
-- Assume the ACCOUNTADMIN role
use role accountadmin;

-- Grant the ORGADMIN role to a user
grant role orgadmin to user <username>;

1
2
3
4
5
-- Assume the ACCOUNTADMIN role
use role accountadmin;

-- Grant the ORGADMIN role to a user
grant role orgadmin to user danielwilczak;
status
Statement executed successfully.

Once you have orgadmin role enabled for your user, we'll switch to the role. switch role

Now that we switch to the orgadmin role we will see a new tab under the admin section called accounts. We'll click on that and then click + account in the top right hand corner. navigate to accounts

From here you can select your preferred preferences for the account and click next, followed by create. Update account name