Integrating with Snowflake

Prerequisites

Snowflake Setup

Prerequisites

To connect Snowflake to Drivetrain, you will need:

• Admin privileges in Snowflake

Snowflake Setup

Drivetrain has a Snowflake account hosted in AWS US regions, you can share Read access to your database with this below mentioned accounts.

AWS Snowflake Accounts

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 ID: QX73326

Cloud Provider: AWS

Region: US EAST (Ohio)

AWS CA CENTRAL (Canada)

Organization ID: ICKQIFB

Account ID: DRIVETRAIN_AWS_CACENTRAL

Locator ID: RN48023

Cloud Provider: AWS

Region: CA CENTRAL (Canada)

GCP Snowflake Accounts

GCP US Central (Iowa)

Organization ID: ICKQIFB

Account ID: DRIVETRAIN_USCENTRAL

Locator ID: AB40701

Cloud Provider: GCP

Region: US Central (Iowa)

AZURE Snowflake Accounts

AZURE US West (Washington)

Organization ID: ICKQIFB

Account ID: DRIVETRAIN_AZ_USWEST

Locator ID: RA27187

Cloud Provider: AZURE

Region: US West (Washington)

Important:

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.

That's it share the Databases Name with your Customer Success Manager or Data Integration Manager to get started