A common use case in a data platform is to expose a virtual layer towards consumers (e.g. think SQL views towards PBI).
When working in a lakehouse scenario with medallion data architecture, it is currently impossible to define views via T-sql endpoint on top of your lakehouse, where the views have to following criteria:
- Need to be source controlled
- Can be deployed to the next environment
Alternative solution considered:
- Create a warehouse item that creates a view on top of the final gold layer tables, but that warehouse cannot be deployed because of dacpac missing references to the lakehouse tables (which dont exist as lakehouses as deployed empty by default).
Would be good to be able to define source controlled T-SQL views on top of the lakehouse, which are included in the deployment pipeline by default.
I'm open to alternatives, but cannot find any elegant working solutions...
on:
REST API for removing all tags
nschachter
on:
Increase the REST API Limitation for tags
on:
Image upload in Power BI