Big query supported data types

Vale_NCH

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.

JordanB

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.

Thanks!

Jordan