Microsoft Fabric: Incremental ETL for Warehouse using Data Pipeline, SQL Procedure

No video

Microsoft Fabric: Incremental ETL for Warehouse using Data Pipeline, SQL Procedure

Рет қаралды 4,439

Amit Chandak Learn Microsoft Fabric, Power BI, SQL

Күн бұрын

Пікірлер: 12

@shafa7668 Жыл бұрын

By far the best series on Fabric on KZfaq. Currently I am consuming anything and everything available on Fabric on KZfaq . Your contents are the best. Keep up the good work.

@AmitChandak Жыл бұрын

Thanks a ton 🙏

@arthurvanrijn68 Жыл бұрын

Very nice. Thank you.

@AmitChandak Жыл бұрын

Thank you too! 🙏

@user-dy8xu7uj8k 2 ай бұрын

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.

@AmitChandak 2 ай бұрын

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

@user-lj9fk8dg9h 2 ай бұрын

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

@AmitChandak 2 ай бұрын

There is delete files activity. Not sure , I saw delete table. But we can call procedure and that can do that

@notoriousft Жыл бұрын

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?

@AmitChandak Жыл бұрын

For On-prem, I used only for SQL Server and that worked with Dataflow Gen 2 not with Data pipeline. Also over this weekend it was not working.

@supreetkaur5362 8 ай бұрын

I am trying to create table in fabric warehouse but seems like I have no access to create how to fix it.

@AmitChandak 8 ай бұрын

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