Open Navigation

Snowflake

The only data warehouse built for the cloud

Overview

Snowflake makes it easy to amass all your data, enable rapid analytics, and derive data-driven insights for all your business users.

To allow tray.io to connect to your Snowflake database, you'll need to either make your database publicly accessible or you can white list ALL of the following static IP addresses for access:

52.38.123.148 52.37.22.152 18.236.15.101

Authentication

When using the Snowflake connector, the first thing you will have to do is click on 'New Authentication' in the step editor:

add-auth

You will then be presented with the authentication details for Snowflake:

snowflake-auth-1

Note that the Account should be entered as above, e.g. if the url for your Snowflake instance is https://ls28623.us-east-1.snowflakecomputing.com the Account should be ls28623

Also note that you will need to authenticate with a user assigned to a role which has been granted the appropriate privileges for warehouses, databases, schemas and tables.

So when operating in the Snowflake context of ACCOUNTADMIN, you will need to have run a sequence of commands such as:

snowflake-commands

In Step 4 above note that the privileges are granted to a warehouse, then to databases, their schemas and then individual tables. This must be done to allow access to tables - the exact table permissions (select, insert etc.) can be set according to what tasks you wish to carry out with the Tray.io connector.

When completing your authentication you can optionally include default options for Region, Database, Schema and Warehouse (a Warehouse in Snowflake is a set of computing resources you have assigned to manage your databases and tables, which can be adjusted depending on the power and capacity that is required):

snowflake-auth-2

Be sure to set a default Warehouse for your authentication as this needs to be picked up automatically when you are running Snowflake operations.

If you set a default database and schema then you can run queries and statements by directly referencing the table:

basic-db-query

If you do not set a default database and schema then you will need to enter them 'fully-qualified' (in the form of <db_id>.<schema_id>.<object_id>:

fq-db-query

Example workflow

Coming soon!

Available operations

Was this article helpful?
Yes
No