How to run Powershell file script.ps1 using the databricks notebook

sandeephenkel23 — Thu, 04 Jan 2024 06:00:56 GMT

Hello All,

Following command on running through databricks notebook is not working

Command

%sh

# Bash code to print 'Hello, PowerShell!'

echo 'Hello, PowerShell!'

# powershell.exe -ExecutionPolicy Restricted -File /dbfs:/FileStore/Read_Vault_Inventory.ps1

It;s throwing the following error:

output

Hello, PowerShell!

bash: line 3: powershell.exe: command not found

Kindly give some insights how to run the .ps1 file stored in dbfs file store or how to run the powershell commands through databricks notebook

topic How to run Powershell file script.ps1 using the databricks notebook in Data Engineering