Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Feature] Allow for url report to include non url records #59

Closed
11 of 14 tasks
fivetran-joemarkiewicz opened this issue Sep 23, 2022 · 2 comments
Closed
11 of 14 tasks
Labels
type:enhancement New functionality or enhancement update_type:feature Primary focus is to add new functionality

Comments

@fivetran-joemarkiewicz
Copy link
Contributor

fivetran-joemarkiewicz commented Sep 23, 2022

Are you a current Fivetran customer?

Fivetran created PR.
What change(s) does this PR introduce?

  • For use in the dbt_ad_reporting package, users can now allow records having nulls in url fields to be included in the ad_reporting__url_report model.
  • Disabled the not_null test for ad_reporting__url_report when null urls are allowed

Did you update the CHANGELOG?

  • Yes

Does this PR introduce a breaking change?

  • Yes (please provide breaking change details below.)
  • No (please provide an explanation as to how the change is non-breaking below.)

Did you update the dbt_project.yml files with the version upgrade (please leverage standard semantic versioning)? (In both your main project and integration_tests)

  • Yes

Is this PR in response to a previously created Bug or Feature Request

  • Yes, Issue/Feature #59
  • No

How did you test the PR changes?

  • BuildKite
  • Local (please provide additional testing details below)

Select which warehouse(s) were used to test the PR

  • BigQuery
  • Redshift
  • Snowflake
  • Postgres
  • Databricks
  • Other (provide details below)

Provide an emoji that best describes your current mood

🍝

Feedback

We are so excited you decided to contribute to the Fivetran community dbt package! We continue to work to improve the packages and would greatly appreciate your feedback on our existing dbt packages or what you'd like to see next.

@fivetran-joemarkiewicz fivetran-joemarkiewicz added the enhancement New feature or request label Sep 23, 2022
@fivetran-joemarkiewicz
Copy link
Contributor Author

My idea for a solution would be to add a variable to the relevant code line within the respective platform transform package [platform]__url_report model.

-- Example from Google Ads
    -- We only want utm ads to populate this report. Therefore, we filter where url ads are populated.
    where ads.source_final_urls is not null

And include a variable that allows users across all packages to switch the filter off if they desire.

@fivetran-joemarkiewicz
Copy link
Contributor Author

Closing this Issue as the above PRs have been merged and address this feature.

@fivetran-joemarkiewicz fivetran-joemarkiewicz added type:enhancement New functionality or enhancement update_type:feature Primary focus is to add new functionality and removed enhancement New feature or request labels Jan 26, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type:enhancement New functionality or enhancement update_type:feature Primary focus is to add new functionality
Projects
None yet
Development

No branches or pull requests

1 participant