LocalCloud BigQuery vs goccy BigQuery emulator
Service guideExplore the feature comparison
* Provisional comparison. Unassessed competitor features count as unavailable for now. Assessments may be incomplete or outdated; some of these features may be supported.
| Feature | LocalCloud BigQuery | goccy BigQuery emulator | Details |
|---|---|---|---|
| 49 supported | 44 not supported (includes unassessed) | Snapshots, advanced security and external query workflows. | |
| 28 supported | 32 not supported (includes unassessed) | Governance, administration and enterprise ML workflows. | |
| 35 supported | 34 not supported (includes unassessed) | Query metadata for datasets, tables, jobs and reservations. | |
| 4 supported | 4 not supported (includes unassessed) | Define typed, nested, repeated and nullable fields. | |
| 7 supported | 1 not supported (includes unassessed) | Create, update, delete and restore datasets. | |
| 6 supported | 0 not supported | Submit and cancel jobs; read status and results. | |
| 4 supported | 0 not supported | List, inspect, update and delete stored models. | |
| 2 supported | 0 not supported | List projects and retrieve the BigQuery service account. | |
| 5 supported | 4 not supported | Create reusable functions and stored procedures. | |
| 6 supported | 6 not supported (includes unassessed) | Manage policies that restrict access to rows. | |
| 2 supported | 0 not supported | Stream rows and read table data over REST. | |
| 9 supported | 3 not supported | Manage tables, schemas, metadata and access policies. | |
| 3 supported | 0 not supported | Upload job inputs with multipart and resumable requests. | |
| 55 supported | 55 not supported (includes unassessed) | Train and import models, forecast values, detect anomalies, inspect predictions and preprocess features. | |
| 4 supported | 4 not supported (includes unassessed) | Reuse query results with WITH and recursive CTEs. | |
| 11 supported | 11 not supported (includes unassessed) | Group and aggregate results with grouping extensions. | |
| 3 supported | 3 not supported (includes unassessed) | Grant and revoke SQL access for users and roles. | |
| 260 supported | 286 not supported (includes unassessed) | Create and alter tables, views, routines, models and indexes. | |
| 30 supported | 30 not supported (includes unassessed) | Insert, update, delete and merge rows with SQL. | |
| 46 supported | 46 not supported (includes unassessed) | Calculate values with conditions, casts and constructors. | |
| 10 supported | 13 not supported (includes unassessed) | Query external files and services through connections. | |
| 4 supported | 4 not supported (includes unassessed) | Read inputs from tables, subqueries and table expressions. | |
| 412 supported | 38 not supported (includes unassessed) | Transform and aggregate values with SQL functions. | |
| 0 supported | 1 not supported (includes unassessed) | Select dialects and provide execution hints. | |
| 11 supported | 11 not supported (includes unassessed) | Join rows across inputs with types and conditions. | |
| 38 supported | 38 not supported (includes unassessed) | Write SQL identifiers, literals and comments. | |
| 1 supported | 1 not supported (includes unassessed) | Sort results and limit rows with offsets. | |
| 22 supported | 22 not supported (includes unassessed) | Calculate, compare and combine scalar and array values. | |
| 2 supported | 2 not supported (includes unassessed) | Sample rows and use other query operations. | |
| 2 supported | 2 not supported (includes unassessed) | Bind named or positional query parameters. | |
| 2 supported | 2 not supported (includes unassessed) | Chain query transformations with the pipe operator. | |
| 132 supported | 127 not supported (includes unassessed) | Select columns and expressions with advanced SELECT forms. | |
| 47 supported | 34 not supported (includes unassessed) | Use variables, control flow, procedures and error handling. | |
| 7 supported | 7 not supported (includes unassessed) | Combine results with UNION, INTERSECT and EXCEPT. | |
| 4 supported | 4 not supported (includes unassessed) | Nest queries with arrays, IN and EXISTS. | |
| 75 supported | 73 not supported (includes unassessed) | Represent and convert scalar, array and structured types. | |
| 3 supported | 3 not supported (includes unassessed) | Filter rows with predicates and conditions. | |
| 2 supported | 1 not supported (includes unassessed) | Query tables by wildcard name and suffix. | |
| 8 supported | 8 not supported (includes unassessed) | Calculate across rows with window partitions and frames. | |
| 7 supported | 6 not supported (includes unassessed) | Read columns in parallel as Arrow or Avro streams. | |
| 8 supported | 2 not supported (includes unassessed) | Append rows to committed, pending or buffered streams. |
Comparison notes. Covers ML, external tables, federation, policies, snapshots and clones alongside SQL. Compared with goccy BigQuery emulator. Full edition counts. ML.DISTANCE also works in Lite. Generative ML needs a provider. Unassessed competitor results provisionally count as unavailable. Category counts can overlap.