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 (,

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