PrerequisitesΒΆ
Jenkins Setup
- We need to have a Jenkins Server, which can schedule executors via docker.
Docker image for sqitch-snowflake
The executor used in this demonstration is a docker container which contains sqitch, snowflake odbc driver, and the snowsql client. Visit docker-sqitch on instructions on how to build the docker image. There might be some customizations required depending upon your Jenkins Setup. See Caveats.md.
Docker Image with tag
snowflake-devcan be used for similar use case. Docker Image with tagsnowflakeis the as it is image after building from docker-sqitch for snowflake with default Dockerfile
Git Client
- We will also need the git client for communicating with github
Snowflake account
- If you do not have a snowflake account, You can sign up for one by visiting Snowflake Free Trial This will get you 30 days of free trial worth $400