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.