Snowflake

Getting Started with Snowflake Destination Configuration

Requirements:

• Active Snowflake account.

• Allow connections from DataBrain to your Snowflake account.

  • For details on setting up IP whitelisting and ensuring secure connectivity, refer to our guide on

Allow Access to our IP

• Choose the DataBrain Workspace to which you wish to connect the data.

Setup Guide:

1. Ensure Account Accessibility:

   • Make sure your Snowflake account is active and accessible from the machine running DataBrain .

   • This is dependent on your networking setup. The easiest way to verify if DataBrain can connect to your Snowflake account is via the Add a Data Source UI.

2. Grant Necessary Permissions:

   • Read Access on Tables and information_schema: Grant read access permissions to the tables within Snowflake as well as the information_schema schema. This allows DataBrain to retrieve necessary information and replicate data accurately. You can assign appropriate permissions to the user or role accessing Snowflake to enable reading from tables and accessing metadata stored in the information_schema. -- Grant SELECT permission on all tables in the specified schema GRANT SELECT ON ALL TABLES IN SCHEMA <schema_name> TO <username>

3. Fill Up Connection Info:

   • Provide the necessary information to connect to your Snowflake account:

     • Destination Name: [Pick a name to help you identify this destination in DataBrain]

     • Host: [Enter your Snowflake account's locator, typically in the format <account_locator>.<region>.<cloud>

     • Role: [The Snowflake user’s role is what allows that user to access tables. In order to query your data, ensure your user has the appropriate roles.]

     • Warehouse: [Enter the name of the warehouse you want to sync data into]

     • Database: [Enter the name of the database you want to sync data into]

     • Default Schema: [Enter the name of the default schema you want to use]

     • Username: [Enter the username you want to use to access the database]

     • Password: [Enter the associated password]

   • Note on Schema Configuration:

     • If no schema is specified, all tables with permission will be presented regardless of their schema.

Encryption:

• All Snowflake connections via DataBrain are encrypted to ensure security.

Permissions:

• Permission to read information_schema.

• Whitelist the IP address.

• Grant read access to the schema (usage) and tables, noting that access to only tables may not suffice in certain databases.

Replace the placeholders inside the square brackets with actual values when filling in the details.

Locating the Configuration Details in Snowflake

1. Host (Account Locator):

   • When you log in to the Snowflake web interface, the URL in your browser's address bar is your account locator. It's typically in the format <account_locator>.<region>.<cloud>. e.g. vj12833.ap-south-1.aws

2. Role:

   • In the Snowflake web UI, on the top right, there's a dropdown that shows the current role. Clicking on it will show you all the roles assigned to you.

3. Warehouse:

   • Navigate to the 'Warehouses' tab in the Snowflake web UI. This section lists all the warehouses you have access to.

4. Database:

   • Navigate to the 'Databases' tab in the Snowflake web UI. This section lists all the databases you can access.

5. Default Schema:

   • Once you're inside a specific database in the Snowflake web UI, you can see the list of schemas. The one you typically use or want to set as default for DataBrain should be chosen.

6. Username:

   • The username is the one you use to log in to the Snowflake web UI. If you're an admin, you can also find usernames of other users by navigating to the 'Users' tab.

7. Password:

   • This is the password associated with your Snowflake username. For security reasons, Snowflake doesn't display passwords, so you should know this or have it stored securely.