BigQuery Data Types

Question

I start with a new project and just want to check before defining a table schema

Does BigQuery support anything but:

string – integer – float– boolean – 

Answer 1

BigQuery datatype white papers:

• https://cloud.google.com/bigquery/data-types
• https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types

---

The previous answer lists the main data types:

• LINE
• INTEGER
• Float
• BOOLEAN

BigQuery also supports:

• RECORD (JSON objects, see nested entries)
• TIMESTAMP
• BYTE
• DATE
• TIME
• Datetime

More details:

• Nested Entries: https://developers.google.com/bigquery/docs/data#nested
• Using timestamp: https://developers.google.com/bigquery/docs/timestamp
• Docs: https://developers.google.com/bigquery/preparing-data-for-bigquery#datatypes

Answer 2

Yes indeed.

 BigQuery Type ICD Type Length Checks INTEGER Integer FLOAT Decimal STRING Text <65536 BOOLEAN Choice "true" or "false", case-insensitive 

https://developers.google.com/bigquery/articles/ingestionbestpractices#cutplace

Answer 3

Boolean also supports 1 for true and 0 for false and Timestamp supports UTC or "YYYY-MM-DD HH: MM: SSSS"