Connecting additional Snowflake accounts

Step 1: Create new Snowflake user

In order to connect additional Snowflake accounts to SELECT, a new user with metadata access must be created by following the steps here.

Step 2: Ensure the account has access to the organization usage views

SELECT relies on data in the snowflake.organization_usage views to surface relevant information about your Snowflake spend. In order to access these views, the ORGADMIN role must be enabled in the account. This can be accomplished by submitting a ticket to Snowflake support. Here's an example message you can use:

Hi there, please can you add the orgadmin role to our account <account_id>? We'd like to be able to view the organization usage views in there.

Step 3: Connect the account

Once the user has been created, you can navigate to Settings -> Snowflake -> Add New and connect the account by following the steps outlined here.