1 Answer
- Newest
- Most votes
- Most comments
0
Redshift materialized views have limitation on late-binding references to objects. The auto mounted Glue catalog falls under this category and thus you are encountering the error. Even if the MV would have succeeded it cannot be auto refreshed and will go through a full refresh every time. So, instead of MV, you can create a regular table and built your refresh logic as necessary.
answered 3 months ago
Relevant content
- asked 12 days ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 6 months ago