​
Connect Isofold to BigQuery

BigQuery is fully supported by Isofold, including native cost estimation via dry-run mode. You can use Isofold with the bq CLI, client libraries, or REST API.

​
CLI Integration

Update the --api_endpoint flag to route your queries through Isofold.

bq query \
  --project_id=myproject \
  --use_legacy_sql=false \
  --api_endpoint=https://proxy.isofold.com \
  'SELECT * FROM dataset.table'

Use your team’s assigned Isofold proxy URL, such as:

https://myteam.proxy.isofold.com

​
Client Library (Node.js)

Configure the BigQuery client with the apiEndpoint option:

import { BigQuery } from '@google-cloud/bigquery'

const bq = new BigQuery({
  projectId: 'myproject',
  apiEndpoint: 'https://myteam.proxy.isofold.com'
})

​
Client Library (Python)

Set the client_options with the proxy endpoint:

from google.cloud import bigquery
from google.api_core.client_options import ClientOptions

client = bigquery.Client(
  client_options=ClientOptions(
    api_endpoint="https://myteam.proxy.isofold.com"
  )
)

​
Cost Estimation & Verification

Isofold supports:

  • Dry-run optimization using BigQuery’s native cost analysis
  • Verification mode, where both the original and optimized query are run and compared for output equivalence

Enable verification via environment variable:

export ISOFOLD_VERIFY_MODE=true

​
Monitoring Query Savings

After integration, head to your Isofold dashboard to:

  • View query rewrites and diffs
  • Analyze cost savings vs baseline
  • Monitor optimization coverage

Need to run Isofold in your own VPC? See the self-hosted setup.