Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-11-2025 02:17 AM
OUR FIX
Eventually we learned via DESCRIBE EXTENDED, that the table had lost its Location path in production environment. Querying via the development environment to the production catalog the location path was still visible.
Solved the issue (with the right Manage rights on the materialized views) by deletion of the views from bronze, silver to gold and refreshed the DLT again. After that the location path of the table was visible in PRD as well. I have not found the rootcause of the corrupted locationpath for this specific table in our PRD environment.