Can we enable Lakehouse Schemas for an already existing Lakehouse?

[AyusmanBasu0604]

I found, that we cannot enable the "Lakehouse Schemas" option for an already existing Lakehouse unless we create a new one? is this true because When I try to create a Materialized Lake View it gives me a syntax error (PARSE_SYNTAX_ERROR] Syntax error at or near 'MATERIALIZED') whereas it works for a Lakehouse with Schema enabled.

What are the alternatives to the same?

[suparnababu8 · Accepted solution]

Hi @AyusmanBasu0604 

As per my understanding there is now aletrante solution for enabling the schema for existing lakehosue. You need to create new one with schema. We may expecte this feature in future as per Micrsoft Fabric Blog. 

Read more about blog here Organizing your tables with lakehouse schemas and more (Public Preview) | Microsoft Fabric Blog | Mi...

Please let me know if it helps you

Thank you!!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!