I am trying to import a bacpac to azure sql database it runs for almost 2.5 hours, I need to get the status of this import job i.e. in-progress, complete etc using python. I know I can do it using Get-AzSqlDatabaseImportExportStatus -OperationstatusLink in powershell, but I want to do this using python.
You can use Python's subprocess
module to run Powershell commands.
The subprocess module allows you to spawn new processes, connect to their input/output/error pipes, and obtain their return codes.
You can store the Powershell script in any file and then read that file using subprocess.Popen
method.
Example:
import subprocess, sys
p = subprocess.Popen(["powershell.exe",
"C:\\Project\\downloadSharePointFile.ps1"],
stdout=sys.stdout)
p.communicate()
Refer: Running Powershell script with Python, Executing PowerShell from Python