BigQuery as a Data Source
Openprise supports importing data from Google BigQuery into Openprise. To import BigQuery tables, you must create an Openprise data source and choose Amazon Google BigQuery as the Source Technology.
Learn more about how to configure a Data Source here. Please note, you will need to pick "Google BigQuery" as the Source Technology type.
Once you choose the technology type, you will be asked to add account information so that Openprise can communicate and authenticate to your Google BigQuery account. The authentication pop-up will be as follows:
- clientID - Google Cloud account ID
- clientEmail - Google Cloud account email
- project_ID - project ID where Openprise can run queries from
- privateKey - private key tied to an end users BigQuery service account; used to authenticate to Google
- privateKeyID - private key ID tied to an end users BigQuery service account; used to authenticate to Google
- scopes - read, write, delete permissions for the project being authenticated
- token_uri - url that sends a token request to BigQuery to authenticate the end user
- serviceAccountUser - service account user tied to an end users BigQuery service account; used to authenticate to Google
- quotaProjectID - API quota associated to project being authenticated
Once you enter those details, click on "Test Authentication" to verify that Openprise can reach your Google BigQuery.
BigQuery as a Data Target
Openprise also supports exporting data from Openprise back into your Google BigQuery account. To export records back into BigQuery, you must first create a Data Target and choose Google BigQuery as the Target Technology.
You can find out more about Data Targets here. You will need to pick "Google BigQuery" as the Source Technology type, and list which BigQuery fields Openprise has permission to update.