BigQuery Wrapper
Overview
BigQuery is Google Cloud's autonomous data and AI platform: a serverless data warehouse built for petabyte-scale analytics, with built-in ML, multimodal data support, and Gemini-powered AI features. It's where teams run large analytical workloads that don't belong in an operational database.
The BigQuery Wrapper brings that warehouse into your Postgres database. Query BigQuery tables and views directly with SQL, write data back from Postgres, and join warehouse results against your live application data. No ETL pipelines, no data movement, no scheduled syncs.
Supports both read and write operations, and works with Supabase Vault for secure service account credential management.
Supported Operations
| Operation | Supported |
|---|---|
| Select | ✅ |
| Insert | ✅ |
| Update | ✅ |
| Delete | ✅ |
Supported Data Types
| Postgres Type | BigQuery Type |
|---|---|
| boolean | BOOL |
| bigint | INT64 |
| double precision | FLOAT64 |
| numeric | NUMERIC |
| text | STRING |
| varchar | STRING |
| date | DATE |
| timestamp | DATETIME |
| timestamp | TIMESTAMP |
Resources
Details
Third-party integrations and docs are managed by Supabase partners.