Forum Discussion

ArtecX's avatar
ArtecX
Frequent Visitor
2 years ago

Problem with date colum when staging

Have anyone else had problem with date colum when using staging mode on Dataflow Gen 2? My dataflow have started getting error "the type of column 'date' doesn't match the type of the column in the ...
Dataflows
ArtecX's avatar
ArtecX
Frequent Visitor
2 years ago

Maybe i wasnt precise enough.

 

Im not using the system staging table for anything i just checked it out in Azure Data studio to troubleshoot the issue.

 

I have a dataflow gen 2 . where i have 9 queries. I have a Fabric Datawarehouse wich is the destination for the queries. «This is a self created Fabric Datawarehouse»

 

I have 2 queries that has staging enabled

 

There is a bug with the system artifact so the dataflow gen 2 staging table(System artifact staging table, from the staginglakehouse hidden from workspace) have somehow staged my date colum as date/time instead of date , so when i try to run the querie and it tries to stage it says the collum in the destination(StagingLakehouse) is a diffrent type.


miguel's avatar
miguel
Community Admin
2 years ago

Do you think that you could share some repro steps so that we could test the scenario on our end? If you could share any sample code that you're using and we could replicate on our end that would help tremendously