Its great that Fabric gives us many ways to write delta-parquet files, but for meta data and logging we really need a different storage. One that has super low latency and optimised for small non-analytical queries.
Ideally, what we need here is to be able to create a Fabric "SQLDB" and link or replicate it into a warehouse or Lakehouse
This would let us store some data in a row store but also query it from Fabric in conjunction with Fabric tables.
The killer use case here is meta data often which is the heart of any ETL automation solution.
2 Comments
- fbcideas_migusrNew MemberStatus added:New
- sukkaurMicrosoft EmployeeStatus changed:NewtoCompleted
SQL database in Fabric ia avaiable in Fabric as GA now.
Recent ideas
Semantic model connection bindings should be in source control (Git)
Semantic model data source connection bindings should be source controlled. A semantic model can contain multiple data source references, each of which can be mapped to a separate Fabric data connec...frithjof_v5 hours agoCommunity ChampionNew10Views1like0CommentsBulk changing column names in Visualizations Pane
We often use raw/api column names or measures with a set nomenclature to be consistent and to keep track of them but we do not want to display these names in the visuals. Currently we have to change ...vishal1401979 hours agoFrequent VisitorNew5Views0likes0CommentsAbout "Download SQL database project" and fix the downloaded project
1. The sqlproj must be fixed, it is downloaded without the xml markup line <?xml version="1.0" encoding="utf-8"> 2. The sdk must be updated: Actual: <Sdk Name="Microsoft.Build.Sql" Version="0.1...Jarrinf18 hours agoFrequent VisitorNew48Views3likes2Comments