SqlDBM Help Center

All Collections

Database Object and Feature Support

BigQuery Support Summary

BigQuery Support Summary

BigQuery object and data type support summary

S

Written by Serge Gershkovich

Updated over a week ago

This article summarizes the features, objects, properties, and data types that are available for BigQuery projects.

Features

Direct Connect

Objects and properties

Datasets
- Friendly name
- Table expiration
- Table partition expiration
- Case-insensitive
- Collation
  - Binary
  - Und:ci
- Properties
  - Case-insensitive
- Description
Tables
- Friendly name
- Constraints
  - PK
  - FK
- Clustering
- Partitioning
  - Integer range
    Column
    Start
    End
    Interval
  - Ingestion time
    Column
    Hourly
    Daily
    Monthly
  - Time-unit column
    Column
    Hourly
    Daily
    Monthly
- Properties
  - Expires at
  - Table partition expiration (days)
  - Partition filter
  - Case-insensitive
  - Collation
    Inherit from Dataset
    Binary
    Und:ci
- Search index
  - Columns
  - Text analyser
    Default
    No op analyser
    Log analyser
- Comment/Description
Columns
- Data type (see summary of types below)
- (NOT) NULL
- Default
- Collation
  - Inherit from Table
  - Binary
  - Und:ci
- Rounding mode
  - Round half away from zero
  - Round half even
- Comment/Description
Views
- Friendly name
- Materialized
- Expires at
- Comment/Description

Data types

Numeric Data Types
- NUMERIC
- INT64
- INT
- SMALLINT
- INTEGER
- BIGINT
- TINYINT
- BYTEINT
- DECIMAL
- BIGNUMERIC
- BIGDECIMAL
- FLOAT64
String & Binary Data Types
- STRING
Logical Data Types
- BOOL
Date & Time Data Types
- DATE
- DATETIME
- TIME
- TIMESTAMP
Semi-structured Data Types
- STRUCT
- JSON
- ARRAY
- INTERVAL
Geospatial Data Types
- GEOGRAPHY

See also: