@Nermin Yehia​ looks there was a small confusion, thought sql files are data files. Ignore my previous comment. Did you get a chance to check below article which shows need to end to config for ADF to Databricks

https://learn.microsoft.com/en-us/azure/data-factory/solution-template-databricks-notebook

what ever path you add in ADF level pipeline config that will be picked, can you please make sure how config has been setted

learn.microsoft.com

Run a Databricks Notebook with the activity - Azure Data Factory

Learn how you can use the Databricks Notebook Activity in an Azure data factory to run a Databricks notebook against the databricks jobs cluster.