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 -> Warehouse -> New Warehouse Connection
Select Snowflake
Provide all the mandatory details
Distinct Name: Name to identify this connection
Host: Provide the IP address or Host name.
Port: Provide the Port number.
Database: Provide database name if there is any, it should be an existing database.
Schema: The name of the database schema to use when a schema is not explicitly specified in a query.
Username: Snowflake account user name
Snowflake Stage: Provide name of the external stage. To create an external stage, refer to docs.
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.
Last updated