Want to Stop Rebuilding "Expensive" Parts of your Flow? Explicit Builds are the Answer!READ MORE

disable automatic dataiku parsing when creating a table from Teradata data

Yasmine
Level 2
disable automatic dataiku parsing when creating a table from Teradata data

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 ?

Test_timestamp.PNG

Thank you in advance for your return.


Sincerely,

Yasmine

0 Kudos
1 Reply
AlexT
Dataiker
Dataiker

Hi Yasmine, 

Can you try unchecking : Read SQL "date" as DSS dates? 

From the setting of the SQL dataset:

Screenshot 2021-12-11 at 13.46.46.png

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, 

0 Kudos