@Shashwat Tiwary Welcome to Microsoft Q&A Forum, Thank you for the question.
I'd recommend posting your question in https://developercommunity.visualstudio.com/spaces/21/index.html , it would the better medium to get better help since the issue doesn't seem to be Azure Data Lake Storage but the devops integration with it.
However, let me share some insights on your query.
To create a DevOps pipeline to migrate and deploy your code from Dev to Test and then to Prod environments with approval gates. Here are the high-level steps you can follow:
Create a new Azure DevOps project and repository to store your code.
Create a new pipeline in Azure DevOps to build and deploy your code.
Configure the pipeline to use the appropriate service connections for each of your resources (ADLS, ADF, Azure Databricks, Logic App, Function App, and MySQL).
Set up the pipeline to deploy to the Dev environment first, using the appropriate deployment tasks for each resource.
Once the Dev deployment is successful, set up a release gate to require approval before deploying to the Test environment.
Once the Test deployment is successful and approved, set up another release gate to require approval before deploying to the Prod environment.
You can use Azure DevOps' built-in release gates feature to require manual approval before deploying to higher environments. You can also use Azure DevOps' built-in deployment tasks for each of your resources, or you can create custom deployment tasks if needed.
Make sure to test your pipeline thoroughly in your Dev environment before deploying to higher environments. Also, ensure that you have appropriate access and permissions to all the resources in each environment.
Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.