The Snowflake - Snowflake quickstart integration template (NA | EU) lets you sync your Snowflake staging table data with your main table for integrated data. The integration template comprises a set of pre-built integration flows. These flows help you sync staging and main tables in Snowflake.
Supported integration flows
The Celigo quickstart bundle contains workflows you can easily configure and deploy without coding or IT support. The following built-in flows sync from the specified source data to the corresponding destination.
Snowflake to Snowflake
Flow: Snowflake staging-table to Snowflake main-table.
Gather your credentials
Keep your Snowflake account credentials ready:
-
Snowflake – verify APIs and Authorization
- Before you set up a Snowflake connection below, ensure that you have the API and authentication details for your Snowflake app.
Install the Snowflake – Snowflake template
- From the Snowflake Marketplace options, select the Snowflake – Snowflake template and click Install.
- Review the template’s contents and ReadMe and click Install now to begin.
- Install the template.
Configure the Snowflake – Snowflake flows
Additional record mapping is required to integrate the template’s exports and imports with your Google Ads and Snowflake apps.
Note that all of your flows are disabled when first installed. After configuring the flows, you may enable them in your Flows dashboard or in Flow Builder with the Off/On toggle button. Then, run or schedule each flow.
Snowflake staging-table to Snowflake main-table
This integration flow syncs data between Snowflake staging tables and main tables
Before you begin
A table with the required columns should exist in Snowflake prior to the flow run.
Setup instructions
- Replace StagingTable with your staging table name in the Get Snowflake table (staging) step.
- Replace MainTable and StagingTable with your respective table names in the Import a Snowflake table (main) step.
- Replace StagingTable with your staging table name in the Delete Snowflake table (staging) step.
Comments
Please sign in to leave a comment.