disable automatic dataiku parsing when creating a table from Teradata data

Yasmine
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 ?

Test_timestamp.PNG

Thank you in advance for your return.


Sincerely,

Yasmine

Answers

  • Alexandru
    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:

    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,

Setup Info
    Tags
      Help me…