Forum Discussion
Passing view creation queries through git
- Anonymous2 years ago
HI PedroCSeq,
Here is the list of items that support with git integrations, you can check it if helps:
Overview of Fabric Git integration - Microsoft Fabric | Microsoft Learn
Perhaps you can try to use 'attach it to the default semantic model' option and this will attached view to the lakehouse default semantic model as table. After these steps, you can simply use this in your worksapce.
Regards,
Xiaoxin Sheng
- 2 years ago
, the views you create for a Lakehouse uses Spark SQL so they won't show up in the SQL endpoint. Only the Delta tables will like you mentioned in your workaround.
If you really want T-SQL views, you will have to create a Data Warehouse and create views in there using T-SQL that query your Delta Tables. Like in the below example:
HI PedroCSeq,
Here is the list of items that support with git integrations, you can check it if helps:
Overview of Fabric Git integration - Microsoft Fabric | Microsoft Learn
Perhaps you can try to use 'attach it to the default semantic model' option and this will attached view to the lakehouse default semantic model as table. After these steps, you can simply use this in your worksapce.
Regards,
Xiaoxin Sheng