Data types:

  • Integer (8 bytes)
  • Float64 (8 bytes)
  • Bool
  • String
  • Bytes
  • Date
  • Datetime (=civil time and date )
  • Time
  • Timestamp (=absolute time in UTC independent on civil changes0
  • Array
  • Struct<type>

 

Query syntax

  • WITH query_name AS ( … ORDER BY … LIMIT … OFFSET … )
    SELECT ALL | DISTINCT *
    EXCEPT ( column_name, …)
    REPLACE ( expression AS column_name, )
    FROM ….
    WHERE …
    GROUP BY …
    HAVING …
    WINDOW name AS ( … )
    ORDER BY …
    LIMIT …
    OFFSET …
  • UNION ALL | DISTINCT
  • From: UNNEST
  • Window functions:
    • OVER … PARTITION BY …
    • WINDOW
  • Join:
    • INNER
    • CROSS
    • FULL OUTER
    • LEFT OUTER
    • RIGHT OUTER