This PR will result in the following new package version:
v0.2.1: non-breaking since this is a patch update for a casting issue, the resulting cast is the same as before, so we want this automatically installed for users using the suggested range.
Please provide the finalized CHANGELOG entry which details the relevant changes included in this PR:
Bug Fix
Updated model stg_qualtrics__survey_response to use a case statement to determine the is_finished boolean value instead of a straight cast to boolean.
This is necessary for warehouses that do not support the straight cast.
Under the Hood
Updated the integration tests seed survey_response to test both possible values for finished.
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.
[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:
Here is the relevant Qualtrics API doc explaining 1 = true.
Tested with seed data to ensure 0s and 1s converted to appropriate boolean.
See internal ticket as well.
If you had to summarize this PR in an emoji, which would it be?
PR Overview
This PR will address the following Issue/Feature:
This PR will result in the following new package version:
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:
Before marking this PR as "ready for review" the following have been applied:
Detailed Validation
Please share any and all of your validation steps:
If you had to summarize this PR in an emoji, which would it be?
🧀