Forum Discussion

_maclura_'s avatar
_maclura_
Frequent Visitor
1 year ago
Solved

Data discrepancy between lakehouse view and SQL endpoint view

Hi, I have a delta table in a lakehouse. This table contains several Date columns. If I preview the table content from the lakehouse, this is what I see for some Date columns If I preview th...
data engineering
Lakehouse
  • _maclura_'s avatar
    _maclura_
    1 year ago

    OK, here the (not a) solution.
    I opened a ticket to Microsoft for this.
    It seems to be a known issue that is already in progress for a fix.
    This issue only affects the cell value rendering in the Fabric UI and not the actual content of the cell.
    Affected datatypes are "Date" and "Timestamp".

    Looking forward for a fix.
    😉

_maclura_'s avatar
_maclura_
Frequent Visitor
1 year ago

Thank you v-sathmakuri for taking the time to dig into this issue.
Unfortunately your suggested workaround is not an option for my needs: I need a "date" datatype and not a string.
By the way, I also noticed that in all other deltatables where I have a "Timestamp" datatype column, all the values are truncated in the datalake preview, and all you see is the portion hh:mm:ss.
My point is: if I have an "Apple" datatype, I should see an "Apple" whatever is the point of view I look at it. And not seeing an "Apple" from one point of view and an "Orange" from another. Right?