BigQuery

Connect to Google BigQuery to analyze and visualize your cloud warehouse data directly in Felt.

This feature is only available to customers on the Enterprise plan. To upgrade, contact sales.

1. Create a new, read-only user on your database for Felt access

2. Click on the Library () in the toolbar

3. Click + New Source

4. Select BigQuery

5. Enter Connection Details

   1. Source Name: name of the source in Felt

   2. Project ID: the unique identifier for a Google Cloud Platform project

   3. Dataset: (optional) name of the BigQuery dataset. Datasets are “top-level containers used to organize and control access to your tables”. Learn more.

   4. Service account JSON: Upload a service account JSON with permissions to access your BigQuery tables. To create a new service account, navigate to the IAM & Admin page of the Google Cloud Console and generate a JSON file for it in the Keys tab. When creating the account, make sure to grant it access to your project for the BigQuery Data Viewer, BigQuery Metadata Viewer and BigQuery Job User roles.

   5. Who can see this source?: control access to this source within Felt

6. Click Connect

7. Once connected you will see a catalog of your data with previews for your new source

8. From here you can add any of these layers to your spatial dashboards!

If your BigQuery contains EXTERNAL tables (such as Google Sheets or objects in Cloud Storage), you must also make sure the service account has the following permissions:

• storage.objects.get

• storage.objects.list

Custom queries and views in BigQuery have an output limit of 10GB. For queries or views larger than this, switch to using tables (BigQuery tables do not have this limit) or filter the data further to lower the output size.