/dbt_shopify

Fivetran's Shopify dbt package

Shopify

This package models Shopify data from Fivetran's connector. It uses data in the format described by this ERD.

The main focus of the package is to transform the core object tables into analytics-ready models, including a cohort model to understand how your customers are behaving over time.

Models

This package contains transformation models, designed to work simultaneously with our Shopify source package. A dependency on the source package is declared in this package's packages.yml file, so it will automatically download when you run dbt deps. The primary outputs of this package are described below.

model description
shopify__customer_cohorts Each record represents the monthly performance of a customer, including fields for the month of their 'cohort'.
shopify__customers Each record represents a customer, with additional dimensions like lifetime value and number of orders.
shopify__orders Each record represents an order, with additional dimensions like whether it is a new or repeat purchase.
shopify__order_lines Each record represents an order line item, with additional dimensions like how many items were refunded.
shopify__products Each record represents an product, with additional dimensions like most recent order date and order volume.

Installation Instructions

Check dbt Hub for the latest installation instructions, or read the dbt docs for more information on installing packages.

Configuration

By default, this package looks for your Shopify data in the shopify schema of your target database. If this is not where your Shopify data is, add the following configuration to your dbt_project.yml file:

# dbt_project.yml

...
config-version: 2

vars:
    shopify_schema: your_database_name
    shopify_database: your_schema_name

For additional configurations for the source models, visit the Shopify source package.

Contributions

Additional contributions to this package are very welcome! Please create issues or open PRs against master. Check out this post on the best workflow for contributing to a package.

Resources: