Clay Icon
Join the Community
02 Support

Querying BigQuery Tables from Clay: Issues with HTTP & JWT

Avatar of Dan R.Dan R.
·
·

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.

3 comments

  • Avatar of Channeled
    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.

  • Avatar of Dan R.
    Dan R.
    ·
    ·

    No

  • Avatar of Channeled
    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.