Bigquery
Introduction
Qobra connects to Bigquery through google service accounts.
The integration is used to synchronize exposed tables, their columns and their content. This integration is readonly and does not write anything in your Bigquery database.
Setup
- Create a service account from your google account, it should look something like this:
-
You’ll then be able to fill in connection modal in app:
Service account
: Service accountDataset
: Bigquery dataset
Synchronization
Table requirements
To synchronize a file to Qobra, it must meet requirements:
- the file contains a unique identifier column
- the file contains a name column
- the user values contained in the file must be emails by default, but it can be changed in app at table creation
Total synchronization
This integrations does total synchronization, meaning the whole document will be synced at every refresh.
Refresh schedule
You can edit this integration synchronization periods in application, to better suit your needs.
Supported types
You’ll find below the fields types supported by the Qobra integration, and their mapping to Qobra types.
Bigquery type | Qobra type |
---|---|
STRING | string , picklist , multipicklist , user |
INT64 | number , amount , percentage , user , picklist , multipicklist |
FLOAT64 | number , amount , percentage |
NUMERIC | number , amount , percentage |
TIMESTAMP | date |
DATE | date |
DATETIME | date |
BOOL | bool |
Custom querying
With this integration, you can apply a custom query to your table synchronization, to avoid synchronizing too much information, consequently making synchronization quicker.
Custom queries are based on SQL where conditions. For instance, you could add as a custom query StageName = 'Closed Won’
to filter your Opportunity object.
Contact support for more information.
Was this page helpful?