fivetran/dbt_shopify v0.20.0

v0.20.0 dbt_shopify

on GitHub

PR #113 introduces the following updates:

Feature Update: GraphQL API Support

Fivetran very recently released a new version of the Shopify connector that leverages Shopify's newer GraphQL API instead of the REST API, as Shopify deprecated the REST API in October 2024. The GraphQL and REST API-based schemas are slightly different, but this package is designed to run for either or, not both. It will do so based on the value of the shopify_api variable.

By default, shopify_api is set to rest and will run the shopify__* models in the rest folder. If you would like to run the package on a GraphQL-based schema, adjust shopify_api accordingly. This will run the shopify_gql__* models in the graphql folder:

This variable is dynamically configured for you in Fivetran Quickstart based on your Shopify connection details.

vars:
  shopify_api: graphql # By default = rest. Must be lowercase

Overall, the package aims for parity across the different API versions and aligns column names with their REST names, if the fields are supported in GraphQL. There will be a 1:1 relationship between REST API and GraphQL based end models, but please note that the following source tables are not present in GraphQL and will therefore not be included in any transformations:

• ABANDONED_CHECKOUT_SHIPPING_LINE: The absence of this table will result in no shopify_gql__discounts.total_abandoned_checkout_shipping_price field.
• ORDER_URL_TAG: The absence of this table will result in no shopify_gql__orders.order_url_tags field.

Full Changelog: v0.19.1...v0.20.0