Schema Reference

Learn about the fact tables that you can access using the Data Warehouse. This reference provides information about each of the tables that you can access using the Shopify Data Warehouse. The data warehouse provides a SQL database that contains your Shopify data for all your stores. This database is read-only. You can query the tables in the database running SQL queries in Amazon Redshift SQL.

You can access the following tables:

Addresses: Current billing and shipping addresses of customers
API clients: Sales channels and apps that are used to create orders
Collects: Current collection information
Customers: Current customer information including historical information about their orders, as well as predictive metrics
Customer tags: Current customer tag information
Inventory adjustments: History of inventory adjustments
Inventory items snapshot: Daily inventory level tracking
Line items: Line item details from actual orders
Line item properties: Line item property details from actual orders
Locations: Current Shopify Point of Sale (POS) location information
Metafields: Current information about metafields
Online store sessions: Visits to your online stores, including information about referrals, session length, and UTM campaigns
Orders: General information about orders. Do not use this table for financial calculations (use the sales table instead)
Order attribution interactions: Current marketing conversion information
Order note attributes: Current order note attribute information
Order tags: Current order tag information
Products: Current product information
Product tags: Current information about product tags
Product variants: Current product variant details
Sales: Sales metrics about actual order sales and returns. This table contains order data at the time of the order or return. Use this table when calculating financial metrics.
Shops: Address information for your stores. Most tables have foreign keys to the shops table.
Users: Current staff account details