Help Shape the Future of Dataiku Join our User Research Program

SQL data type mapping

Mraksu
Level 1
SQL data type mapping

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?

  

0 Kudos
3 Replies
Marlan
Neuron
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
Level 1
Author

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

}

0 Kudos
Marlan
Neuron
Neuron

Hi @Mraksu,

Sorry, I don't know what timestampNoTzAsDate means.

Marlan

0 Kudos
A banner prompting to get Dataiku DSS