Skip to content

DuckDB BigQuery Extension

DuckDB Community Extension Latest Release Build and Test License: MIT

This community extension allows DuckDB to query data from Google BigQuery using a mix of BigQuery Storage (Read/Write) and REST APIs. You can explore, query, create, and modify BigQuery tables and datasets directly from DuckDB using standard SQL queries. Dedicated functions cover direct table scans, GoogleSQL queries, load and extract jobs, and job inspection.

Inspired by official DuckDB storage extensions like MySQL, PostgreSQL, and SQLite, this extension offers a similar feel.

With the extension, you can:

  • Attach a project or dataset as a DuckDB catalog and explore it with SHOW and DESCRIBE.
  • Read native tables through the BigQuery Storage Read API with projection and filter pushdown.
  • Run GoogleSQL and read views, materialized views, and external tables.
  • Create and alter datasets, tables, and views with DuckDB SQL.
  • Insert, update, and delete data, or write DuckDB query results to BigQuery.
  • Submit and inspect query, load, and extract jobs.
  • Read and write BigQuery GEOGRAPHY as DuckDB GEOMETRY('OGC:CRS84').

Version and platform compatibility

Community builds are available for linux_amd64, linux_arm64, osx_amd64, osx_arm64, and windows_amd64. The builds wasm_mvp, wasm_eh, wasm_threads, and windows_amd64_mingw are not supported.

Current development targets DuckDB 1.5. The latest extension changes are available only in builds for DuckDB 1.5 and are not backported to older DuckDB release branches.

To make your first connection, follow Install, Attach, and Query.

Important Notes

Disclaimer: Independent community project

This project is independently maintained and is not affiliated with, endorsed by, or officially supported by Google LLC or DuckDB Labs. BigQuery and DuckDB are trademarks of their respective owners. The extension is provided without warranties; users are responsible for their use, compliance, and incurred charges.

When using this software with Google BigQuery, please ensure your usage complies with the Google API Terms of Service. Be mindful of the usage limits and quotas, and adhere to Google's Fair Use Policy.

Billing and Costs

Please be aware that using Google BigQuery through this software can incur costs. Google BigQuery is a paid service, and charges may apply based on the amount of data processed, stored, and the number of queries executed. Users are responsible for any costs associated with their use of Google BigQuery. For detailed information on BigQuery pricing, please refer to the Google BigQuery Pricing page. It is recommended to monitor your usage and set up budget alerts in the Google Cloud Console to avoid unexpected charges.

By using this software, you acknowledge and agree that you are solely responsible for any charges incurred from Google BigQuery.