Sqitch docker for multiple environments like production, test etc

[hrkachhia]

Hello,

I am using Sqitch docker image and trying to learn and create proper project structure to manage snowflake database changes.
I wants to create project structure such a way that allow me to deploy in multiple database environments like production, test etc,

Can you please guide me for the creation stamens to allow for deployments to multiple database environments?

I have read about the sqitch templates but I haven't found any proper tutorial for beginner.

Could you please guide me how to implement this with sqitch docker image? See below reference reference database structure

[hrkachhia]

Could you please help how to manage multiple schema in single sqitch project and how manage both using arguments with deploy

[theory]

Presumably your test and production environments are different databases. Just use separate target URLs for them. Something like:

sqitch target add prod db:snowflake://xxx@yyy.us-east-1/prd_database?Driver=Snowflake;warehouse=compute_wh
sqitch target add test db:snowflake://xxx@yyy.us-east-1/tst_database?Driver=Snowflake;warehouse=compute_wh

Then when you deploy, use the appropriate target:

sqitch deploy test