u/AdamMarczakIO

Hey folks,

Recently I've got an urge to write more on my blog, and so here is a small blog post about Data Factory parametrization that is applicable for both Azure Data Factory, but also Microsoft Fabric.

Blog contains end-2-end setup, a few screenshots, and a demo queries to set you up.

Feel free to check it out, hope you will find it useful. Let me know your thoughts.

Link: https://marczak.io/posts/2026/06/data-factory-parametrization-with-config-tables/

Adam

Hey guys,

I've decided to write a quick entry on this as it's too small subject to create a YT video on, but it's a question I often get so I thought I'd share it here too.

In this small entry you can find an approach which I like for my data factories, especially when there are many pipelines to manage.

It's nothing super complex or sophisticated, but it's a repeatable pattern that I like to use.

post link: https://marczak.io/posts/2026/06/data-factory-parametrization-with-config-tables/

TL;DR: Blog entry shows how to connect to Azure SQL, define metadata table, pull out the values in your pipelines, pivot them so they appear as JSON properties, and use as pipeline parameters.

Hope you will find it useful!