SQL data type mapping
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 Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Dataiku Frontrunner Awards 2021 Participant, Neuron 2023 Posts: 323 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
-
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 Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Dataiku Frontrunner Awards 2021 Participant, Neuron 2023 Posts: 323 Neuron