Skip to content

CHANGELOG.md

Latest commit

 

History

History
147 lines (116 loc) · 8.48 KB

CHANGELOG.md

File metadata and controls

147 lines (116 loc) · 8.48 KB
Raw

dbt_pardot v1.4.0

PR #32 includes the following updates:

Under the Hood

  • Migrates the union_connections, apply_source_relation, and partition_by_source_relation macros to the dbt_fivetran_utils package.
  • Adds the fivetran_using_source_casing variable for case-sensitive destination support. When enabled, downstream transformations respect source casing to ensure consistent results. See the Additional Configurations section of the README for details.

dbt_pardot v1.3.0

PR #29 includes the following updates:

Documentation

  • Updates README with standardized Fivetran formatting.

Under the Hood

  • In the quickstart.yml file:
    • Adds supported_vars for Quickstart UI customization.

dbt_pardot v1.2.1

PR #27 introduces the following update:

Bug Fix

  • Limits column introspection in pardot__campaigns (via the int__opportunity_tmp model) to execution time (i.e. during the dbt run and dbt build) to avoid errors during dbt compile.

Contributors

dbt_pardot v1.2.0

PR #26 includes the following updates:

Features

  • Increases the required dbt version upper limit to v3.0.0

dbt_pardot v1.1.0

PR #24 includes the following updates:

Schema/Data Change

2 total changes • 1 possible breaking change

Data Model(s) Change type Old New Notes
All models New column source_relation Identifies the source connection when using multiple Pardot connections
stg_pardot__opportunity_prospect Updated surrogate key opportunity_prospect_id = opportunity_id + prospect_id opportunity_prospect_id = source_relation + opportunity_id + prospect_id Updated to include source_relation

Feature Update

  • Union Data Functionality: This release supports running the package on multiple Pardot source connections. See the README for details on how to leverage this feature.

Tests Update

  • Removes uniqueness tests. The new unioning feature requires combination-of-column tests to consider the new source_relation column in addition to the existing primary key, but this is not supported across dbt versions.
    • Note that surrogate keys are unaffected and retain their uniqueness tests.
  • These tests will be reintroduced once a version-agnostic solution is available.

Under the Hood

  • Deprecated int__opportunities_by_campaign intermediate model. The logic has been consolidated directly into the pardot__campaigns end model as a CTE for improved performance and maintainability.

dbt_pardot v1.0.0

PR #20 includes the following updates:

Breaking Changes

Source Package Consolidation

  • Removed the dependency on the fivetran/pardot_source package.
    • All functionality from the source package has been merged into this transformation package for improved maintainability and clarity.
    • If you reference fivetran/pardot_source in your packages.yml, you must remove this dependency to avoid conflicts.
    • Any source overrides referencing the fivetran/pardot_source package will also need to be removed or updated to reference this package.
    • Update any pardot_source-scoped variables to be scoped to only under this package. See the README for how to configure the build schema of staging models.
  • As part of the consolidation, vars are no longer used to reference staging models, and only sources are represented by vars. Staging models are now referenced directly with ref() in downstream models.

dbt Fusion Compatibility Updates

  • Updated package to maintain compatibility with dbt-core versions both before and after v1.10.6, which introduced a breaking change to multi-argument test syntax (e.g., unique_combination_of_columns).
  • Temporarily removed unsupported tests to avoid errors and ensure smoother upgrades across different dbt-core versions. These tests will be reintroduced once a safe migration path is available.
    • Removed all dbt_utils.unique_combination_of_columns tests.
    • Removed all accepted_values tests.
    • Moved loaded_at_field: _fivetran_synced under the config: block in src_pardot.yml.

Under the Hood

  • Updated conditions in .github/workflows/auto-release.yml.
  • Added .github/workflows/generate-docs.yml.

Documentation

  • Added Quickstart model counts to README. (#18)
  • Corrected references to connectors and connections in the README. (#18)

dbt_pardot v0.6.0

🎉 Feature Update 🎉

  • Databricks compatibility! (#13)

🚘 Under the Hood 🚘

  • Incorporated the new fivetran_utils.drop_schemas_automation macro into the end of each Buildkite integration test job. (#11)
  • Updated the pull request templates. (#11)

dbt_pardot v0.5.0

PR #9 includes the following breaking changes:

🚨 Breaking Changes 🚨:

  • Dispatch update for dbt-utils to dbt-core cross-db macros migration. Specifically {{ dbt_utils.<macro> }} have been updated to {{ dbt.<macro> }} for the below macros:
    • any_value
    • bool_or
    • cast_bool_to_text
    • concat
    • date_trunc
    • dateadd
    • datediff
    • escape_single_quotes
    • except
    • hash
    • intersect
    • last_day
    • length
    • listagg
    • position
    • replace
    • right
    • safe_cast
    • split_part
    • string_literal
    • type_bigint
    • type_float
    • type_int
    • type_numeric
    • type_string
    • type_timestamp
    • array_append
    • array_concat
    • array_construct
  • For current_timestamp and current_timestamp_in_utc macros, the dispatch AND the macro names have been updated to the below, respectively:
    • dbt.current_timestamp_backcompat
    • dbt.current_timestamp_in_utc_backcompat
  • dbt_utils.surrogate_key has also been updated to dbt_utils.generate_surrogate_key. Since the method for creating surrogate keys differ, we suggest all users do a full-refresh for the most accurate data. For more information, please refer to dbt-utils release notes for this update.
  • Dependencies on fivetran/fivetran_utils have been upgraded, previously [">=0.3.0", "<0.4.0"] now [">=0.4.0", "<0.5.0"].

🎉 Documentation and Feature Updates 🎉:

  • Updated README documentation for easier navigation and dbt package setup.

dbt_pardot v0.4.0

🎉 dbt v1.0.0 Compatibility 🎉

🚨 Breaking Changes 🚨

  • Adjusts the require-dbt-version to now be within the range [">=1.0.0", "<2.0.0"]. Additionally, the package has been updated for dbt v1.0.0 compatibility. If you are using a dbt version <1.0.0, you will need to upgrade in order to leverage the latest version of the package.
    • For help upgrading your package, I recommend reviewing this GitHub repo's Release Notes on what changes have been implemented since your last upgrade.
    • For help upgrading your dbt project to dbt v1.0.0, I recommend reviewing dbt-labs upgrading to 1.0.0 docs for more details on what changes must be made.
  • Upgrades the package dependency to refer to the latest dbt_pardot_source. Additionally, the latest dbt_pardot_source package has a dependency on the latest dbt_fivetran_utils. Further, the latest dbt_fivetran_utils package also has a dependency on dbt_utils [">=0.8.0", "<0.9.0"].
    • Please note, if you are installing a version of dbt_utils in your packages.yml that is not in the range above then you will encounter a package dependency error.

dbt_pardot v0.1.0 -> v0.3.0

Refer to the relevant release notes on the Github repository for specific details for the previous releases. Thank you!