Feature/performance updates

[fivetran-catfritz]

PR Overview

This PR will address the following Issue/Feature:

• internal ticket
• also partially addresses https://github.com/fivetran/dbt_shopify/issues/65

This PR will result in the following new package version:

• v0.12.0 breaking change due to materialization changes.

Please provide the finalized CHANGELOG entry which details the relevant changes included in this PR:

🚨 Breaking Changes 🚨

• To reduce storage, updated default materialization of staging models to views.
  • Note that stg_shopify__metafield will still be materialized as a table for downstream use.

    ⚠️ Running a --full-refresh will be required if you have previously run these staging models as tables and get the following error:

    Trying to create view <model path> but it currently exists as a table. Either drop <model path> manually, or run dbt with `--full-refresh` and dbt will drop it for you.

    Under the Hood

• Updated the maintainer PR template to the current format.
• Added integration testing pipeline for Databricks SQL Warehouse.

PR Checklist

Basic Validation

Please acknowledge that you have successfully performed the following commands locally:

• [x] dbt run –full-refresh && dbt test
• [ ] ~dbt run (if incremental models are present) && dbt test~

Before marking this PR as "ready for review" the following have been applied:

• [x] The appropriate issue has been linked, tagged, and properly assigned
• [x] All necessary documentation and version upgrades have been applied
• [x] docs were regenerated (unless this PR does not include any code or yml updates)
• [x] BuildKite integration tests are passing
• [x] Detailed validation steps have been provided below

Detailed Validation

Please share any and all of your validation steps:

• Only materialization updates, no logic updates.

If you had to summarize this PR in an emoji, which would it be?

:dancer:

[fivetran-catfritz]

@fivetran-joemarkiewicz This is ready for re-review!