The GoFormz-Google BigQuery Integration allows clients to use Google BigQuery as their "source of truth" for data management by automating the movement of data between GoFormz and Google BigQuery.
Before getting started, you'll need to contact your GoFormz Account Manager to establish access to the Google BigQuery application on your account.
There are two steps to configuring a Google BigQuery integration:
Add a Google BigQuery Connection: First, set up a connection to the Google BigQuery application, giving GoFormz access to your Google BigQuery account.
Set up a Google BigQuery Workflow: Contact your Account Manager or proservices@goformz.com to set up a Google BigQuery Workflow.
Add a new Google BigQuery connection
Before you begin, make sure that you have an existing Google BigQuery account and you know the credentials for the account. To create a Google BigQuery app connection, do the following:
🗒️ Note: If you add your connection using Safari, you may need to allow pop-ups from GoFormz to successfully add your connection.
Select Connected Apps from the More dropdown at the top of the GoFormz web app to navigate to the App Connections screen.
2. Click Google Big Query & Add Connection to bring up the Google BigQuery login window.
3. Enter your Google BigQuery credentials (username and password) and click Sign in. This step is omitted if you are already logged into your Google BigQuery account. Please confirm that this is the appropriate account for your connection. If you do not want it to be tied to your personal account, you may need to enter incognito mode. Note, any future password changes associated with this account will require you to re-authenticate.
4. On the next screen, click Allow access to Google Account to complete the integration. This will allow GoFormz to read and write files to your Google account. GoFormz will not manage any of your Google settings.
Please note that whoever makes the connection of the application will be tied to the integration activity. For example, on the Upload File step, it will show the person who connected the app as the uploader of the file. We recommend creating a 'GoFormz Integration' account for your Google BigQuery account, if you don't want the activity tied to your personal Google BigQuery.
The new connection will appear on your Google BigQuery Connections list with a generic name like “Google BigQuery Connections - 1”. We recommend renaming your connection with a more descriptive name (e.g. including your Google BigQuery username in the connection name), especially if you plan to use multiple Google BigQuery connections. This will make it much easier to tell your connections apart from each other.