dbt_twitter_source 0.5.0

🎉 Feature Enhancements 🎉

PR #13 includes the following changes:

• Addition of the following staging models which pull from the source counterparts. The inclusion of the additional _report source tables is to generate a more accurate representation of the Twitter Ads data:

  • stg_twitter_ads__line_item_report
  • stg_twitter_ads__account_report
  • stg_twitter_ads__campaign_report
  • stg_twitter_ads__line_item_keywords_report: This can be disabled by setting the twitter_ads__using_keywords variable to False.
  • stg_twitter_ads__tweet

• Inclusion of passthrough metrics:

  • twitter_ads__line_item_report_passthrough_metrics
  • twitter_ads__campaign_report_passthrough_metrics
  • twitter_ads__line_item_keywords_report_passthrough_metrics
  • twitter_ads__promoted_tweet_report_passthrough_metrics

This applies to all passthrough columns within the dbt_twitter_source package and not just the twitter_ads__line_item_report_passthrough_metrics example.

vars:
  twitter_ads__line_item_report_passthrough_metrics:
    - name: "my_field_to_include" # Required: Name of the field within the source.
      alias: "field_alias" # Optional: If you wish to alias the field within the staging model.

• README updates for easier navigation and use of the package.
• Addition of identifier variables for each of the source tables to allow for further flexibility in source table direction within the dbt project.
• Addition of grain uniqueness tests for each staging table.