Bruin CLI Step 3 of 4
Shopify to ClickHouse with Bruin
1) Inspect the conformed models
T2 is the layer that your analytics work should normally start from. Each file is a clickhouse.sql table with a depends list, a primary key, typed columns, and an explicit refresh policy.
| Asset | Table | What it does | Direct dependencies |
|---|---|---|---|
t2_inventory_items.sql | shopify.t2_inventory_items | Extracts inventory item, SKU, variant, price, cost, and sellable-quantity attributes | t1_inventory_items |
t2_products.sql | shopify.t2_products | Builds the product catalogue and enriches it with current inventory | t1_products, t2_inventory_items |
t2_orders.sql | shopify.t2_orders | Produces one clean order row with lifecycle, channel, currency, and financial measures | t1_orders |
t2_order_line_items.sql | shopify.t2_order_line_items | Parses nested order lines into one row per item and allocates recognized revenue | t1_orders, t2_orders |
t2_customers.sql | shopify.t2_customers | Produces customer consent, geography, lifecycle, and completed-order measures without exposing email or address values | t1_customers, t2_orders |
The order model has to finish before line items and customer measures. Inventory items have to finish before products. You do not need to manually order those commands because the depends blocks make that lineage part of the project.