v0.6.0 dbt_pendo_source

PR #29 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. 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 Source 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_source 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.

Documentation

• Corrected references to connectors and connections in the README. (#27)

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.

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

v0.5.0 dbt_pendo_source

PR #21 includes the following updates:

🚨 Breaking Changes 🚨:

• Updated the following models to include the new _fivetran_id field, which was recently added per the Fivetran Pendo Connector's March 2023 release notes:
  - stg_pendo__guide_event
  - stg_pendo__poll_event
  - stg_pendo__event
• _fivetran_id has also been added to the hashing formula used in the following fields:
  • event_key in stg_pendo__guide_event
  • guide_event_key in stg_pendo__poll_event
  • poll_event_key in stg_pendo__event
• These breaking changes persist to the transform package. (See the Transform CHANGELOG for more details.)

Features

• Updated documentation for new _fivetran_id field.

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

v0.4.0 dbt_pendo_source

This release of dbt_pendo_source includes:

🚨 Breaking Changes 🚨:

🔧 Bug Fixes

• Updated models stg_pendo__feature_event and stg_pendo__page_event to include _fivetran_id, which was recently added per the Fivetran Pendo Connector's release notes. (#19)

✨ Features

• Update documentation for _fivetran_id. (#19)
• Revised source yml and readme instructions for setting up the GROUP table with Snowflake. (#19)

v0.3.1 dbt_pendo_source

This release of the dbt_pendo_source 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. (#17)

Under the Hood

• Small adjustments to whitespace control in src_pendo.yml. (#17)

Contributors

• @RichardThRivera (#16)

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

dbt_pendo_source v0.3.0

PR #13 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"].

dbt_pendo_source 0.2.1

Happy Monday!

This release of the dbt_pendo_source dbt package includes the following updates:

Under the Hood

• The valid_through field within both the stg_pendo__feature_history and stg_pendo__page_history models have been updated to leverage the dbt_utils.timestamp() macro to be cast as timestamps. (#10)

Contributors

• @Everettttt (#10)

dbt_pendo_source 0.2.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_fivetran_utils. 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.

Snowflake Reserved Keyword Bug fix

Happy Monday to all the Snowflake users out there ❄️

This release addresses issue #6, in which users were seeing reserved keyword-related errors when the package selected from the source GROUP table. The package now incorporates appropriate quoting and casing for this table in Snowflake destinations. Thanks to both @leinemann and @payzer-mike for contributing 🌟

We've also added a CHANGELOG to capture changes made to various versions of the package.

Initial Release

🎉 This is the initial release of this package 🎉

This package cleans and preps your data to be leveraged for analyzing how users are experiencing and adopting your product.

Currently the package supports Redshift, BigQuery, Snowflake, Databricks, and Postgres.