# LocalCloud BigQuery vs goccy BigQuery emulator

> Compare LocalCloud BigQuery with goccy BigQuery emulator. Explore feature support and filter capabilities available only in LocalCloud.
>
> Source: https://local.cloud/compare/emulators/bigquery/

[Service guide](https://local.cloud/services/bigquery/)

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

## Explore the feature comparison

Show features

Only in LocalCloud All features

Search features

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.

| Feature | LocalCloud BigQuery | goccy BigQuery emulator | Details |
| --- | --- | --- | --- |
| Metadata / Advanced 49 features | 49 supported | 44 not supported (includes unassessed) | Snapshots, advanced security and external query workflows. |
| Metadata / Enterprise 32 features | 28 supported | 32 not supported (includes unassessed) | Governance, administration and enterprise ML workflows. |
| Metadata / INFORMATION\_SCHEMA 38 features | 35 supported | 34 not supported (includes unassessed) | Query metadata for datasets, tables, jobs and reservations. |
| Metadata / Schema 4 features | 4 supported | 4 not supported (includes unassessed) | Define typed, nested, repeated and nullable fields. |
| REST API / Datasets 7 features | 7 supported | 1 not supported (includes unassessed) | Create, update, delete and restore datasets. |
| REST API / Jobs 6 features | 6 supported | 0 not supported | Submit and cancel jobs; read status and results. |
| REST API / Models 4 features | 4 supported | 0 not supported | List, inspect, update and delete stored models. |
| REST API / Projects 2 features | 2 supported | 0 not supported | List projects and retrieve the BigQuery service account. |
| REST API / Routines 5 features | 5 supported | 4 not supported | Create reusable functions and stored procedures. |
| REST API / Row access policies 6 features | 6 supported | 6 not supported (includes unassessed) | Manage policies that restrict access to rows. |
| REST API / Tabledata 2 features | 2 supported | 0 not supported | Stream rows and read table data over REST. |
| REST API / Tables 9 features | 9 supported | 3 not supported | Manage tables, schemas, metadata and access policies. |
| REST API / Upload 3 features | 3 supported | 0 not supported | Upload job inputs with multipart and resumable requests. |
| SQL / BigQuery ML 55 features | 55 supported | 55 not supported (includes unassessed) | Train and import models, forecast values, detect anomalies, inspect predictions and preprocess features. |
| SQL / CTEs (Common Table Expressions) 4 features | 4 supported | 4 not supported (includes unassessed) | Reuse query results with WITH and recursive CTEs. |
| SQL / Clauses 11 features | 11 supported | 11 not supported (includes unassessed) | Group and aggregate results with grouping extensions. |
| SQL / DCL 3 features | 3 supported | 3 not supported (includes unassessed) | Grant and revoke SQL access for users and roles. |
| SQL / DDL 290 features | 260 supported | 286 not supported (includes unassessed) | Create and alter tables, views, routines, models and indexes. |
| SQL / DML 30 features | 30 supported | 30 not supported (includes unassessed) | Insert, update, delete and merge rows with SQL. |
| SQL / Expressions 46 features | 46 supported | 46 not supported (includes unassessed) | Calculate values with conditions, casts and constructors. |
| SQL / External 13 features | 10 supported | 13 not supported (includes unassessed) | Query external files and services through connections. |
| SQL / FROM 4 features | 4 supported | 4 not supported (includes unassessed) | Read inputs from tables, subqueries and table expressions. |
| SQL / Functions 422 features | 412 supported | 38 not supported (includes unassessed) | Transform and aggregate values with SQL functions. |
| SQL / Hints 1 feature | 0 supported | 1 not supported (includes unassessed) | Select dialects and provide execution hints. |
| SQL / JOIN 11 features | 11 supported | 11 not supported (includes unassessed) | Join rows across inputs with types and conditions. |
| SQL / Lexical 38 features | 38 supported | 38 not supported (includes unassessed) | Write SQL identifiers, literals and comments. |
| SQL / ORDER BY / LIMIT 1 feature | 1 supported | 1 not supported (includes unassessed) | Sort results and limit rows with offsets. |
| SQL / Operators 22 features | 22 supported | 22 not supported (includes unassessed) | Calculate, compare and combine scalar and array values. |
| SQL / Other DQL features 2 features | 2 supported | 2 not supported (includes unassessed) | Sample rows and use other query operations. |
| SQL / Parameterized Queries 2 features | 2 supported | 2 not supported (includes unassessed) | Bind named or positional query parameters. |
| SQL / Pipe Syntax 2 features | 2 supported | 2 not supported (includes unassessed) | Chain query transformations with the pipe operator. |
| SQL / SELECT 132 features | 132 supported | 127 not supported (includes unassessed) | Select columns and expressions with advanced SELECT forms. |
| SQL / Scripting 47 features | 47 supported | 34 not supported (includes unassessed) | Use variables, control flow, procedures and error handling. |
| SQL / Set operations 7 features | 7 supported | 7 not supported (includes unassessed) | Combine results with UNION, INTERSECT and EXCEPT. |
| SQL / Subqueries 4 features | 4 supported | 4 not supported (includes unassessed) | Nest queries with arrays, IN and EXISTS. |
| SQL / Types 76 features | 75 supported | 73 not supported (includes unassessed) | Represent and convert scalar, array and structured types. |
| SQL / WHERE 3 features | 3 supported | 3 not supported (includes unassessed) | Filter rows with predicates and conditions. |
| SQL / WildcardTables 2 features | 2 supported | 1 not supported (includes unassessed) | Query tables by wildcard name and suffix. |
| SQL / Window Functions 8 features | 8 supported | 8 not supported (includes unassessed) | Calculate across rows with window partitions and frames. |
| Storage Read API 8 features | 7 supported | 6 not supported (includes unassessed) | Read columns in parallel as Arrow or Avro streams. |
| Storage Write API 8 features | 8 supported | 2 not supported (includes unassessed) | Append rows to committed, pending or buffered streams. |

### Data

[Download the comparison as JSON](https://local.cloud/_astro/bigquery.qIdGaAEd.json)

**Comparison notes.** Covers ML, external tables, federation, policies, snapshots and clones alongside SQL. Compared with [goccy BigQuery emulator](https://github.com/goccy/bigquery-emulator/tree/cb8555bee739c794343337e8c3242b59d5d7470a). 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.

[Compare another service](https://local.cloud/compare/emulators/)
