Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Unable to read a table with invalid dates using SQL endpoint

Hi There, We have some source system which treat NULL values as '0001-01-01' and some dates are before '1900-01-01'. When we try to read such data written using lakehouse notebook via SQL endpoint, ...
data warehouse
Warehouse
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

Thanks for using Fabric Community.
At this time, we are reaching out to the internal team to get some help on this .
We will update you once we hear back from them.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

Apologize for the issue you are facing. We can confirm that we are also observing the same issue at our end.

The best course of action is to open a support ticket and have our support team take a closer look at it.

 

Please reach out to our support team so they can do a more thorough investigation on why this it is happening: Link 

 

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

 

Hope this helps. Please let us know if you have any other queries.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

     

    We haven’t heard from you on the last response and was just checking back to see if you got a chance to open a support ticket.
    After creating a Support ticket please provide the ticket number as it would help us to track for more information.

    Thanks