v1.5.1 dbt_shopify

PR #143 includes the following updates:

Under the Hood

• Adjusts the data type of shopify__calendar_start_date in the quickstart.yml from string to date.

Full Changelog: v1.5.0...v1.5.1

v1.5.0 dbt_shopify

PR #142 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.4.0...v1.5.0

v1.4.0 dbt_shopify

PR #141 includes the following updates:

Schema/Data Changes

11 total changes • 11 possible breaking changes

Data Model(s)	Change type	Old	New	Notes
shopify_<gql>__customers shopify_<gql>__orders shopify_<gql>__products shopify_<gql>__inventory_levels shopify_<gql>__daily_shop shopify_<gql>__collection_metafields shopify_<gql>__customer_metafields shopify_<gql>__order_metafields shopify_<gql>__product_metafields shopify_<gql>__product_variant_metafields shopify_<gql>__shop_metafields	Metafield columns	Unlimited	50 (configurable)	The 50 most commonly used metafields are pivoted into columns by default. You can adjust this number via the shopify_max_metafields variable.

Feature Updates

• Introduces the shopify_max_metafields variable to configure the number of metafields pivoted into columns. Configure it as follows (see README for details):

vars:
  shopify_max_metafields: 200 # (Any positive integer) Default is 50

Bug Fixes

• Deduplicates metafields with identical slugs (for example, my-first-metafield and my_first_metafield) to prevent ambiguous column errors.
• Ensures the stg_shopify_gql__shop.enabled_presentment_currencies and stg_shopify_gql__transaction.receipt fields are strings.
• Applies the following warehouse-dependent limits on the number of metafields that are pivoted into columns, regardless of the value of shopify_max_metafields. Metafields are included based on their prevalence in your Shopify METAFIELD table:
  • BigQuery: 10,000
  • Redshift: 1,600
  • Postgres: 1,600
  • Databricks: 32,768
  • Snowflake: No limit

Under the Hood

• Adds data validation tests for metafield models.
• Adjusts metafield seed data to test for duplicate slugs/column names.
• Creates max_columns() and downstream_model_column_count() macros to support adherence to warehouse column limits when pivoting metafields.

Full Changelog: v1.3.1...v1.4.0

v1.4.0-a1 dbt_shopify

PR #141 includes the following updates:

Schema/Data Changes

11 total changes • 11 possible breaking changes

Data Model(s)	Change type	Old	New	Notes
shopify_<gql>__customers shopify_<gql>__orders shopify_<gql>__products shopify_<gql>__inventory_levels shopify_<gql>__daily_shop shopify_<gql>__collection_metafields shopify_<gql>__customer_metafields shopify_<gql>__order_metafields shopify_<gql>__product_metafields shopify_<gql>__product_variant_metafields shopify_<gql>__shop_metafields	Metafield columns	Unlimited	50 (configurable)	The 50 most commonly used metafields are pivoted into columns by default. You can adjust this number via the shopify_max_metafields variable.

Feature Updates

• Introduces the shopify_max_metafields variable to configure the number of metafields pivoted into columns. Configure it as follows (see README for details):

vars:
  shopify_max_metafields: 200 # (Any positive integer) Default is 50

Bug Fixes

• Deduplicates metafields with identical slugs (for example, my-first-metafield and my_first_metafield) to prevent ambiguous column errors.
• Ensures the stg_shopify_gql__shop.enabled_presentment_currencies and stg_shopify_gql__transaction.receipt fields are strings.
• Applies the following warehouse-dependent limits on the number of metafields that are pivoted into columns, regardless of the value of shopify_max_metafields. Metafields are included based on their prevalence in your Shopify METAFIELD table:
  • BigQuery: 10,000
  • Redshift: 1,600
  • Postgres: 1,600
  • Databricks: 32,768
  • Snowflake: No limit

Under the Hood

• Adds data validation tests for metafield models.
• Adjusts metafield seed data to test for duplicate slugs/column names.

Full Changelog: v1.3.1...v1.4.0-a1

v1.3.1 dbt_shopify

PR #137 includes the following updates:

Schema/Data Changes

4 total changes • 0 possible breaking changes

Data Model(s)	Change type	Old	New	Notes
stg_shopify_gql__order_note_attribute	New column		key	Aligns with connector updates by renaming name to key. The name column has been retained but will be fully deprecated and removed from the model in January 2026.
stg_shopify_gql__tax_line	Updated source table names	TAX_LINE	TAX_LINE or ORDER_LINE_TAX_LINE	For newer Shopify connections, the source table has been renamed to ORDER_LINE_TAX_LINE. The model will dynamically determine which table you have and transform your data accordingly.
stg_shopify_gql__order_line_refund	Updated source table names	ORDER_LINE_REFUND	ORDER_LINE_REFUND or REFUND_LINE_ITEM	For newer Shopify connections, the source table has been renamed to REFUND_LINE_ITEM. The model will dynamically determine which table you have and transform your data accordingly.
stg_shopify_gql__order_note_attribute	Updated source table names	ORDER_NOTE_ATTRIBUTE	ORDER_NOTE_ATTRIBUTE or ORDER_CUSTOM_ATTRIBUTE	For newer Shopify connections, the source table has been renamed to ORDER_CUSTOM_ATTRIBUTE. The model will dynamically determine which table you have and transform your data accordingly.

