add currency field

[fivetran-reneeli]

PR Overview

This PR will address the following Issue/Feature: Issue #48

Applying the changes from @asmundu's PR https://github.com/fivetran/dbt_google_ads/pull/36 to most recent version of our google ads package.

This PR will result in the following new package version: v0.9.2

This is adding a new field and does not affect downstream models, therefore will not be a breaking change.

Please detail what change(s) this PR introduces and any additional information that should be known during the review of this PR:

This PR adds the currency_code field to the following models: google_ads__ad_group_report.sql google_ads__ad_report.sql google_ads__campaign_report.sql google_ads__keyword_report.sql google_ads__url_report.sql

PR Checklist

Basic Validation

Please acknowledge that you have successfully performed the following commands locally:

• [X] dbt compile
• [X] dbt run –full-refresh
• [X] dbt run
• [X] dbt test
• [n/a] dbt run –vars (if applicable)

Before marking this PR as "ready for review" the following have been applied:

• [X] The appropriate issue has been linked and tagged
• [X] You are assigned to the corresponding issue and this PR
• [x] BuildKite integration tests are passing

Detailed Validation

Please acknowledge that the following validation checks have been performed prior to marking this PR as "ready for review":

• [X] You have validated these changes and assure this PR will address the respective Issue/Feature.
• [X] You are reasonably confident these changes will not impact any other components of this package or any dependent packages.
• [X] You have provided details below around the validation steps performed to gain confidence in these changes.

After running the models I now see currency_code as an added field. Example compiled code below:

Outputted models in target warehouse now have the additional field:

Standard Updates

Please acknowledge that your PR contains the following standard updates:

• Package versioning has been appropriately indexed in the following locations:
  • [X] indexed within dbt_project.yml
  • [X] indexed within integration_tests/dbt_project.yml
• [X] CHANGELOG has individual entries for each respective change in this PR
• [n/a] README updates have been applied (if applicable)
• [n/a] DECISIONLOG updates have been updated (if applicable)
• [x] Appropriate yml documentation has been added (if applicable)

dbt Docs

Please acknowledge that after the above were all completed the below were applied to your branch:

• [X] docs were regenerated (unless this PR does not include any code or yml updates)

If you had to summarize this PR in an emoji, which would it be?

🤑

[fivetran-joemarkiewicz]

Looks like BuildKite is passing!

[fivetran-reneeli]

awesome, thanks!