feature/performance-improvements

[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.10.0 breaking for materialization changes

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

🚨 Breaking Changes 🚨

• Added column _fivetran_synced_date to model stg_netsuite2__transactions for use in downstream models.
• 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:

• Added integration testing pipeline for Databricks SQL Warehouse.
• Included auto-releaser GitHub Actions workflow to automate future releases.

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)~

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
• [ ] ~docs were regenerated (unless this PR does not include any code or yml updates)~
  • will regenerate docs in the release branch to avoid merge conflicts
• [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:

• Updating materializations - no validation necessary.