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.

Note: Snowflake has the option of implementing a network policy to restrict access based on IP addresses.

If you are not using a network policy, then your database is publicly accessible.

If you have enabled a network policy then you will need to enable tray.io to connect to your database by white listing ALL the static IP addresses listed below.

  • 52.40.200.248

  • 52.39.10.61

  • 52.26.59.155

We also support hosting your Snowflake connector on a private cluster. Please contact us is if you wish to arrange this. In these circumstances, to allow tray.io to connect to your Snowflake database, you'll need to 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