Setup Guide - Snowflake

Follow this setup guide to connect Snowflake Data Warehouse to DataChannel.

Prerequisites

  • Have a Snowflake Data Warehouse configured and reachable from the DataChannel IPs. Contact support for the list of IP addresses to whitelist incase required.

  • Create a user for DataChannel with SELECT rights on the tables / views you want to pull data from.

  • In case of a heavily utilized production database, it is advisable to connect the read-only replica to pull data from an active Snowflake account with permissions to access data from accounts you’d like to sync. This account needs to be a admin account with delete privileges.

Setup instructions

  1. Select a data destination for your Snowflake Data. If you have not yet added a data warehouse, go to data warehouse tab and add a warehouse.

    Data Warehouse once selected cannot be changed.

  2. Authorise DataChannel to connect to your Snowflake account using the + icon with your Name, Account, Warehouse, Username, Password, DB Name and DB Schema.

    snowflake new creds

  3. Click on + Data Pipeline to start adding data pipelines to your account.

    snowflake data source detail

  4. Details of individual objects and reports are available here. .

Still have Questions?

We’ll be happy to help you with any questions you might have! Send us an email at info@datachannel.co.

Subscribe to our Newsletter for latest updates at DataChannel.