Can I run sql script files located in a git repo in Azure Data Factory?

Justin Thobela 22 Reputation points

I have a requirement to execute SQL script files that are either version controlled in a git repo OR versioned within Azure Data Factory itself. I have seen example pipelines online about executing files on ADF that are sitting in Azure Blob Storage, but we dont have version controlling in there and there is no interest in introducing LakeFS, I would rather execute files sitting in a git repo (Or the script files that are stored within Azure Data Factory itself) using ADF pipelines.

Can someone please tell me if this is possible?

Thank you lots in advance.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,129 questions
{count} votes