create view via spark sql

I am trying to execute the following statement inside of a notebook %%sql CREATE VIEW data_lake.data_vault.table2_current AS SELECT * FROM data_lake.data_vault.table1 the statement terminates...

data engineering

Notebook

v-nmadadi-msft
1 year ago
Hi tareksalha ,
Thanks for reaching out to the Microsoft fabric community forum.

As you are using Lakehouse with schema enabled which is still in preview phase some of the features are not supported yet and one them is creation of views.
That is the reason for the error you are observing.
Reference for the above point: Lakehouse schemas (Preview) - Microsoft Fabric | Microsoft Learn

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards

v-nmadadi-msft

Community Support

1 year ago

Hi tareksalha ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Thank you