topic Re: Unity Catalog Table/View Column Data Type Changes in Data Engineering

Unity Catalog Table/View Column Data Type Changes

Eric_Kieft — Thu, 24 Aug 2023 19:24:40 GMT

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)?

Re: Unity Catalog Table/View Column Data Type Changes

Lakshay — Thu, 24 Aug 2023 19:56:55 GMT

Can you try refreshing the view by running the command: REFRESH TABLE <viewname>

Re: Unity Catalog Table/View Column Data Type Changes

Eric_Kieft — Thu, 24 Aug 2023 20:06:40 GMT

Should have mentioned in the original post. I did try that after the table column was updated, but it returned an exception: