BigQuery

BigQuery

Doc

Features

OLAP, column-oriented storage

Partition

Cluster

Temporary table

View

Procedural

Concurrency control SO

Structure

Level:

• project
• dataset
• table

Create table - DDL

Doc

Create, update, delete data - DML

Doc

Query

Identifier (table name) are escaped with backticks.

SELECT *
FROM `dataset.products`

SQL-compliant : Google SQL

Access - DCL

Doc

Editor

Shortcut:

• execute : Ctrl + Enter
• complete: Ctrl + Space
• format: Ctrl + Shift + F
• comment : Ctrl + /