Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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?
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 |
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
}