---
title: Shops table
description: "Shopify Data Warehouse documentation: Shops table."
source_url:
  html: https://shopify.dev/docs/apps/build/data-warehouse/reference/schema/shops
  md: https://shopify.dev/docs/apps/build/data-warehouse/reference/schema/shops.md
---

# Shops table

Shops contains basic information about your stores. Most tables in the data warehouse have a foreign key reference to the shop\_id column in this table, which means you can join this table with other tables to compare metrics across your stores. This table contains one row per store.

### Columns

| Column | Data type | Description |
| - | - | - |
| shop\_id | numeric | Unique identifier for the store. This column is the **primary key** for the shops table. |
| name | varchar | Name of your store. |
| domain | varchar | Primary domain specified for your online store. Your primary domain is the one that your customers and search engines see. For example, [www.mycompany.com](http://www.mycompany.com). |

### Examples

The following example returns the total sales by stores:

```SQL
SELECT shops.name AS shop_name,
      DATE_TRUNC('month', happened_at),
      SUM(total_sales_fx) AS total_sales_usd
FROM shopify.sales
JOIN shopify.shops
  ON sales.shop_id = shops.shop_id
GROUP BY 1,
        2;
```

***