feat: Support multiple test cases

[marcellovictorino]

This is a:

• [ ] bug fix PR with no breaking changes
• [x] new functionality
• [ ] a breaking change

Description & motivation

Addressing this issue, enables to define a test once, to be applied over multiple test cases.

Applicable when there are multiple test case scenarios, where the mocked input and expected output data (seed) represent a single case, having the seed file names identified by test_case_1, test_case_2 etc.

Checklist

• [ ] I have verified that these changes work locally on the following warehouses (Note: it's okay if you do not have access to all warehouses, this helps us understand what has been covered)
  • [ ] BigQuery
  • [ ] Postgres
  • [ ] Redshift
  • [x] Snowflake
• [x] I have updated the README.md (if applicable)
• [ ] I have added tests & descriptions to my macros (and models if applicable) -> added descriptions. Not sure how to add tests

Additional comments

Splitting the original PR into two separate ones: this one focus on enabling multiple test cases within a single test definition

[marcellovictorino]

@mjirv as requested, splitting the original into separate PRs I will hold on the second PR, saving the mocked model output as view for improved error visibility, for later 👍 I will even create an issue for it

[marcellovictorino]

@mjirv bumping for visibility Thanks!

[mjirv]

@marcellovictorino thanks for bumping! I had missed that you updated this. Reviewing now!

[marcellovictorino]

@mjirv Thanks for the new review! It has been a busy week. But I am interested in applying the fixes and trying to create the end-to-end test. Might take a bit longer, but would be a learning opportunity for me, and hopefully easier for future contributions 😅 🎉 I will aim to complete this before the end of this week (4th November)

[mjirv]

@marcellovictorino awesome, let me know if you need anything!