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

darioromero 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.


Operating system used: linux AWS



  • Sarina
    Sarina Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer Posts: 315 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?


Setup Info
      Help me…