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:
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.
Hi Community,
What is your best practise to analyze and query all your Shopify data?
Do you use the API to export the data and if so where do you send it to / which tools do you use for analysis?
I would prefer to work with SQL or Python for quering.
I tried the ShopifyQL Notebooks app but it doesn’t give me access to all available datasets.
Thanks 
Hey JenE,
I’ve tested SuperU, and it’s excellent for Shopify data analysis—very user-friendly. They even provide a 30-day free trial. I suggest exploring it for an improved solution. I’m open to discussing my experience with you. Visit the SuperU for more details.
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
Hi Mattcrane,
We figured that setting up your own datawarehouse, using the Shopify API, will be the only solution that gives us the full scope and flexibilty to work with the data as needed.
Best