This article summarizes the features, objects, properties, and data types that are available for BigQuery projects.
Features
Objects and properties
-
Datasets
Friendly name
Table expiration
Table partition expiration
Case-insensitive
-
Collation
Binary
Und:ci
-
Properties
Case-insensitive
Description
-
Friendly name
-
Constraints
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
-
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
-
Friendly name
Materialized
Expires at
Labels
Privacy Policy
Comment/Description
-
Materialized Views
-
Refresh
Refresh interval
Expiration timestamp
Max staleness
- Allow non-incremental definition
- KMS key name
- Labels
- Tags
- Partition by
- Cluster by
-
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
RANGE
-
Semi-structured Data Types
STRUCT
JSON
ARRAY
INTERVAL
-
Geospatial Data Types
GEOGRAPHY