PR #42 includes the following update:

Documentation

• Removes dynamic count_visitors_* columns from the pendo__guide and pendo__guide_daily_metrics models in pendo.yml to prevent persist_docs errors when these columns are not present.

Full Changelog: v1.3.0...v1.3.1

PR #41 includes the following updates:

Documentation

• Updates README with standardized Fivetran formatting.

Under the Hood

• In the quickstart.yml file:
  • Adds table_variables for relevant sources to prevent missing sources from blocking downstream Quickstart models.
  • Adds supported_vars for Quickstart UI customization.

Full Changelog: v1.2.0...v1.3.0

PR #40 includes the following updates:

Features

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

Full Changelog: v1.1.0...v1.2.0

Schema/Data Change

6 total changes • 5 possible breaking changes

Feature Update

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

Tests Update

• Removes most 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.
• These tests will be reintroduced once a version-agnostic solution is available.

We have retained tests on the surrogate keys listed above.

Under the Hood

• Updates source configs for the group table aimed at avoiding reserved-keyword errors.

Full Changelog: v1.0.0...v1.1.0

PR #34 includes the following updates:

Breaking Changes

Source Package Consolidation

• Removed the dependency on the fivetran/pendo_source package.
  • All functionality from the source package has been merged into this transformation package for improved maintainability and clarity.
  • If you reference fivetran/pendo_source in your packages.yml, you must remove this dependency to avoid conflicts.
  • Any source overrides referencing the fivetran/pendo_source package will also need to be removed or updated to reference this package.
  • Update any pendo_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.
  • Moved loaded_at_field: _fivetran_synced under the config: block in src_pendo.yml.

Under the Hood

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

Full Changelog: v0.6.0...v1.0.0

PR #30 includes the following updates:

Breaking Change for dbt Core < 1.9.6

Note: This is not relevant to Fivetran Quickstart users.

Migrated freshness from a top-level source property to a source config in alignment with recent updates from dbt Core (Pendo Source v0.6.0). This will resolve the following deprecation warning that users running dbt >= 1.9.6 may have received:

[WARNING]: Deprecated functionality
Found `freshness` as a top-level property of `pendo` in file
`models/src_pendo.yml`. The `freshness` top-level property should be moved
into the `config` of `pendo`.

IMPORTANT: Users running dbt Core < 1.9.6 will not be able to utilize freshness tests in this release or any subsequent releases, as older versions of dbt will not recognize freshness as a source config and therefore not run the tests.

If you are using dbt Core < 1.9.6 and want to continue running Pendo freshness tests, please elect one of the following options:

1. (Recommended) Upgrade to dbt Core >= 1.9.6
2. Do not upgrade your installed version of the pendo package. Pin your dependency on v0.5.0 in your packages.yml file.
3. Utilize a dbt override to overwrite the package's pendo source and apply freshness via the previous release top-level property route. This will require you to copy and paste the entirety of the previous release src_pendo.yml file and add an overrides: pendo_source property.

Under the Hood:

• Incorporated the new fivetran_utils.drop_schemas_automation macro into the end of each Buildkite integration test job.
• Updated the pull request templates.
• Updates to ensure integration tests use latest version of dbt.

Documentation

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

Full Changelog: v0.5.0...v0.6.0

PR #21 includes the following updates:

🚨 Breaking Changes 🚨:

• This is a breaking change due to changes made in the source package. (See Source CHANGELOG).

• Due to changes made in this release and v0.4.0, _fivetran_id has been added to the following models:
  - pendo__feature_event
  - pendo__guide_event
  - pendo__page_event

• _fivetran_id has also been added to the hashing formula used in the following fields:

  • feature_event_key in pendo__feature_event
  • guide_event_key in pendo__guide_event
  • page_event_key in pendo__page_event

✨ Features

• Updated documentation for new _fivetran_id field.
• Updated documentation and packages to reference the latest version of the source package.

Full Changelog: v0.4.0...v0.5.0

This release of dbt_pendo includes:

🚨 Breaking Changes:

• This is a breaking change due to changes made in the source package. (See Source CHANGELOG).

✨ Features

• Updated documentation and packages to reference the latest version of the source package. (#20)
• Revised readme instructions for successfully setting up the GROUP table with Snowflake. (#20

This release of the dbt_pendo package includes the following updates:

Bug Fixes

• Updated readme for workaround if the pendo_<default_source_table_name>_identifer is having trouble with Snowflake reserved words. (#19)

Full Changelog: v0.3.0...v0.3.1

PR #17 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"].
• Incremental strategy within the int_pendo__calendar_spine model has been adjusted to use the delete+insert strategy for Postgres and Redshift adapters.

🎉 Documentation and Feature Updates 🎉:

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