Querying BigQuery Tables from Clay: Issues with HTTP & JWT

·

Hello, is it possible to query BigQuery tables from Clay? I've tried HTTP & HTTP w/ JWT but don't seem to have much luck.

· Sorted by Oldest

Channeled
APP
·
·
We don't have a direct integration with BigQuery, but you can use our HTTP API or HTTP API with JWT Authentication to query BigQuery tables. Here's how: 1. Set up a BigQuery API endpoint that your Clay table can access. 2. Use either the HTTP API or HTTP API with JWT Authentication in Clay, depending on your BigQuery setup. 3. Configure the integration: • Method: Usually GET for queries • Endpoint: Your BigQuery API endpoint • Headers: Include necessary authentication • Body: Your SQL query in JSON format If you're having trouble, please share your JSON configuration so we can troubleshoot further.
Sources: HTTP API with JWT Authentication with Clay HTTP API with Clay HTTP API with JWT authentication | Documentation | Clay University
Dan R.
·
·
No
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.

Channeled
APP
·
·
We don't have a direct integration with BigQuery, but you can use our HTTP API or HTTP API with JWT Authentication to query BigQuery tables. Here's how: 1. Set up a BigQuery API endpoint that your Clay table can access. 2. Use either the HTTP API or HTTP API with JWT Authentication in Clay, depending on your BigQuery setup. 3. Configure the integration: • Method: Usually GET for queries • Endpoint: Your BigQuery API endpoint • Headers: Include necessary authentication • Body: Your SQL query in JSON format If you're having trouble, please share your JSON configuration so we can troubleshoot further.
Sources: HTTP API with JWT Authentication with Clay HTTP API with Clay HTTP API with JWT authentication | Documentation | Clay University
Dan R.
·
·
No
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.