Hi @Anto Reni Huxley Antokinsley ,
Welcome to Microsoft Q&A! Thanks for posting the question.
Most of the PowerShell scripts which run locally on your machine using ISE/PowerShell will also run as Azure Automation runbook after making minor changes. Most of these changes are related to setting correct context, account, and connections to respective resource. Some of the tutorials available here are a good place to get started with Azure Automation.
I also created a sample runbook which is available here, which contains the scenarios described in the question. It simply reads some values from Azure SQL, then reads some related information from Azure table storage and finally uploads the read value to Azure blob. The comments in the runbook ( runbook.ps1
) and the associated help.md file should help you get started.
Please let me know if you have any questions.
---
Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.