Steps to integrate BigQuery with Locale.ai
- Download the client_secrets.json file for your service account
- The required parameters is at least one stream (one BigQuery table/view) to copy.
- It is not a recommended BigQuery practice to use * to specify the columns as it may blow up the cost for a table with a large number of columns.
filtersto restrict data being only sent for certain categories or cities
start_datetimethe date after which you want Locale to pick up data from
The table/view is expected to have a column to indicate the creation or update date and time so the tap sends the query with
ORDER BYand use the column to record the bookmark
It is recommended to use Locale with a service account.
Download the client_secrets.json file for your service account, and set up the credentials Follow the basic requirements section above and fill in the required details.