Forum Discussion

tareksalha's avatar
tareksalha
Frequent Visitor
1 year ago
Solved

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's avatar
    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's avatar
v-nmadadi-msft
Community Support
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's avatar
v-nmadadi-msft
Community Support
1 year ago

Hi tareksalha,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If our responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.


Thank you.