Our platform enables you to quickly and easily connect your data sources to a Snowflake table.

This enables a one-way synchronization to occur – where any changes in the Snowflake table are downloaded into your data source on a regular basis.

Your data source will be automatically updated in this way until you remove the connector or an error occurs (such as losing authorization to access the database).

Adding a Snowflake Data Source Connector

Data Source Settings

• Navigate the side menu to Data Hub > Data Sources
• Hover over a data source and click the “Settings” icon link ()
• In Settings, hit the “Add Connector” button
• Select the relevant option to add the connector

This will refresh the page with the newly added connector ready for configuration.

Nothing has been saved at this stage, so save your connector after making any changes to enable or update it.

Alternatively, if you’re viewing the rows of a data source, you can navigate to the Settings page using the option under the page’s title.

Configuring a Snowflake Data Source Connector

Next, configure the following:

Refresh Frequency

The time interval of which data is pulled and refreshed by this connector.

Warehouse

Specify the name of your Snowflake Warehouse that will be used when creating a connection to your Snowflake database.

Snowflake Database

The name of the database on your Snowflake platform where the schema and table are stored.

Schema

Add an optional SQL Server database schema where the table is stored. If kept empty, the default schema will be used.

Table Name

Specify the database table that will receive entry data for this Form.
If left blank, a default table name will be generated using the Form External ID.
Only alphanumeric characters, spaces, and underscores are supported in the table name.

Where Clause

Add an optional where clause to the query that will only return the desired records. e.g.
WHERE LastName = ‘Good’

Ignore Internal Columns

If enabled, this connector will ignore all columns where the column name starts with an underscore e.g. _lastupdated.

If your table has a column named _identity and internal columns are not ignored, this column will always be the first column of the data source. Other internal columns are added to the end.

View Logs

When you save your changes, the connector will be fired for the first time, and after that, it will run at the refresh frequency you specified in the connector settings.

Wait a minute or so, or click the three-dot menu (  ) and access the RUN NOW to manually trigger the connector and check the Rows in your data source.

If rows are not downloaded, then there may be an error with the connection to the Snowflake database. To identify and resolve the issue, you can review the logs by clicking the three-dot menu (  ) and selecting VIEW LOGS.

Once resolved, you can run the connector again and confirm that the rows have been successfully downloaded.