Snowflake
Last updated
Last updated
Snowflake is a fully managed SaaS that provides a single platform for data warehousing, data lakes, data engineering, data science, data application development, and secure sharing and consumption of real-time/shared data.
Snowflake enables data storage, processing, and analytic solutions.
The Snowflake source supports batch syncs.
You can review the parameters that can be found in the info tab below (Image 1).
Title
Mandatory. Input a name for your data sync
Snowflake Sync
Version
Mandatory. This is a pre-populated field containing a version number for your data sync. You can override it if you wish.
1.0.0
Parameters
The following table outlines the mandatory and optional parameters you will find on the Source tab (Image 2).
The following parameters will help to define your data sync source and how it functions.
Source
Mandatory. Select your source from the drop down menu.
Snowflake
Connection String
Unencrypted example: account=wr38353.ca-central-1.aws;user=myuser;password=mypassword;db=CINCHY;schema=PUBLIC
Object
Mandatory. Select either Table or Query.
Table or Query.
Table
Appears if Object = Table. The name of the Table in Snowflake that you wish to sync.
Query
Appears if Object = Query. A SELECT statement query that will be used to fetch your data.
Configure your Destination
Define your Sync Behaviour.
Add in your Post Sync Scripts, if required.
Define your Permissions.
Click Jobs > Start a Job to begin your sync.
Optional. Review our for more information about this field.
Mandatory. The encrypted connection string used to connect to your Snowflake instance. You can review Snowflake's Connection String guide and parameter descriptions