Functional tests

[jtcohen6]

Describe the feature

Convert "integration tests" project to use new functional testing paradigm, based on pytest: https://docs.getdbt.com/docs/contributing/adapter-development/4-testing-a-new-adapter#testing-your-adapter

Among other reasons, this would make it easier to:

• Run narrower, more modular tests
• Validate the syntax of create external table statements (by introspecting logs), even if we don't have the appropriate infrastructure set up to test every single feature
• Catch and validate the exceptions being raised

Describe alternatives you've considered

Leaving tests as they are

Additional context

Examples in other packages:

• Functional testing dbt-utils#588
• Adding Pytest Tests dbt_metrics#65

Who will this benefit?

Contributors & maintainers of this package