title: Trigger a Python Tool via Azure automation
body: <p>I have a below scenario which I am currently doing manually:</p>
  <ol>
  <li><p>Install DBT tool (python) in my system :
  <a href="https://www.getdbt.com/" rel="nofollow noreferrer">https://www.getdbt.com/</a></p>
  </li>
  <li><p>Clone a repo in my system which contains the code that needs to be executed by the tool (DBT)</p>
  </li>
  <li><p>Trigger the tool via command line (CLI)
  <a href="https://docs.getdbt.com/reference/dbt-commands" rel="nofollow noreferrer">https://docs.getdbt.com/reference/dbt-commands</a></p>
  </li>
  </ol>
  <p>example : we have a command like dbt run -- model1</p>
  <p>Now I need to automate it in Upper environments and able to parameterise certain aspects like be able to execute commands based on parameters :
  dbt run -- &lt;&gt;</p>
  <p>Is it possible to install the python package, clone Git Repo and execute CLI commands at run time via Azure automation or having some powershell code via VM</p>
  <p>Note: we tried the below approach but unable to parameterise the queries</p>
  <p><a href="https://medium.com/hashmapinc/integrating-dbt-with-azure-data-factory-adf-3d7f66272433" rel="nofollow noreferrer">https://medium.com/hashmapinc/integrating-dbt-with-azure-data-factory-adf-3d7f66272433</a></p>