Big query supported data types

Vale_NCH
Level 2
Big query supported data types

Hi,

I'm using Dataiku 11.3.0 Entreprise with BigQuery. 

I need to know the supported data types from Big Query, I found documentation but only about the dataiku 7 version. https://doc.dataiku.com/dss/7.0/connecting/sql/bigquery.html  do you know where I could find more information for this version please?

Thanks,

VN.

0 Kudos
1 Reply
JordanB
Dataiker

Hi @Vale_NCH,

Thanks for the question! The data types listed in the documentation for version DSS 7 still apply. I've provided additional details below:

  • NUMERIC (Instead, DSS will generate DOUBLE columns)
  • DECIMAL (Instead, DSS will generate DOUBLE columns)
  • BYTES (Instead, DSS will generate DOUBLE columns)
  • ARRAY (Instead, DSS will generate STRING columns)
  • STRUCT (Instead, DSS will generate STRING columns)
  • TIME (Instead, DSS will generate STRING columns)
  • TIMESTAMP (Instead, DSS will generate STRING or DATE columns)
  • DATE (Instead, DSS will generate STRING or DATE columns)
  • DATETIME (Instead, DSS will generate STRING or DATE columns)

Note, sql date types with no timestamp are stored in DSS as String unless you've selected one or both of the options below to read SQL dates as DSS dates.

Screen Shot 2023-02-24 at 2.15.40 PM.png

Thanks!

Jordan

0 Kudos