How to run Python Scripts on ADF with input from Storage account. - Microsoft Q&A (2024)

Hi @RaiArveen ,

If I understand your ask correctly, you want run a python code which takes file from storage account loads that data to Azure SQL Database. If yes, below is the answer. If no, please help me with understating of your ask better with detailed example may be.

Step1: Create a python code locally which copies input file from storage account and loads it to Azure SQL database.
Step2: Test the python code locally. Save python code as .py file
Step3: Upload .py file to Azure Storage account.
Step4: Use Custom activity, which in turn uses Azure batch services to take the python code from .py file on storage and run it.

Click here to know step by step approach of doing same.

Hope this will help. Please let us know if any further queries.

-------------

Please consider hitting Accept Answer. Accepted answers helps community as well.

How to run Python Scripts on ADF with input from Storage account. - Microsoft Q&A (2024)
Top Articles
Latest Posts
Article information

Author: Corie Satterfield

Last Updated:

Views: 5928

Rating: 4.1 / 5 (62 voted)

Reviews: 93% of readers found this page helpful

Author information

Name: Corie Satterfield

Birthday: 1992-08-19

Address: 850 Benjamin Bridge, Dickinsonchester, CO 68572-0542

Phone: +26813599986666

Job: Sales Manager

Hobby: Table tennis, Soapmaking, Flower arranging, amateur radio, Rock climbing, scrapbook, Horseback riding

Introduction: My name is Corie Satterfield, I am a fancy, perfect, spotless, quaint, fantastic, funny, lucky person who loves writing and wants to share my knowledge and understanding with you.