v1.3.3 dbt_apple_store

PR #54 includes the following updates:

Bug Fix

• Corrects the default source table identifier for app_store_app, which pointed at the wrong table name and caused a runtime error in stg_apple_store__app_store_app_tmp. This default had no effect prior to v1.3.0's move to fivetran_utils.union_connections, which resolves the source table using this identifier.
• Renames the apple_store_app_identifier variable to apple_store_app_store_app_identifier to match this package's variable naming convention. If you had set apple_store_app_identifier in your own project, update your configuration to use the new variable name.

Full Changelog: v1.3.2...v1.3.3

v1.3.2 dbt_apple_store

PR #52 includes the following updates:

Feature Updates

• Adds DuckDB as a supported destination.

Full Changelog: v1.3.1...v1.3.2

v1.3.1 dbt_apple_store

PR #53 includes the following updates:

Bug Fix

• Fixes int_apple_store__date_spine compilation errors by falling back to a default one-year date range when the underlying APP_STORE_* tables aren't synced.

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

v1.3.0 dbt_apple_store

PR #50 includes the following updates:

Schema/Data Changes (--full-refresh required after upgrading)

1 total change • 1 possible breaking change

Data Model(s)	Change type	Old	New	Notes
All models	source_relation column (when using a single Apple Store schema)	Empty string ('')	<database>.<schema>

Feature Updates

• Introduces the new (recommended) apple_store_sources variable for more robust union data configuration. The old apple_store_union_schemas and apple_store_union_databases variables will still be supported. See the README for specific details.

Under the Hood

• 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.
• Introduces fivetran_utils.partition_by_source_relation to conditionally include source_relation in partition clauses only when multiple sources are configured.

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

v1.2.0 dbt_apple_store

PR #45 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.1.0...v1.2.0

v1.1.0 dbt_apple_store

PR #44 includes the following updates:

Features

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

Full Changelog: v1.0.1...v1.1.0

v1.0.1 dbt_apple_store

PR #42 includes the following updates:

Bug Fixes

• Fixed a run error in int_apple_store__date_spine that occurred when one or more source tables used to determine the start date of the spine were missing.

Full Changelog: v1.0.0...v1.0.1

v1.0.0 dbt_apple_store

PR #41 includes the following updates:

Breaking Changes

Source Package Consolidation

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

v0.6.0 dbt_apple_store

PR #36 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 (Apple App Store 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 `apple_store` in file
`models/src_apple_store.yml`. The `freshness` top-level property should be moved
into the `config` of `apple_store`.

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 Apple App Store 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 apple_store package. Pin your dependency on v0.5.1 in your packages.yml file.
3. Utilize a dbt override to overwrite the package's apple_store 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_apple_store.yml file and add an overrides: apple_store_source property.

Under the Hood

• Updates to ensure integration tests use latest version of dbt.

Full Changelog: v0.5.1...v0.6.0

v0.5.1 dbt_apple_store

This release introduces the following updates:

Under the Hood

• Prepends materialized configs in the package's dbt_project.yml file with + to improve compatibility with the newer versions of dbt-core starting with v1.10.0. (PR #34)
• Updates the package maintainer pull request template. (PR #35)

Contributors

• @b-per (PR #34)

Full Changelog: v0.5.0...v0.5.1