Hi All I have few ` SQL` in my repo Is there any way to exec

Question

Hi All I have few ` SQL` in my repo Is there any way to execute those SQLs on Databrivks via Azure DevOps CO CD pipeline Please help I m very new to CI CD Thanks

Gerhard Brueckl · Answer

you can use the Databricks REST API to run them

Gerhard Brueckl · Answer

you can use the DatabricksPS Powershell Module and simply authenticate in the ADO pipeline <https github com gbrueckl Databricks API PowerShell azure devops integration> Then use the command and execution API to run your SQL code ``` task AzureCLI 2 displayName DatabricksPS Execute SQL inputs azureSubscription MyServiceConnection addSpnToEnvironment true scriptType ps scriptLocation inlineScript arguments $ DATABRICKS URL $ AzURE RESOURCE ID inlineScript | Set DatabricksEnvironment ApiRootUrl $1 AzureResourceID $2 UsingAzureDevOpsServiceConnection $ctx = Get DatabricksExecutionContext ClusterID 1202 211320 brick1 Language SQL $ctx | Start DatabricksCommand Command SELECT FROM myTable azurePowerShellVersion latestVersion```

Divyansh Jain · Answer

< Gerhard Brueckl> Thanks for your reply Could you please help like how can I pass multiple SQL Scripts instead of directly writing SQL query in YAML using DatabricksPS Powershell Module

Gerhard Brueckl · Answer

Simply use powershell to read the content into a variable and then use the variable instead of the static script If you have multiple files just create a loop