Community Conundrum 25: Feature Visualization is now live! Read More

SQL data type mapping

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
Level 4

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

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
Level 4

Hi @Mraksu,

Sorry, I don't know what timestampNoTzAsDate means.

Marlan

0 Kudos