BigQuery

1. Log into your Google Cloud console at console.cloud.google.com

2. Choose your relevant Google Cloud Project from the top bar. If you do not have a Google Cloud Project yet, you can create one following the instructions here.

3. In the sidebar menu, choose IAM and admin > Service accounts.  

4. Click on Create Service Account.  

5. Fill in service account name, e.g. converge-bigq-account and click on Create and continue.  

11. Under Grant this service account access to the project, choose the BigQuery Data Owner and BigQuery Job User scopes and click on Done.  

12. Pick your newly created service account from the list of Service Accounts and choose Manage keys.  

13. Click on Add Key and Create new key. In the popup choose JSON and click on Create. This will download a file that ends with .json.  

14. In the Converge sidebar, click on
    Data warehouse
    and then click Connect data warehouse.
15. Select the BigQuery destination and click Next.
16. Give your destination a name (e.g. BigQuery Data Warehouse) and click Next.
17. Click the Credentials field and select the .json file containing your service account key created in step 13.
18. Fill in the Dataset ID with the dataset ID from Google Cloud.
19. Fill in the Table ID with the table ID you’d like to send data. This table should not exist in BigQuery yet as it will be updated by the destination.
20. In Advanced configuration, you can optionally fill in the Staging Table ID, if you would like to use a different table name. By default, Converge will use the same table name as the Table ID but with a _staging suffix.
21. Click Next.
22. Fill in the Start date with a date in the past from which you’d like to send data. Click Next.
23. Review any issues and click Connect data warehouse.

Converge will now start sending data to your BigQuery table.