Feature Updates

• Adds automatic detection and support for new GraphQL table naming conventions introduced by Shopify for connections created after November 2025. Models will automatically use the new table names when available while maintaining backward compatibility with existing connections.
• Adds the following variables to override the above dynamic behavior if desired. See the README for more details.
  • shopify_gql_using_order_custom_attribute
  • shopify_gql_using_order_line_tax_line
  • shopify_gql_using_refund_line_item

Under the Hood

• Adds does_table_exist macro to dynamically detect table availability and enable automatic switching between old and new table naming conventions.
• Updates integration test seed files to match new table structures.
• Updates validation tests to run dynamically based on shopify_api.

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

v1.3.0 dbt_shopify

PR #136 includes the following updates:

Features

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

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

v1.2.0 dbt_shopify

PR #135 includes the following updates:

Schema/Data Change

2 total changes • 2 possible breaking changes

Data Model(s)	Change type	Old	New	Notes
REST: shopify__discounts	Updated surrogate key	discounts_unique_key: source_relation discount_code_id	discounts_unique_key: source_relation discount_code_id discount_id discount_type code allocation_method description target_selection target_type type value value_type	Fixes uniqueness test failure.
GraphQL: shopify_gql__discounts	Updated surrogate key	unique_key: source_relation discount_code_id	unique_key: source_relation discount_code_id discount_id discount_type code allocation_method target_selection target_type value_amount value_currency_code value_percentage value_type	Fixes uniqueness test failures.

Under the Hood

• Updates consistency tests to improve managing the columns included in testing.

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

v1.1.0 dbt_shopify

PR #132 includes the following updates:

Schema/Data Change

11 total changes • 11 possible breaking changes

Data Model(s)	Change type	Old	New	Notes
shopify__customers or shopify_gql__customers	New Columns		CUSTOMER metafields	Disable by setting the shopify_using_customer_metafields and shopify_using_all_metafields variables to False.
shopify__daily_shop or shopify_gql__daily_shop	New Columns		SHOP metafields	Disable by setting the shopify_using_shop_metafields and shopify_using_all_metafields variables to False.
shopify__inventory_levels or shopify_gql__inventory_levels	New Columns		PRODUCT_VARIANT metafields	Disable by setting the shopify_using_product_variant_metafields and shopify_using_all_metafields variables to False.
shopify__orders or shopify_gql__orders	New Columns		ORDER metafields	Disable by setting the shopify_using_order_metafields and shopify_using_all_metafields variables to False.
shopify__products or shopify_gql__products	New Columns		PRODUCT metafields	Disable by setting the shopify_using_product_metafields and shopify_using_all_metafields variables to False.
shopify__collection_metafields or shopify_gql__collection_metafields	Default Enablement	Disabled	Enabled	The default value of shopify_using_collection_metafields is now True (previously False). Currently, COLLECTION metafields are not included in any other end models.
shopify__customer_metafields or shopify_gql__customer_metafields	Default Enablement	Disabled	Enabled	The default value of shopify_using_customer_metafields is now True (previously False).
shopify__order_metafields or shopify_gql__order_metafields	Default Enablement	Disabled	Enabled	The default value of shopify_using_order_metafields is now True (previously False).
shopify__product_metafields or shopify_gql__product_metafields	Default Enablement	Disabled	Enabled	The default value of shopify_using_product_metafields is now True (previously False).
shopify__product_variant_metafields or shopify_gql__product_variant_metafields	Default Enablement	Disabled	Enabled	The default value of shopify_using_product_variant_metafields is now True (previously False).
shopify__shop_metafields or shopify_gql__shop_metafields	Default Enablement	Disabled	Enabled	The default value of shopify_using_shop_metafields is now True (previously False).

Note: If you are running the package via Fivetran Quickstart, the shopify_using_[object]_metafields variables are automatically configured based on the presence of relevant source data in your warehouse.

Please refer to the README for more details on these variables.

Under the Hood

• Adjusts seed data to test the incorporation of metafields.
• Adds consistency validation tests for all GraphQL models.
• Adds metafield variables to quickstart.yml to enable dynamic configuration in Fivetran Quickstart.

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

v1.0.0 dbt_shopify

PR #123 includes the following updates:

Schema/Data Change

1 total changes • 1 possible breaking changes

A --full-refresh is required when upgrading to ensure the following change is properly applied.

Data Model(s)	Change type	Old	New	Notes
stg_shopify_gql__metafield	materialization	view	table	Corrects the previous misconfiguration.

Source Package Consolidation

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

Full Changelog: v0.22.0...v1.0.0

v0.22.0 dbt_shopify

PR #121 includes the following updates:

Under the Hood

• Updates the quickstart.yml file so that GraphQL models are exposed and available to run in Fivetran Quickstart.

Full Changelog: v0.21.1...v0.22.0