Share via

How to run Python script triggered through Azure Synapse Studio?

Kshitij Jaiswal 0 Reputation points
2023-12-01T14:29:11.1066667+00:00

I need to run python script over password protected excel files to transform them periodically. So I need to keep a dynamic path. The confidential data is currently on Azure Blob. I was thinking to move it to ADLS. Correct me if its right approach.

I would further need to open this password protected excel file with multiple sheets and transform data. I m unable to open these files using Azure Synapse Studio in a notebook. Is there any alternative approach or a work-around this issue? TIA

Azure Synapse Analytics
Azure Synapse Analytics

An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Amira Bedhiafi 42,936 Reputation points MVP Volunteer Moderator
    2023-12-01T15:02:15.7566667+00:00

    One workaround could involve using an external service or a custom script to first decrypt the Excel files and then upload them to a secure location (like a secure container in ADLS) where Synapse can access them.

    Once the Excel files are accessible, you can use Azure Synapse's notebook feature to write Python scripts for data transformation.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.