Forum Discussion

yongshao's avatar
yongshao
Helper III
2 years ago

Create SQL views with Fabric lakehouse SQL endpoint from Fabric notebook

Our ETL uses Fabric notebooks to extract/clean/transform big dataset into Fabric lakehouses We want to create/update SQL Views with a lakehouse SQL endpoint. The  SQL views could be created manually...
data engineering
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi yongshao ,

Thanks for using Fabric Community.

" Spark views won't show up in the SQL endpoint. It is the same behavior with Synapse Spark too. Views created in Synapse won't show up in Synapse serverless. "

The only option left is to create the views directly in the Lakehouse's SQL Analytics Endpoint.

Similar Threads -
Re: Can you read a Fabric lakehouse view from spar... - Microsoft Fabric Community
Solved: Re: Creating views from spark notebook into SQL an... - Microsoft Fabric Community

Hope this is helpful. Please do let me know incase of further queries.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi yongshao ,

    We haven’t heard from you on the last response and was just checking back to see if your query was answered.
    Otherwise, will respond back with the more details and we will try to help .

    Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi yongshao ,

      We haven’t heard from you on the last response and was just checking back to see if your query was answered.
      Otherwise, will respond back with the more details and we will try to help .

      Thanks