Big query supported data types

Options
Vale_NCH
Vale_NCH Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 6

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.

Tagged:

Answers

  • JordanB
    JordanB Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 293 Dataiker
    Options

    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

Setup Info
    Tags
      Help me…