Set up automated integration testing about dbt-expectations HOT 5 CLOSED

I would like to work on this!

from dbt-expectations.

Hi @makotonium ! I haven't made much any progress here, since it hasn't been a blocker for development (yet). So far, I'm testing against my own BigQuery and Snowflake instances (in addition to a local postgres instance) which hasn't incurred any costs yet. I think your other note on documentation updates is probably much more impactful to the broader package user community, so if you had to chose a project, that's the one I'd direct the most energy to! :)

from dbt-expectations.

Hey, github explorer & dbt fan here.

I know what Dylan Baker over at Spectacles did was for bigquery column / schema tests was to run queries with limit 0 appended. Basically, the query would succeed but return no data.

I think this could be used for your schema expectation tests without incurring charges?

from dbt-expectations.

Hi @sgoley, interesting! I think in our case though, we need all the data to come back from both the test model as well as the test output, so I'm not super sure where we'd inject the limit 0? Btw, on BigQuery, limit n has no effect on cost.

from dbt-expectations.

@clausherther I am curious to see how this is coming, and I may be able to offer help on getting something set up. How are you currently testing locally? Maybe we could replicate that as a start on GitHub Actions.

from dbt-expectations.