Connecting a BigQuery Warehouse

Google BigQuery

• Connecting Precog
• Connecting Stitch

Connecting Precog

1. In the Panoply navigation menu, click BI Connection. This displays your Panoply data warehouse's connection details. 
2. Download the .json credentials file.
3. Sign into your Precog account.
4. Click the Destinations
5. Search for Panoply BigQuery
6. Click the Panoply icon.
7. Name the destination.
8. Enter the dataset you wish to send the data to.
9. Upload the .json file you downloaded in step 2.
10. Click on Add.
11. Select which tables you wish to connect to this destination.

Connecting Stitch

1. In the Panoply navigation menu, click BI Connection. This displays your Panoply data warehouse's connection details. 
2. Download the .json credentials file.
3. Sign into your Stitch account.
4. Click the Destination tab.
5. Click the Google BigQuery icon.
6. Scroll to the Your service account section.
7. In the Your Key File field, click the icon and locate the JSON credentials file you downloaded in Step 3. Once uploaded, the BigQuery Project Name field will automatically populate with the name of the GCP project in the JSON project key file.
8. Select a Google Storage Location by using the Google Cloud Storage Location dropdown, then select a US region.  

9. There are two definitions for the loading behavior:

* Upsert: Existing rows will be updated with the most recent version of the record from the source. With this option, only the most recent version of a record will exist in Google BigQuery.
* Append: Existing rows aren’t updated. Newer versions of existing records are added as new rows to the end of tables. With this option, many versions of the record will exist in Google BigQuery, capturing how a record changed over time.

• Refer to the Understanding loading behavior guide for more info and examples.

10. Click Check and Save. Stitch will perform a connection test to the Google BigQuery database; if successful, a Success message will display at the top of the screen. This test may take a few minutes to complete.