Our Premium connector for direct connection to a Snowflake database.
Our platform enables you to quickly and easily connect your Form Entries to a Snowflake database.
This enables one-way synchronization, where any Forms Entries are pushed to tables in a Snowflake database.
Adding the Connector
Follow these steps to add the connector to your specific form:
- Navigate to App Workshop > Forms.
- Hover over your desired form and click the Connect icon.
- Click the Add Connector button (top-right).
- Select Snowflake from the options.
Note: The page will refresh with the connector added. Changes are not live until you click Save.
Quick Access Tip
If you are already inside the Form Builder or Settings view, you don’t need to go back to the main menu. Simply click the Connectors tab located directly under the form title at the top of the screen.
Configuring the Connector
After adding the form connector, the following configuration options are available.
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
The name of the Snowflake platform schema where the data table is stored.
Data Columns
Specify which Form fields to populate as row values in your target dataset.
Upon your first Form entry, each selected Form field will auto-create a column of the same name if it does not already exist.
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.
Auto Maintain Table
When enabled, our platform will create and maintain the target database table.
This is a recommended setting, as columns will be automatically added/altered as the Form design changes between versions.
User URL Media Fields
If enabled, media filenames will be converted to their full URLs.
Replace Placeholders with Display Text
By default, placeholders will be replaced with the raw answer value from the form entry.
For example, date values are stored as UTC time in ISO 8601 raw format, e.g., 2015-10-23T15:05:07Z.
Select this option if you wish to replace it with user-visible text, e.g., 23-Oct-2015 05:05:07, assuming your time zone is UTC-10.
Fill Repeat Rows
Repeated data (e.g., repeatable pages and table rows) will be exported as separate rows.
When this option is selected, all non-repeat answer values are copied down into each repeat row.
This can be useful in cases where other systems are importing these rows and need to process all answer values for each repeated row.
If you wish to have NULL values for non-repeat answers in repeat rows instead, deselect this option.
The following are NOT affected by this option:
- ENTRYGUID, ENTRYGUIDFULL, ITEMNO, and UTCNOW
- Fields that appear within a table or repeating page
- Formulae that reference a repeating field
Anonymize Personal Data
If enabled, data from fields marked as Personal Data will be converted to a non-human-readable format to aid privacy.