{"slug":"hubvibe-io-com-work-data-query-2b034a","title":"Execute a read-only BigQuery SQL query, including against Google's public datase","host":"hubvibe-io.com","method":"POST","resource":"https://hubvibe-io.com/work/data/query","category":"code","description":"Execute a read-only BigQuery SQL query, including against Google's public datasets, and get the rows back as JSON. Every query is dry-run first and refused if it would scan more than the byte ceiling, so cost is bounded before anything runs.","price_listed":0.5,"price_asked":0.5,"state":"answering","state_label":"Answering","checks_7d":1,"answered_7d":1,"latency_ms_median":828,"reported_calls_30d":3,"reported_payers_30d":1,"networks":["eip155:8453","solana:5eykt4UsFv8P8NJdTREpY1vzqKqZKvdp"],"badge":"unverified","paid_checks_7d":0,"paid_ok_7d":0,"example_input":{"body":{"sql":"example"},"bodyType":"json","method":"POST","type":"http"},"output_schema":{"$schema":"https://json-schema.org/draft/2020-12/schema","properties":{"input":{"additionalProperties":false,"properties":{"body":{"additionalProperties":false,"properties":{"max_scan_gib":{"description":"Optional scan ceiling.","type":"number"},"sql":{"description":"Read-only SELECT or WITH query.","type":"string"}},"required":["sql"],"type":"object"},"bodyType":{"enum":["json","form-data","text"],"type":"string"},"method":{"enum":["POST","PUT","PATCH"],"type":"string"},"type":{"const":"http","type":"string"}},"required":["type","method","bodyType","body"],"type":"object"},"output":{"properties":{"example":{"$schema":"https://json-schema.org/draft/2020-12/schema","description":"The 200 body of every paid /work call. `result` is the worker's own output (its schema is per route); everything else is the same on all 38 routes. A receipt for the job is at `receipt_url`.","properties":{"billing_warning":{"description":"Present only when the charge was recorded with a caveat.","examples":["settlement pending"],"type":"string"},"price_usd":{"description":"What this call cost, in USD.","examples":[0.02],"type":"number"},"provenance":{"description":"How the result was produced: which providers ran and how long each took.","properties":{"attempts":{"description":"Provider attempts made, including retries and failovers.","examples":[1],"type":"integer"},"elapsed_ms":{"description":"Wall-clock milliseconds for the whole job.","examples":[340],"type":"integer"},"providers_used":{"description":"Providers that served the job.","examples":[["coinbase-advanced-trade-public"]],"items":{"description":"Provider name.","examples":["coinbase-advanced-trade-public"],"type":"string"},"type":"array"},"steps":{"description":"Every step the job ran, in order.","items":{"description":"One step of the job.","properties":{"ms":{"description":"Milliseconds the step took.","examples":[312],"type":"integer"},"ok":{"description":"Whether the step succeeded.","examples":[true],"type":"boolean"},"provider":{"description":"Provider that served the step.","examples":["coinbase-advanced-trade-public"],"type":"string"},"reason":{"description":"Failure reason, on a failed step.","examples":["provider_timeout"],"type":"string"},"step":{"description":"Step name inside the worker.","examples":["quote"],"type":"string"}},"required":["step","ok","ms"],"type":"object"},"type":"array"}},"required":["steps","providers_used","attempts","elapsed_ms"],"type":"object"},"receipt_id":{"description":"Receipt id for this job.","examples":["rcpt_9f1c2b3a4d5e6f70"],"type":"string"},"receipt_url":{"description":"Where to fetch the machine-readable receipt (free, no payment).","examples":["/work/receipts/rcpt_9f1c2b3a4d5e6f70"],"type":"string"},"result":{"properties":{"cache_hit":{"description":"Whether BigQuery served it from cache (no bytes billed).","examples":[false],"type":"boolean"},"columns":{"description":"Result column names, in order.","examples":[["name","n"]],"items":{"description":"Column name.","examples":["name"],"type":"string"},"type":"array"},"gib_processed":{"description":"Gibibytes BigQuery scanned; the metered cost basis.","examples":[0.012],"type":"number"},"row_count":{"description":"Rows returned (capped).","examples":[5],"type":"integer"},"rows":{"description":"Result rows, keyed by column name.","examples":[[{"n":4942431,"name":"James"}]],"items":{"additionalProperties":true,"description":"One row keyed by column name.","examples":[{"n":4942431,"name":"James"}],"properties":{},"required":[],"type":"object"},"type":"array"},"sql":{"description":"The SQL that ran.","examples":["SELECT name, SUM(number) AS n FROM `bigquery-public-data.usa_names.usa_1910_2013` GROUP BY name ORDER BY n DESC LIMIT 5"],"type":"string"},"total_rows":{"description":"Rows the query produced before the cap.","examples":[5],"type":"integer"},"truncated":{"description":"Whether rows were cut at the cap.","examples":[false],"type":"boolean"}},"required":["sql","columns","rows","row_count","total_rows","truncated","gib_processed","cache_hit"],"type":"object"},"status":{"const":"ok","description":"Present only on a delivered result.","type":"string"},"worker":{"description":"Catalog name of the worker that ran.","examples":["market.quote"],"type":"string"}},"required":["status","worker","price_usd","result","provenance","receipt_id","receipt_url"],"title":"data.query response","type":"object"},"type":{"type":"string"}},"required":["type"],"type":"object"}},"required":["input"],"type":"object"},"history":[{"day":"2026-09-24","reachable":true,"status":402,"valid_402":true,"asked_usdc":0.5,"price_match":true,"latency_ms":828,"error":null}],"description_full":"Execute a read-only BigQuery SQL query, including against Google's public datasets, and get the rows back as JSON. Every query is dry-run first and refused if it would scan more than the byte ceiling, so cost is bounded before anything runs.","last_updated":"2026-09-23T15:04:41.9Z","schemes":["exact"]}