SELECT o.order_number, p.product_name, i.quantity, i.unit FROM [ order ] o JOIN order_item i ON o.id = i.order_id JOIN product p ON p.id = i.product_id ORDER BY o.order_number
Shopify is a commerce platform that allows anyone to easily sell online, at a retail location, and everywhere in between. It's computer software platform and retail point of sale (POS) system.Learn more at Shopify
Heap automatically captures every web, mobile, and cloud interaction: clicks, submits, transactions, emails, and more. Retroactively analyze your data without writing code.Learn more at Heap
Waste less time, spend less money, and scale anytime
With 100+ connectors and counting, we ensure the data in your warehouse is always up to date and accessible by analysts.