Google BigQuery Authorization
If you haven't already done so, you will need to set up a Google BigQuery account before you begin the process described below. You can follow the Google quickstart guide and may also want to read the Google BigQuery documentation.
There are two different options for authorization with Google BigQuery:
See Google's authentication documentation for details on the differences between user and service accounts. See the end of this document for information on how to give 3rd parties access to export data in BigQuery.
User account
This option uses your user account to access your Google BigQuery data. You must have permission to list projects, create and write to tables, and create jobs in order for BigQuery exports and imports to run properly.
- Log into your Lytics account.
- Click Data > Integrations and select Google from the Integrations list.
- Select Authorizations from the menu on the left.
- Click New Authorization and select Big Query OAuth.
- From the user selection window, select the Google account you want to use from the list of accounts.
- Click Allow.
- In the Description textbox, enter a meaningful description for this authorization.
- Click Authorize.
Service account
This option uses a service account to access your Google BigQuery data.
- You will need a service account credential file to use this authorization type. If you do not have one, follow the instructions in Google's documentation to create one.
- For imports and exports, the service account must be able to list projects, create and write to tables, and create jobs. The combination of
BigQuery Data Editor
andBigQuery Job User
permissions will satisfy the requirements. Learn more about the BigQuery permissions here.
- For imports and exports, the service account must be able to list projects, create and write to tables, and create jobs. The combination of
- Log into your Lytics account.
- Click Data > Integrations and select Google from the Integrations list.
- Select Authorizations from the menu on the left.
- Click New Authorization and select Big Query Service Account JWT.
- In Cert JSON textbox, copy the contents of the service account's credential file.
- In the Description textbox enter a meaningful description for this authorization.
- Click Authorize.
Give 3rd Parties Access to Export Data in BigQuery
When exporting data from Lytics to BigQuery, you can specify email addresses that you would like to give access to. However, if you later decide that you would like to give access to another person, you can do this from within BigQuery. See Google's documentation regarding access controls for datasets.