DDL/DML Script automation

[TEST_USER_1212]

Hi,

could you please help me with finding out a solution, how I could automate DDL/DML operations in Microsoft Fabric? Is there some connector that I could use to connect to DDL/Data Model builder and execute said DDLs inside Fabric DWH environment? I didn't even find a way to use Fabric's API, that would allow me to automatically deploy DDL scripts from a external builder - would that be possible? 

Basically I'm just trying to find a way to deploy create scripts and stored procedures inside Fabric DWH from an external data modeler and I would verry much apprecitate, if somebody could point me to the right direction, how to connect those 2 worlds, if possible.

Thanks a lot!

[GilbertQ · Accepted solution]

Hi @TEST_USER_1212 

I don't think it is possible at the moment to do DDLscript deployments into the fabric service you can. have a look at the source code options (As it stands right now I do not think Data warehouses are supported)

Overview of Fabric Git integration - Microsoft Fabric | Microsoft Learn

[TEST_USER_1212]

Ok, thanks a lot for confirming my fears 🙂 We will see, when it becomes available..