Forum Discussion
Create SQL views with Fabric lakehouse SQL endpoint from Fabric notebook
yongshao have you found a decent solution for your problem?
We are experiencing similar issues.
We want to create views in the T-sql end point of the lakehouse as well, to expose data to downstream users.
But the views created in this T-sql endpoint are not in source control, which makes them impossible to deploy to the next environment.
What would be the solution?
Another option might be to create views in a warehouse, using the lakehouse tables as reference objects, which leads to issues when deploying the warehouse, because the corresponding lakehouse object reference does not exist (yet).
Currently, we don't find a suitable solution to have a view as the final layer exposed to end users, or to powerbi, which is decently source-controlled...
Please give us some advice anyone who has a working solution...