BigQuery datatypes

Question

I am starting with a new project and just wanted to verify before defining the table schema

Does BigQuery support anything other than:

string – 
integer –
float– 
boolean – 

Answer 1

BigQuery data types official docs:

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

---

The previous answer lists the basic datatypes:

• STRING
• INTEGER (INT64)
• FLOAT (FLOAT64)
• BOOLEAN

BigQuery also supports:

• RECORD (JSON objects, see nested records)
• TIMESTAMP
• BYTES
• DATE
• TIME
• DATETIME
• ARRAY
• STRUCT

2018 and now also:

• NUMERIC
• GEOGRAPHY

---

More on:

• Nested records: 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