I have created azure pipeline(CI) via yml file that executes DBT core models/macros in given sequences.
I want to declare variable that will hold value returnd by DBT MACRO
I have tried so far below :
<code>variables:
- script: |
$dbtMacroOutput := $(dbt run-operation myDbtMacro) # Capture the actual output
Write-Host "##vso[task.setvariable variable=dbtMacroResult]$dbtMacroOutput"
echo "The dbt macro result is $(dbtMacroOutput)"
displayName: Use dbtMacroOutput dbtMacroOutput: '' # Initialize with an empty string
</code>
<code>variables:
- script: |
$dbtMacroOutput := $(dbt run-operation myDbtMacro) # Capture the actual output
Write-Host "##vso[task.setvariable variable=dbtMacroResult]$dbtMacroOutput"
echo "The dbt macro result is $(dbtMacroOutput)"
displayName: Use dbtMacroOutput dbtMacroOutput: '' # Initialize with an empty string
</code>
variables:
- script: |
$dbtMacroOutput := $(dbt run-operation myDbtMacro) # Capture the actual output
Write-Host "##vso[task.setvariable variable=dbtMacroResult]$dbtMacroOutput"
echo "The dbt macro result is $(dbtMacroOutput)"
displayName: Use dbtMacroOutput dbtMacroOutput: '' # Initialize with an empty string
But while execution, I get no message := command not found
Can anyone suggest is it possible to achieve