LocalCloud BigQuery Emulator Comparison
Get started
local.cloud / agents
Read this page as Markdown ↗
local.cloud — BigQuery Emulator Comparison .md Open tab

LocalCloud BigQuery vs goccy BigQuery emulator

Service guide

1,419 features in total · 919 only in LocalCloud*

Explore the feature comparison

1,419 features in 41 categories. Select a category to see them.

Green counts what LocalCloud supports; red counts features treated as unavailable in goccy BigQuery emulator. Limits appear under Details.

* Provisional comparison. Unassessed competitor features count as unavailable for now. Assessments may be incomplete or outdated; some of these features may be supported.

LocalCloud BigQuery compared with goccy BigQuery emulator, by category
FeatureLocalCloud BigQuerygoccy BigQuery emulatorDetails
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.

Desktop view