date column in MSSQL Server showing up as integer in DKU DSS

Dario
Dario Registered Posts: 9 ✭✭✭✭

I've loaded data into an S3 bucket from a table in MSSQL Server. The data looks great on S3 and the columns of data type <date> are 'date' on S3. Same happens on Athena reading the table on S3. But when I ingest the data on DKU DSS the column 'date' is an integer. I don't know how to fixed the mapping. I attempted changing the schema and data type within DSS but nothing resolve this.

Have you seen this before.

Thanks


Operating system used: linux AWS

Tagged:

Answers

  • Sarina
    Sarina Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 317 Dataiker

    Hi @darioromero
    ,

    If I understand correctly, you have a flow that goes from SQL Server -> S3. In the output dataset, the 'date' fields are shown as date fields as expected, but in the input dataset they appear as integer columns? Can you clarify what format your input date fields are in?

    And have you tried checking the following options in the Settings of the input dataset?

    Screenshot 2023-05-16 at 1.49.03 PM.png

    If that doesn't help, can you attach a screenshot of the issue with the MS SQL Server dataset?

    Thanks!
    Sarina 

Setup Info
    Tags
      Help me…