# Integrating with Snowflake

[Prerequisites](#prerequisites)

[Snowflake Setup](#snowflake-setup)\
[How to create a Share with Drivetrain's Account](#how-to-create-a-share-with-drivetrains-account)\
[List of Supported Snowflake Accounts for Direct Sharing](#list-of-supported-snowflake-accounts-for-direct-sharing)

## Prerequisites

To connect Snowflake to Drivetrain, you will need:

* Admin privileges in Snowflake

## Snowflake Setup <a href="#snowflake-setup" id="snowflake-setup"></a>

**Drivetrain uses Snowflake's Direct Share approach to connect with customer accounts.**\
Direct Shares only work when both accounts are on the **same cloud provider and region**. To support this, we maintain Snowflake accounts across multiple regions and cloud platforms (see list below).

If your account’s provider or region isn’t listed, please reach out—we’ll be happy to set it up for you.

You can read more about Data Sharing via Direct Shares [here](https://docs.snowflake.com/en/user-guide/data-sharing-intro)

### How to create a Share with Drivetrain's Account

1. Login to your [Snowflake](https://app.snowflake.com/) account
2. In the left navigation menu, under "**Data Products**" option, select "**Private Sharing**"
3. Click on "**Share**" on top right corner and select **Create a Direct Share**
4. In the Share Data dialog, select + Select Data and then:
   1. Select the source database which you want to integrate.&#x20;
   2. Select the target object or objects from the source database.
   3. Optionally, update the Secure Share Identifier created for your share.
   4. Optionally, enter a Description.
   5. In the remaining text box, enter an account locator. You can find the respective account for your cloud provider and region below. You can only add accounts within the same region to the share. If you don't find any account for your region, please reach out to us.
   6. Select Create Share.
5. Share the name of the Shares you created and Organization Details containing Organization Name, Account Name and Locator with your Customer Success Manager.&#x20;

### List of Supported Snowflake Accounts for Direct Sharing

{% hint style="info" %}
***AWS Snowflake Accounts***<br>

#### **AWS US WEST**

Organization ID: **ICKQIFB**

Account ID: **DRIVETRAIN\_USWEST**

Locator ID: **VJB64118**

Cloud Provider: **AWS**

Region: **US West (Oregon)**

#### **AWS US EAST  (Virginia)**

Organization ID: **ICKQIFB**

Account ID: **DRIVETRAIN\_USEAST**

Locator ID: **YIB12816**

Cloud Provider: **AWS**

Region: **US EAST (Virginia)**

#### **AWS US EAST  (Ohio)**

Organization ID: **ICKQIFB**

Account ID: **DRIVETRAIN\_USEAST\_OHIO**

Locator I&#x44;**: QX73326**

Cloud Provider: **AWS**

Regio&#x6E;**: US EAST (Ohio)**

#### AWS CA CENTRAL  (Canada)

Organization ID: **ICKQIFB**

Account ID: **DRIVETRAIN\_AWS\_CACENTRAL**

Locator I&#x44;**: RN48023**

Cloud Provider: **AWS**

Regio&#x6E;**: CA CENTRAL (Canada)**

#### WS EU CENTRAL (Frankfurt) <a href="#id-5ad4b615-1ff9-4f25-9d79-b5c91f0bd552" id="id-5ad4b615-1ff9-4f25-9d79-b5c91f0bd552"></a>

Organization ID: **ICKQIFB**\
Account ID: **DRIVETRAIN\_AWS\_EU\_CENTRAL\_1**\
Locator ID: **FM31440**\
Cloud Provider: **AWS**\
Region: **EU** **CENTRAL 1 (Frankfurt)**
{% endhint %}

{% hint style="info" %}
***GCP Snowflake Accounts***<br>

#### **GCP US CENTRAL  (Iowa**)

Organization ID: **ICKQIFB**

Account ID: **DRIVETRAIN\_USCENTRAL**

Locator ID: **AB40701**

Cloud Provider: **GCP**

Region: **US Central (Iowa)**
{% endhint %}

{% hint style="info" %}
**AZURE&#x20;*****Snowflake Accounts***<br>

#### **AZURE US WEST  (**&#x57;ashington)

Organization ID: **ICKQIFB**

Account ID: **DRIVETRAIN\_AZ\_USWEST**

Locator ID: **RA27187**

Cloud Provider: **AZURE**

Region: **US West (Washington)**

#### &#x20;**AZURE CA CENTRAL  (Toronto)**

Organization id: **ICKQIFB**

Account id: **DRIVETRAIN\_AZURE\_CACENTRAL**

Locator id: **QN47444**

Cloud provider: **AZURE**

Region: **Canada Central (Toronto)**

#### AZURE NORTH EUROPE

Organization id: **ICKQIFB**

Account id: **DRIVETRAIN\_AZURE\_NORTH\_EUROPE**

Locator id: **LM67628**

Cloud provider: **AZURE**

Region: **North Europe (Ireland)**
{% endhint %}

### Important Notes

{% hint style="info" %}
**Important:**&#x20;

1. Please configure Row Level Security to provide access to relevant tables for Drivetrain. If you’re using a different region on AWS or are on other cloud platform, please share the details with the Drivetrain team.
2. If you encounter any issues while creating a share in Snowflake using the Account ID, please try using the Locator ID instead. If the issue persists, contact your Customer Success Manager or Data Integration Manager for assistance.
   {% endhint %}