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

darioromero
Level 2
date column in MSSQL Server showing up as integer in DKU DSS

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

0 Kudos
1 Reply
SarinaS
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โ€ƒ

โ€ƒ

โ€ƒ

0 Kudos