Forum Discussion

tegrus-coutinho's avatar
tegrus-coutinho
Frequent Visitor
2 years ago
Solved

Data Display Issue in Warehouse

I'm encountering an issue with data display in my table in the Warehouse. I perform daily incremental loads to this table. However, I noticed that the load from the day before yesterday seems to be m...
data engineering
data warehouse
  • Joshrodgers123's avatar
    Joshrodgers123
    2 years ago

    I have seen the same thing. Support told me there is a sync issue between the delta logs in the lakehouse and the sql endpoint. I have many instances where the sql endpoint does not update and shows an older version of the delta tables. They said the only way to fix it is to manually rename the delta table and rename it back.

fabricator1's avatar
fabricator1
Icon for Advocate II rankAdvocate II
2 years ago

Do you mean Data Warehouse or the SQL Analytics Endpoint in the Lakehouse?

Did you try accessing the data in Data Warehouse and SQL Analytics Endpoint and Power BI, and see if it is the same situation everywhere or if it is only missing in the Data Warehouse?

  • tegrus-coutinho's avatar
    tegrus-coutinho
    Frequent Visitor
    2 years ago

    In both SQL Endpoint and Power BI, the data is not appearing. I was only able to see the .parquet file within the Lakehouse.

    • frithjof_v's avatar
      frithjof_v
      Icon for Community Champion rankCommunity Champion
      2 years ago

      I guess I would try to look in the Delta log files.