Google BigQuery
Google BigQuery
Follow these steps to connect Google BigQuery to your CData Connect Cloud account:
-
Open the Connections page of the CData Connect Cloud dashboard.
-
Click + Add Connection in the upper-right corner.
-
Type Google BigQuery into the search field, then click the data source name.
-
On the Basic Settings tab of the new connection, enter a connection name or keep the default name.
-
In the Project Id field, enter the project Id that you want to use to resolve unqualified tables.
-
Select the Authentication method, then proceed to the relevant section and follow those instructions.
Oauth
-
Click Sign in with Google to connect securely through OAuth. This action opens the Google BigQuery sign-in page on a new tab.
-
Log into your Google BigQuery account.
-
In Google BigQuery, add the CData Connect Cloud static IP addresses to your connection whitelist.
-
At the top of the CData Connect Cloud Add Google BigQuery Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
Oauth JWT
-
Enter the OAuth JWT Cert provided by Google. This is a multi-line key.
-
(Optional) Enter the OAuth JWT Subject if your services account is part of a GSuite domain and you want to enable delegation.
-
In Google BigQuery, add the CData Connect Cloud static IP addresses to your connection whitelist.
-
At the top of the CData Connect Cloud Add Google BigQuery Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
More Information
For more information about interactions between CData Connect Cloud and Google BigQuery, see this information page.