Hi JenE,
Were you ever able to come across a good solution? I thought I’d be able to do everything with ShopifyQL notebooks as well … but running into some really surprising limitations …
Any advice or feedback would be helpful
Topic summary
Main issue: How to analyze and query complete Shopify datasets with SQL/Python. ShopifyQL Notebooks was tried but lacks access to all datasets, creating significant limitations.
Suggestions raised:
- Third-party analytics tool: SuperU (promoted as user-friendly with a 30-day trial and video resources).
Follow-up: Another participant echoed the limitations of ShopifyQL Notebooks and sought alternatives.
Outcome/decision: The original poster concluded that setting up an own data warehouse fed by the Shopify API is the only approach that provides full scope and flexibility for analysis. This enables working in SQL/Python without the data-access constraints seen in ShopifyQL Notebooks.
Current status: Practical resolution identified (DIY data warehouse via Shopify API). Specific implementation details (warehouse choice, ETL/ELT tooling, schema design) were not discussed. The thread implies ShopifyQL Notebooks remains insufficient for comprehensive data access.