Create a Service Account
- Go to the Google Cloud Console
- Select your project
- Navigate to IAM & Admin > Service Accounts
- Click Create Service Account
- Enter a name (e.g.,
credible-bigquery
) - Click Create and Continue
Assign Permissions
Add these roles to the service account:- BigQuery Data Viewer (for read-only access)
- BigQuery Job User (to run queries)
Download the JSON Key
- Find your service account in the list and click on it
- Go to the Keys tab
- Click Add Key > Create new key
- Select JSON and click Create
Connect in Credible
- Go to
your-org.admin.credibledata.com
- Navigate to your project
- Click Add Connection
- Select BigQuery
- Upload the JSON key file
- Test and save the connection
Never commit JSON key files to version control.