Querying BigQuery Tables from Clay: Issues with HTTP & JWT

Dan R. · 2025-05-02T18:28:51.332388+00:00

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.

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

3 comments