disable automatic dataiku parsing when creating a table from Teradata data

Yasmine

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

Alexandru

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,