PR #156 includes the following updates:
Schema & Data Updates - Reddit Ads
17 total changes • 17 possible breaking changes
Data Models | Change Type | Old | New | Notes |
---|---|---|---|---|
ad_reporting__account_report ad_reporting__ad_group_report ad_reporting__ad_report ad_reporting__campaign_report ad_reporting__monthly_campaign_country_report ad_reporting__url_report reddit_ads__account_report reddit_ads__ad_group_report reddit_ads__ad_report reddit_ads__campaign_country_report reddit_ads__campaign_report reddit_ads__url_report stg_reddit_ads__account_report stg_reddit_ads__ad_group_report stg_reddit_ads__ad_report stg_reddit_ads__campaign_country_report stg_reddit_ads__campaign_report |
Column datatype | spend (INT ) |
spend (NUMERIC ) |
Updated the datatype of the spend field from INT to NUMERIC to preserve decimal precision and prevent rounding when converting to dollars. The type cast is applied in the Reddit Ads staging layer and propagates through to the transform layer. See the dbt_reddit_ads_source v0.7.0 release for more details. |
Under the Hood
- Updated conditions in
.github/workflows/auto-release.yml
. - Added
.github/workflows/generate-docs.yml
. - Migrated
flags
(e.g.,send_anonymous_usage_stats
,use_colors
) fromsample.profiles.yml
tointegration_tests/dbt_project.yml
. - Updated
maintainer_pull_request_template.md
with improved checklist. - Refreshed README tag block.
- Updated Python image version to
3.10.13
inpipeline.yml
. - Updated
.gitignore
to exclude additional DBT, Python, and system artifacts.
Full Changelog: v1.16.0...v1.17.0