Snowflake connections

Documentation

To connect your Snowflake accounts to Slingshot, refer to the connection method relevant to you:

Script based connection if your Slingshot tenant is created with our support team
Native app connection if your Slingshot tenant is created via Slingshot native app

In general, connecting a regional primary account, which is the first account of a cloud region connecting to Slingshot, provides Slingshot with the access to selected views in ORGANIZATION_USAGE schema and ACCOUNT_USAGE schema.

Requirements

A regional primary account, which is the first account of a cloud region connecting to Slingshot, must be ORGADMIN enabled in Snowflake. Once enabled, Snowflake has up to 24 hour latency to populate data in ORGANIZATION_USAGE schema.
- Execute this command in Snowflake to check is_org_admin: SHOW ACCOUNTS
On any account, when executing scripts provided by Slingshot, you must use the ACCOUNTADMIN role.

Supported account types

Account edition must be Business Critical or Enterprise.
- Execute this command in Snowflake to check edition: SHOW ACCOUNTS
Account must not be a reader account.
- Execute this command in Snowflake to check: SHOW MANAGED ACCOUNTS
Account must not be a replication account.
- Execute this command in Snowflake to check: SHOW REPLICATION ACCOUNTS

Supported cloud regions

Slingshot for Snowflake supports the following cloud providers and regions.

Cloud Platform	Cloud Region	Cloud Region ID
Amazon Web Services (AWS)	US West (Oregon)	AWS_US_WEST_2
	US East (Ohio)	AWS_US_EAST_2
	US East (N. Virginia)	AWS_US_EAST_1
	Canada (Central)	AWS_CA_CENTRAL_1
	EU (Ireland)	EU-WEST-1
	Europe (London)	EU-WEST-2
	EU (Paris)	EU-WEST-3
	EU (Frankfurt)	EU-CENTRAL-1
	EU North 1 (Stockholm)	EU-NORTH-1
Microsoft Azure (Azure)	US Central (Iowa)	AZURE_CENTRALUS
	US South Central (Texas)	AZURE_SOUTHCENTRALUS
	West US 2 (Washington)	AZURE_WESTUS2
	East US 2 (Virginia)	AZURE_EASTUS2
	Canada Central (Toronto)	AZURE_CANADACENTRAL
	West Europe (Netherlands)	AZURE_WESTEUROPE
	North Europe (Ireland)	AZURE_NORTHEUROPE
	Switzerland North (Zurich)	AZURE_SWITZERLANDN
	UK South (London)	AZURE_UKSOUTH
Google Cloud Platform (GCP)	US Central 1 (Iowa)	GCP_US_CENTRAL1
	US East 4 (Virginia)	GCP_US_EAST4
	Europe West 2 (London)	EUROPE-WEST2
	Europe West 4 (Netherlands)	EUROPE-WEST4

Usage notes

⚠️

Important: By granting account level privileges to Slingshot, the customer acknowledges that Capital One Software may take certain actions, including bypassing HIPAA restrictions, on the customer’s account. In addition, the customer acknowledges that Capital One Software support representatives may sign into the customer’s account with view-only access to provide technical assistance.

Roles for connecting Snowflake accounts

The following roles can access Snowflake accounts page in Slingshot:
- Tenant admin
- Snowflake admin
The following role can run scripts in Snowflake:
- ACCOUNTADMIN