Bugfix/qdm

[fivetran-jamie]

PR Overview

This PR will address the following Issue/Feature: From our QDM Error analysis: solution_caused_error: constant expressions are not supported in partition by clauses

This PR will result in the following new package version:

v0.7.4

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

PR Checklist

Basic Validation

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

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

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

• [ ] 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:

Actually addresses issue I recreated the issue in Buildkite by adjusting the names of few history tables' identifier variables to point to non-existent tables (which union_data will create null versions of)

  facebook_ads_source:
    facebook_ads_account_history_identifier: "facebook_ads_account_history_data_WRONG_FOR_TESTING"
    facebook_ads_ad_history_identifier: "facebook_ads_ad_history_data"
    facebook_ads_ad_set_history_identifier: "facebook_ads_ad_set_history_data_WRONG_FOR_TESTING"
    facebook_ads_basic_ad_identifier: "facebook_ads_basic_ad_data"
    facebook_ads_campaign_history_identifier: "facebook_ads_campaign_history_data_WRONG_FOR_TESTING"
    facebook_ads_creative_history_identifier: "facebook_ads_creative_history_data"

Using my branch, Redshift now passes on Buildkite with this setup

Validate updates consistency tests added and passing