I need to generate a Calendar table - it is a very simple task for regular SQL but I'm using Microsoft Fabric and I've tried so far many options, however no success due to Fabric SQL limitations. &n...
I've setup a pipeline that pulls data from a lakehouse (with shortcuts to tables in another workspace) into a data-warehouse via two stored procedures. It succeeds when I run the pipline man...
I have been trying to add a DEFAULT constraint to a COLUMN. I saw at least one 2023 post stating to check SQL surface area that, as it read says that the ALTER TABLE is not supported, I added a...
Hi, since monday or tuesday i get the following warning for every table in all semantic models: Nothing has changed on the warehouse. I cannot find more. at first glance, e...
I am exploring fabric from data science point of view and was working on deploying sample project to test and prod stages. In my sample solution I have notebooks, data pipeline and lakehouse. When I ...
I've created an Azure Data Lake Storage gen2 connection from Fabric. Now, I want to configure ADLSg2 firewall to enable access only from Fabric. Which is the best practice to configure this access ru...
Using Microsoft Fabric - under the "Data Warehouse" experience. Worked on some queries and now I like to clean-up some queries... It turns out that is not possible Once a quer...
Hi Team - we have spark starter pool and would like to set custom executors and memory for each notebook. Is there way to do it. For Example, In Synpase, we have option to set executors & memory ...
I am currently trying to sync an exisiting azure devops git repository containing workspace items (lakehouses, notebooks, data pipelines), which we commited from an existing workspace to the repo, in...
Hi, I posted a question sometime ago and I am wondering if there is already any solution offered. I am loading some delta files using a notebook since that format is not offered on ...