topic Re: Unable to create materialized view in Unity enabled Catalogues. in Data Engineering

Unable to create materialized view in Unity enabled Catalogues.

mickniz — Sat, 26 Nov 2022 13:49:25 GMT

Hi Team,

I was going through one of the videos of Databricks Sql Serverless and it say there is materialized view support . We can create materialized view .I tried same on my cluster of Sql Warehouse gives below error:

Re: Unable to create materialized view in Unity enabled Catalogues.

Anonymous — Sun, 27 Nov 2022 06:18:50 GMT

Hi @Ritu Kumari

Great to meet you, and thanks for your question!

Let's see if your peers in the community have an answer to your question first. Or else bricksters will get back to you soon.

Thanks

Re: Unable to create materialized view in Unity enabled Catalogues.

mickniz — Sun, 27 Nov 2022 14:35:42 GMT

I have Unity Catalog enabled in my Warehouse cluster. And my goal is to create materialized view. I am unable to create materialized view. Please suggest if we can create materialized view in Unity Catalog enabled cluster

Re: Unable to create materialized view in Unity enabled Catalogues.

Felix — Mon, 28 Nov 2022 10:35:52 GMT

Materialized views is in private preview right now afaik. Please talk to your account or customer success team at Databricks in order to sign up and enable it for your workspace. Thanks!