7
Supported
Capabilities you can exercise locally today.
Analytics
BigQuery
Warehouse-style SQL analytics for datasets, tables, and local query development.
4
Gaps
Known gaps and behaviors that are not there yet.
9050 / 9060
Port / Protocol
REST + gRPC
Supported Today
7 items- ~95% Standard SQL (DQL/DDL/DML)
- 120+ functions
- JOINs, CTEs, window functions
- UNNEST, PIVOT
- External tables
- gRPC Storage API
- INFORMATION_SCHEMA
Not Yet Supported
4 items- Scripting (IF/LOOP)
- Stored procedures
- BQML
- Geography functions