SQL data type mapping

Mraksu

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?

Marlan

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

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

Hi @Mraksu
,

Sorry, I don't know what timestampNoTzAsDate means.

Marlan