SnowflakeThe only data warehouse built for the cloud
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:
220.127.116.11 18.104.22.168 22.214.171.124
When using the Snowflake connector, the first thing you will have to do is click on 'New Authentication' in the step editor:
You will then be presented with the authentication details for Snowflake:
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
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:
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):
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:
If you do not set a default database and schema then you will need to enter them 'fully-qualified' (in the form of