topic Re: Delta Live Tables Materialised View Column Comment Error in Data Engineering

Delta Live Tables Materialised View Column Comment Error

bozhu — Tue, 22 Aug 2023 11:04:51 GMT

While materialised view doc says MVs support columns comments, this does not seem like the case for MVs created by DLT. For example, when trying to add a comment to a MV created by DLT, it errors:

Any ideas on when this will be fixed/supported?

Re: Delta Live Tables Materialised View Column Comment Error

bozhu — Mon, 18 Sep 2023 04:25:25 GMT

Just to close the loop here that it seems DLT generated MVs now support column comments.

Re: Delta Live Tables Materialised View Column Comment Error

bozhu — Mon, 18 Sep 2023 04:34:19 GMT

But it seems like you can only update column comment in the Unity Catalog UI, not via any SQL stataments?

Re: Delta Live Tables Materialised View Column Comment Error

SamAdams — Thu, 18 Apr 2024 22:07:18 GMT

@bozhu confirmed, running into the same limitation still