Snowflake is a cloud-based data warehouse and platform that offers a variety of data services, including data storage, processing, and analytics.

Scoop can load data from Snowflake and combine it with other data sources. Scoop can also do snapshot reporting on data that is stored in Snowflake.

Connecting to Snowflake

To connect to Snowflake as a datasource, create a new dataset linked to Snowflake. First, on the datasets page, select applications as a source:

Next, select Database:

Select whether you are selecting an object that you want to snapshot daily, or an object which is transactional (e.g. an activities object).

Click URL connection string and fill out the requested information

Then name the connector

After you save this dialog, you can elect to have Scoop run an immediate extract (by checking the extract data now button). Scoop will automatically run this extract overnight each day after you set this up.