This PR will address the following Issue/Feature: [#104]
This PR will result in the following new package version: 1.4.2
**Please provide the finalized CHANGELOG entry which details the relevant changes included in this PR:**
Bug Fixes
Adjusted staging models stg_fivetran_platform__credits_used and stg_fivetran_platform__usage_cost to return empty tables if the respective fivetran_platform__credits_pricing and the fivetran_platform__usage_pricing variables for each model are disabled to avoid Postgres data type errors if those tables are null.
Under the Hood
Added additional scripts to run_models.sh for the package with the variables fivetran_platform__credits_pricing set to false and fivetran_platform__usage_pricing set to true to recreate the error.
Updated seed files to ensure downstream models properly populate into fivetran_platform__usage_mar_destination_history for validating this PR.
PR Checklist
Basic Validation
Please acknowledge that you have successfully performed the following commands locally:
[x] dbt run –full-refresh && dbt test
[NA] 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)
[ ] BuildKite integration tests are passing
[x] Detailed validation steps have been provided below
Detailed Validation
Please share any and all of your validation steps:
See Height ticket
If you had to summarize this PR in an emoji, which would it be?
PR Overview
This PR will address the following Issue/Feature: [#104]
This PR will result in the following new package version: 1.4.2
**Please provide the finalized CHANGELOG entry which details the relevant changes included in this PR:**Bug Fixes
stg_fivetran_platform__credits_used
andstg_fivetran_platform__usage_cost
to return empty tables if the respectivefivetran_platform__credits_pricing
and thefivetran_platform__usage_pricing
variables for each model are disabled to avoid Postgres data type errors if those tables are null.Under the Hood
run_models.sh
for the package with the variablesfivetran_platform__credits_pricing
set to false andfivetran_platform__usage_pricing
set to true to recreate the error.fivetran_platform__usage_mar_destination_history
for validating this PR.PR Checklist
Basic Validation
Please acknowledge that you have successfully performed the following commands locally:
Before marking this PR as "ready for review" the following have been applied:
Detailed Validation
Please share any and all of your validation steps: See Height ticket
If you had to summarize this PR in an emoji, which would it be?
💳