By far the best series on Fabric on RU-vid. Currently I am consuming anything and everything available on Fabric on RU-vid . Your contents are the best. Keep up the good work.
Hi Amit, Good Morning!, I have to convert the existing SQL server stored procedure into fabric environment, In my stored procedures there are CURSOR commands but fabric doesn't support CURSOR commands, in this case how do I proceed, is there any alternative.
I have tried something very similar, TSQL loops learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-loops Search for Azure Synapse solution without using cursor
Hello sir, I wanted to ask that:- How can we delete a table residing in Fabric warehouse from Pipeline. It allows to delete from a Lakehouse, but not from warehouse. Can you please assist here
If you don't have admin privileges in the Workspace, it's important to note that an admin can set restrictions, limiting your ability to either read or read data. This could be why you're unable to create a table. Additionally, ensure that you're working with the warehouse, not just the SQL endpoint of the Lakehouse, as this can also affect your access and capabilities. Hope this helps clarify things! If you have further questions, feel free to ask
How did you create on-prem Postgres connection? Cause currently data pipelines in Fabric don't let you connect via on prem data gateways. Are you using some cloud hosted version such as elephantsql?