SQL data type mapping

Mraksu
Mraksu Registered Posts: 2 ✭✭✭

Hello everyone,

I would like to know which SQL server datatype matches with the Dataiku datatype. Is there that kind of datatype mapping between SQL server and Dataiku?

Answers

  • Marlan
    Marlan Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Dataiku Frontrunner Awards 2021 Participant, Neuron 2023 Posts: 319 Neuron

    Here is the mapping for another SQL database (Netezza). I'd think that the mapping for SQL Server is similar if not the same.

    Marlan

    SQL Table

    DSS Schema

    byteint / tinyint

    tinyint

    smallint

    smallint

    integer

    int

    bigint

    bigint

    real

    float

    double / numeric

    double

    char / varchar

    string

    date / timestamp / datetime

    date

  • Mraksu
    Mraksu Registered Posts: 2 ✭✭✭

    Hello Marlan,

    Thank you for your response, I believe your answer is accurate.

    However, in dataset metadata some date type columns has boolean value for a 'timestampNoTzAsDate" variable. What is the meaning of this?

    For instance:

    {

    name: "startdate"

    type: "date"

    timestampNoTzAsDate : true

    }

  • Marlan
    Marlan Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Dataiku Frontrunner Awards 2021 Participant, Neuron 2023 Posts: 319 Neuron

    Hi @Mraksu
    ,

    Sorry, I don't know what timestampNoTzAsDate means.

    Marlan

Setup Info
    Tags
      Help me…