Amazon Selling Partner dbt Package

This dbt package transforms data from Fivetran's Amazon Selling Partner connector into analytics-ready tables.

Resources

Number of materialized models¹: 31
Connector documentation
- Amazon Selling Partner connector documentation
- Amazon Selling Partner ERD
dbt package documentation

What does this dbt package do?

This package enables you to transform core Seller Central object tables into analytics-ready models and enrich orders, order items, and listed items with catalog information. It creates enriched models with metrics focused on sales aggregates and current inventory levels.

This package is currently not compatible with any Vendor Central modules. If you would like to see Vendor Central compatibility (or the use of any other Seller Central modules), please open up a Feature Request.

Output schema

Final output tables are generated in the following target schema:

<your_database>.<connector/schema_name>_amazon_selling_partner

Final output tables

By default, this package materializes the following final tables:

Table	Description
amazon_selling_partner__orders	Tracks all orders placed on Amazon with payment methods, order totals, and item counts to analyze sales performance, order trends, and revenue patterns for your seller account. Example Analytics Questions: What are daily or monthly sales trends by order volume and total revenue? Which payment methods are customers using most frequently for their purchases? How do order values and fulfillment channels vary across different marketplaces?
amazon_selling_partner__order_items	Provides line-item details for every product sold on Amazon, enriched with catalog information including ASIN, SKU, pricing, and quantities to analyze product performance at the item level. Example Analytics Questions: Which products (by ASIN or SKU) generate the highest sales volume and revenue? How do item prices, quantities ordered, and quantities shipped vary across orders? What is the average order item value and discount rate by product?
amazon_selling_partner__item_inventory	Shows current inventory levels for all catalog items with product details, dimensions, and sales rankings to manage stock levels and optimize inventory across your Amazon catalog. Example Analytics Questions: Which products have low inventory levels that need restocking soon? How do current inventory levels correlate with sales rank trends? What products consume the most warehouse space based on item dimensions?

¹ Each Quickstart transformation job run materializes these models if all components of this data model are enabled. This count includes all staging, intermediate, and final models materialized as view, table, or incremental.

Prerequisites

To use this dbt package, you must have the following:

At least one Fivetran Amazon Selling Partner connection syncing data into your destination.
A BigQuery, Snowflake, Redshift, Databricks, or PostgreSQL destination.

How do I use the dbt package?

You can either add this dbt package in the Fivetran dashboard or import it into your dbt project:

To add the package in the Fivetran dashboard, follow our Quickstart guide.
To add the package to your dbt project, follow the setup instructions in the dbt package's README file to use this package.

How is this package maintained and can I contribute?

Package Maintenance

The Fivetran team maintaining this package only maintains the latest version of the package. We highly recommend you stay consistent with the latest version of the package and refer to the CHANGELOG and release notes for more information on changes across versions.

Contributions

A small team of analytics engineers at Fivetran develops these dbt packages. However, the packages are made better by community contributions.

We highly encourage and welcome contributions to this package. Learn how to contribute to a package in dbt's Contributing to an external dbt package article.