The GoFormz-Snowflake Integration allows clients to use Snowflake as their "source of truth" for data management by automating the movement of data between GoFormz and Snowflake.
Note: Before getting started, you must first reach out to your GoFormz Account Manager to enable access to the Snowflake application on your account.
There are two steps to configuring a Snowflake integration:
Creating a Snowflake Connection: First, set up a connection to the Snowflake application, giving GoFormz access to your Snowflake account.
Creating a Snowflake workflow: Contact your Account Manager or email@example.com to set up a Snowflake workflow
CREATING A NEW SNOWFLAKE CONNECTION
Before you begin, make sure that you have an existing Snowflake account and you know the credentials for the account. To create a Snowflake app connection, do the following:
Select Connected Apps from the More dropdown at the top of the GoFormz web app to navigate to the App Connections screen.
Click Add Connection next to the Snowflake application block to bring up the Snowflake login window.
Enter your Snowflake credentials (Account Name, Host Name, Username, Password, DB, Schema, Warehouse, Role) and click add.
The new connection will appear on your Snowflake Connections list with a generic name like “Snowflake Connections - 1”. We recommend renaming your connection with a more descriptive name (e.g. including your Snowflake username in the connection name), especially if you plan to use multiple Snowflake connections. This will make it much easier to tell your connections apart from each other.