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
Connect BigQuery to Chat Ur Data
Click on "Connect" or "More Options" from the main chat page
Select BigQuery from the list
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:
Click "Save" and Chat Ur Data will connect to your Data Warehouse and start training your first 10 tables automatically
FAQs
Last updated