Does anyone has "Best Practice" to share for Unit/Integration/Regression testing with Snowflake?

Question

We are embarking in a project using both Matillion and Snowflake and want to put in place some Unit/Integration/Regression testing.

Automated would be brilliant but manual would be good too.

We could invent something (simple) ourselves... but it would be better to benefit from other people experience.

Answer 1

Indeed there is a lack of possibility to unit/integration testing your models within Matillion. You need some external tools to implement these - we were using a Spring Boot Microservice with the following steps:

1. Setup the Testdata with some Plain SQL scripts via JDBC connection to the underlying Database
2. Run the correspondig job via the Matillion REST API
3. Using JUnit to make assertion and verify the outcome