How to use Docker Sqitch with CI/CD?

[hrkachhia]

I want to use Docker Sqitch in my production environment. It is working fine on my machine. Now, I want to use Docker Sqitch on AWS. Do you have any ideas on how to achieve this? I have tried using AWS ECR, but it is not working. Can you please provide guidance?

[theory]

You can pull from Docker Hub from within AWS, no need for ECR.

[theory]

That error indicates that there is no Snowflake ODBC driver, which suggests that you're not actually creating the Snowflake image.

[hrkachhia]

Maybe this issue is occur because of I have built snowflake docker image on codebuild.
I have pushed working snowflake docker image from my Linux machine to AWS ECR and the after I have tried to use.
For connection to snowflake, I have declared all the require snowsql environment variables as below:

• SNOWSQL_ACCOUNT=snowflake account
• export SNOWSQL_USER=snowflake user
• export SQITCH_PASSWORD=my snowflake password
• export SNOWSQL_ROLE=Admin
• export SNOWSQL_WAREHOUSE=COMPUTE_WH

Now, I am getting error related to privileges when I tried to deploy from AWS codebuild.

003001 (42501): SQL access control error:
Insufficient privileges to operate on database 'test_db'
"snowsql" unexpectedly returned exit value 5

I am able to perform sqitch deploy ,verify and revert from my linux machine from same user and role but getting error only in AWS codebuild.

[theory]

Did you mean to export SNOWSQL_ACCOUNT?

[hrkachhia]

@theory : I have applied some changes in docker-switch.sh file. After those changes it is working fine with AWS ECR. I want to share those changes and contribute in this project. Can you please allow me to create pull request for it?

[theory]

You can fork the project and create a PR from there. Or just drop the patch here if you'd rather.