feature/performance-enhancement

[fivetran-catfritz]

PR Overview

This PR will address the following Issue/Feature:

• internal ticket

This PR will result in the following new package version:

• v0.7.0: breaking due to materialization changes requiring full refresh

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.

  ⚠️ 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:

• Included auto-releaser GitHub Actions workflow to automate future releases.
• Incorporated the new fivetran_utils.drop_schemas_automation macro into the end of each Buildkite integration test job.
• Updated the pull request templates.

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:

• These were only default materialization setting changes and under the hood changes.

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

:dancer: