Can SnowDDL CLI accept placeholder variable values? #5
minghungcho
started this conversation in
Ideas
Replies: 1 comment
-
Please check the latest version
A few extra notes:
|
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
ex. In my view, I would reference an object in a different database. SELECT * FROM ${{sales_db}}.dbo.revenue. And define sales_db in placeholder.yaml.
However, this value is different for different release pipeline. Ex. there is only non-production and product database of sales_db. so I want to reference sales_db_noprod for all non-production uses (my_db_dev, my_db_qa), but reference sales_db from production databsae (my_db_prod).
With current SnowDDL, I need to write a python code to update placeholder.yaml based on my current pipeline before invoking SnowDDL CLI. If there is an option similar to --vars in schemachage, I can dynamically substitute placeholder values. This is specially useful when invoking SnowDDL as part of Azure DevOp when environment variables are defined in Azure Release Pipeline
SNOWDDL --placeholder {"sales_db": "sales_db_noprod", "wh_size":"large", "bucket_name": "$aws_s3_uri"}
Beta Was this translation helpful? Give feedback.
All reactions