BigQuery is a fully-managed, serverless data warehouse that enables scalable analysis over petabytes of data. It is a Platform as a Service that supports querying using ANSI SQL.
- A. Set up a Google BigQuery connection
- B. Edit Google BigQuery application details
- C. Edit advanced Google BigQuery settings
- D. Save and authorize the connection
Start establishing a connection to Google BigQuery in either of the following ways:
- From the Resources menu, select Connections. Then, click + Create connection at the top right.
– or –
- While working in a new or existing integration, you can add an application to a flow simply by clicking Add source or Add destination.
In the resulting Application list, click Google BigQuery.
The Create connection pane opens with required and advanced settings.
At this point, you’re presented with a series of options for providing Google BigQuery authentication.
Name (required): Provide a clear and distinguishable name. Throughout integrator.io imports and exports, you will have the option to choose this new connection, and a unique identifier will prove helpful later when selecting among a list of connections that you’ve created.
Application (required, non-editable): A reminder of the app you’re editing.
Configure scopes (required): Scopes are permissions that the Google BigQuery API defines to limit access to your account.
Redirect (callback) URL (read-only): Use the callback URL to exchange secure messages with the authorization server after authentication. You must whitelist this URL with your authorization server.
Configure your client id and secret (required): Check this box to reveal iClient options.
iClient (required): Select the iClient pair that stores the client ID and client secret provided to you by Google BigQuery. To add an iClient and configure your credentials, click the plus (+) button. Click the edit ( ) button to modify a selected iClient. Be sure to give the iClient a recognizable name for use in any other connections.
Sign in to your Google BigQuery account at console.cloud.google.com/bigquery, and select Credentials from the APIs & services menu.
Click Configure consent screen.
Determine whether the application will be Public or Internal. We recommend setting the application to Internal, so it's only available to your organization.
Proceed to the OAuth consent screen page. Provide an application name and add integrator.io to the list of Authorized domains. Click Save and continue.
Add or remove the scopes you selected in integrator.io, and select Save and continue.
To create an OAuth client ID, click Create credentials → OAuth client ID at the top.
Click Web application from the dropdown menu and provide a unique name. Paste the Callback URL provided in integrator.io into the application’s Authorized redirect URIs and click Create.
Your Client Id and secret are available after you click Create.
Copy and paste your Client Id and secret into integrator.io to complete the connection.
Important: Google BigQuery has standard rate quotas and limits for tables.
Before continuing, you have the opportunity to provide additional configuration information, if needed, for the Google BigQuery connection.
Once you have configured the Google BigQuery connection, you have two options for continuing:
- Save & authorize – click this button to test the connection, commit the new connection so that it will be available to all integrations for your account (and applied to the current source or destination app, if you created it within a flow)
- Cancel – click to exit without saving any new changes
When you select Save & authorize, you are presented with a Google BigQuery form in a new browser window.
After signing in, review the permissions for the integration and click Allow.
The browser window closes, and the new connection is now successfully added to your account. It will be applied to the current source or destination app, if you created it within a flow. Otherwise, you may proceed to register the connection with an integration.