Data Engineering
NewColumn sort functionality does not work on Date column in lakehouse GUI
Alex Blake on 04 Nov 2024 21:29:37
The following issue affects both the lakehouse and its SQL Endpoint GUI.
ISSUE:
Given a DimDate table created with a DFg2, the Date columns in the DF contains dates all the way to 2025-12-31 (for example, as the DF param end date is set to this date). Sort the Date column in descending order and sure enough the last is there, correctly.
After running the DFg2 so that its output is loaded into a lakehouse table named DimDate, open the lakehouse, click on the table name and then use the GUI to sort the Date column in descending order. Make sure the scroll bar of the Y-axis of the viewport is pulled up all the way up.
Result: the first date shown is 2025-06-30 and not 2025-12-31 as should be the case. Same happens when you repeat these steps in the SQL Endpoint GUI.