Forum Discussion
Can we create views in Lakehouse's SQL Endpoint using Fabric Apis?
Anonymous The challenge with using the pysparks session to create a Lakehouse View is teh views doesn't show up in the UI -> see Creating views from spark notebook into SQL analytics endpoint?
frithjof_v I am trying to build utilities to deploy a fabric workspaces using FabricApis. The intention is to setup Automated CD process for the fabric to promote code that fits into our org's requirements.
Part of that is to figure out how to create Lakehouse views. I could get the connection string from the UI and I assumed ODBC would work. However there are no APIs to get the connection string of the Lakehouse's SQL analytics endpoint.
let me know if there are any further questions on this.
Have you tried the Lakehouse API?
https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-api
It seems you can use Create to create a Lakehouse, and then Get Properties to get the SQL Analytics Endpoint connection string.