disable automatic dataiku parsing when creating a table from Teradata data
Yasmine
Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 14 ✭✭✭
Hello Dataiku team,
In my project, I started by using a SQL recipe to create a table from several tables present in teradata (CREATE TABLE then SELECT *) , I found in the output table (table_personne) that DSS transforms automatically all dates into "DSS Dates" (Parsed), while my data is in the form "yyyy-MM-dd" on Teradata. Do you, please, if there is a configuration to be made to keep the same format of the dates of the Teradata source data ?
Thank you in advance for your return.
Sincerely,
Yasmine
Answers
-
Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,212 Dataiker
Hi Yasmine,
Can you try unchecking : Read SQL "date" as DSS dates?
From the setting of the SQL dataset:
We would also want to make sure that the date column is configured as a string in your schema. To avoid DSS from parsing the date.
Thanks,