Sprinkle Docs
Search…
Snowflake
Guide to integrate your Snowflake with Sprinkle
This page covers the details about integrating Snowflake with Sprinkle.
When setting up Snowflake connection, Sprinkle additionally requires a Cloud bucket. This guide covers the role of all the components and steps to setup.
  • ​Integrating Snowflake: All analytical data is stored and queried from Snowflake warehouse
  • ​Cloud Bucket: Sprinkle stores all intermediate data and report caches in this bucket

Step by Step Guide

Integrating Snowflake

STEP-1: Allow Snowflake to accept connection from Sprinkle

Allow inbound connection on snowflake jdbc port (default is 443) from Sprinkle IPs (34.93.254.126, 34.93.106.136).

STEP-2: Configure Snowflake Connection

  • Log into Sprinkle application
  • Navigate to Admin -> Drivers -> Create Warehouse
  • Select Snowflake
  • Provide all the mandatory details
    • Distinct Name: Name to identify this connection
    • JDBC URL : For Example, The connection URL for the database in azure is jdbc:snowflake//https://xxxx.azure.snowflakecomputing.com/?db=DEMO_DB
    • Username: Snowflake account user name
    • Password: Snowflake account password
    • Private Key:
    • Passphrase: Passphrase of private key
  • Test Connection
  • Create

Create a Cloud Bucket

Cloud bucket can be created depending on your Snowflake Cloud. Sprinkle supports creating a bucket in AWS, GCP or Azure. Refer respective documents for creating a configuring the Cloud Bucket.
​