Unity Catalog Table/View Column Data Type Changes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-24-2023 12:24 PM
When changing a delta table column data type in Unity Catalog, we noticed a view that is referencing that table did not automatically update to reflect the new data type.
Is there a way to update the delta table column data type so that it also updates the view column data type at the same time? Or is there a way to refresh the view to reflect the new data type (apart from rerunning the "create or replace view" command)?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-24-2023 12:56 PM
Can you try refreshing the view by running the command: REFRESH TABLE <viewname>
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-24-2023 01:06 PM
Should have mentioned in the original post. I did try that after the table column was updated, but it returned an exception:

