BigQuery

Prerequisites

To connect BigQuery to Chat Ur Data, you need the following:

• A BigQuery data warehouse

• A Google Service Account with the following IAM permissions:

  • BigQuery Data Viewer

  • BigQuery Job User

  • BigQuery Metadata Viewer

Here are Google's instructions on how to set up a Service Account: https://cloud.google.com/iam/docs/service-accounts-create

Connect BigQuery to Chat Ur Data

1. Click on "Connect" or "More Options" from the main chat page

1. Select BigQuery from the list

1. Copy the json key from your BigQuery Service Account and paste it into the box

Your JSON key should look something like this:

{
  "type": "service_account",
  "project_id": "your_project",
  "private_key_id": "<long string>",
  "private_key": "-----BEGIN PRIVATE KEY-----\nREALLY LONG STRING\n-----END PRIVATE KEY-----\n",
  "client_email": "[email protected]",
  "client_id": "<a number>",
  "auth_uri": "https://accounts.google.com/o/oauth2/auth",
  "token_uri": "https://oauth2.googleapis.com/token",
  "auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
  "client_x509_cert_url": "long url",
  "universe_domain": "googleapis.com"
}

And you want to paste the entire thing into the Private_Key_JSON box:

1. Click "Save" and Chat Ur Data will connect to your Data Warehouse and start training your first 10 tables automatically

FAQs

Can I use Google OAuth to connect?

This is on our roadmap but not available yet. Contact us at [email protected] if you want to be a beta tester.