🔌Add a Google Big Query connector
Configuring a Google Big Query connection
Fill out the form with the following info:
Name (mandatory)
String
Use it to identify your connection
my-google_big_query_conneciion
GoogleCredentials
Boolean
Use this option if you want to authenticate with the information you will find in your service_account json file
Service Account
String
service_account value located in your service account json file
(see your file)
Project ID
String
project id value located in your service account json file
(see your file)
Private Key Id
String
Private Key Id value located in your service account json file
(see your file)
Private key
String
Private key value located in your service account json file
(see your file)
Client email
String
Client email value located in your service account json file
(see your file)
Client ID
String
Client ID value located in your service account json file
(see your file)
Authentication URI
String
Auth URI value located in your service account json file
(see your file)
Token URI
String
Token URI value located in your service account json file
(see your file)
Authentication provider X509 certificate URL
String
Auth Provider Cert URL value located in your service account json file
(see your file)
Client X509 certification URL
String
Client Cert UR value located in your service account json file
(see your file)
JWTCredentials
Boolean
Use this option if you want to authenticate by sending a JWT token
Project ID
String
Project ID corresponds to the id of your Google Big Query project
project_gbq_id
Json Web token (JWT) signed
String
corresponds to your JWT token you obtain by signing it with your service account json
token
Dialect
Boolean
Tick this case if you want to select a specific dialect used by your server between legacy
and standard
as query standard more information on this documentation. By default we use standard standard
Oauth2 Scope
Array
OAuth 2.0 scopes define the level of access you need to request the Google APIs for more information see this documentation
List of URLs
Retry Policy (optional)
Boolean
Boolean allows to configure a retry policy if the connection is flaky.
max attempts: maximum number of retries before giving up
max_delay: in seconds, above the connection is dropped
wait_time: time in seconds between each retry
Slow Queries' Cache Expiration Time (optional)
Integer
Slow queries' cache expiration time in seconds
Click on the
TEST CONNECTION
button thenSAVE
the connectionAfter successfully configuring the connector, you will be able to find it in the Connector section of the DataHub "Datasource" tab
Create a dataset from a Google Big Query connection
Select a
DB_schema
Select a
Table
Only keep the columns you need
After selecting data from your connector you will be able to create a dataset thanks to YouPrep using the selection as "source step".
Last updated
Was this helpful?