Analytics

BigQuery

Warehouse-style SQL analytics for datasets, tables, and local query development.

7
Supported

Capabilities you can exercise locally today.

4
Gaps

Known gaps and behaviors that are not there yet.

9050 / 9060
Port / Protocol

REST + gRPC

Supported Today

7 items
  • ~96% SQL coverage across DQL/DDL/DML
  • 175+ mapped BigQuery functions
  • Full scripting and stored procedures
  • JOINs, CTEs, window functions, UNNEST, PIVOT
  • External tables for Parquet, CSV, JSON
  • REST API and simplified gRPC Storage API
  • 11 INFORMATION_SCHEMA views

Not Yet Supported

4 items
  • BQML
  • AEAD encryption functions
  • Security policy enforcement
  • Full GEOGRAPHY parity (12 ST_* functions supported)