ShopifyQL Table_Name List

Hello,
I’m looking for a list of all Table_Name and corresponding Column_Name values across all available tables, so I can properly structure and run ShopifyQL queries.

Could you please provide this information or point me to the relevant documentation?

Thank you!

1 Like

Hey @GABERSKY :waving_hand: - we don’t currently have a specific list of all the tables, but they should pop up when you’re creating your initial query in the /analytics/reports/explore section of your shop’s admin like this:

Right now, we don’t offer a way to access the new version of ShopifyQL through the API (but it is something we are aware of as a feature request for sure - just can’t speak to a timeline/guarantee on that at the moment).

We do have some info on specific datasets for the older ShopifyQL API here at this link, but it has been sunset and will be fully deprecated as of this coming July once support for API version 2024-07 ends.

Hope this helps - let me know if I can clarify anything on my end here.