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 ,

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