Glimpse BI vs wpDataTables: charting your existing WordPress data
Both Glimpse BI and wpDataTables put charts and tables on a WordPress site, and they overlap enough that people ask which to use. The honest answer depends on where your data already lives. This is a fair look at the difference, with no claim that either is "better" in the abstract.
The core difference
wpDataTables is built around tables you assemble — created by hand, imported from CSV or Excel, or linked to a Google Sheet or external database — and then displayed as sortable tables and charts.
Glimpse BI is built around the data already sitting in your WordPress database: posts, users, WooCommerce orders, membership records, booking rows. You point it at a table, aggregate it, and chart the result in place. Nothing is imported.
| Glimpse BI | wpDataTables | |
|---|---|---|
| Primary data source | Your existing WordPress and plugin tables | Tables you create, import, or link |
| No-code building | Pick a table, measure, dimension, filters | Table editor and query wizard |
| Raw SQL | Read-only SELECT, parsed and validated | Supported via query constructor |
| Leaves your server | Free plugin: no external calls. Ask (Pro) sends your schema only, by default | Depends on the source you connect |
| Free tier | Unlimited dashboards and charts, ongoing | Limited free version |
What Glimpse BI does carefully
Two things are worth calling out because they're specific and verifiable, not marketing adjectives.
Read-only SQL is enforced by a parser, not a keyword filter. Every SQL chart is parsed into a syntax tree before it runs. Only SELECT and WITH … SELECT pass; multi-statement queries, INTO OUTFILE, LOAD_FILE, SLEEP, and information_schema access are rejected. Values you pass as filters are bound as parameters rather than pasted into the query string.
Your rows stay on your server. The free plugin makes no external HTTP calls: your order rows, member records, and customer data are queried and rendered entirely on your own host. The one feature that talks to Glimpse's AI service is Ask in Pro, and by default it sends your schema (table and column names), never the rows. For stores charting customer or order data, that's a meaningful difference from any tool that routes data through a third party.
Results pass through a stale-while-revalidate cache with a stampede lock, so a dashboard several people are viewing shares one query per window instead of re-running it on every page load.
When wpDataTables fits
If your source of truth is a spreadsheet, an uploaded file, or an external database you want to surface in WordPress, wpDataTables is purpose-built for that. Its strength is assembling and presenting tabular data from many origins.
When Glimpse BI fits
If the numbers you care about already live in your WordPress database — WooCommerce orders, MemberPress members, Amelia bookings — and you want dashboards on them without exporting anything, Glimpse BI queries them where they are. The free plugin has no caps on dashboards, charts or embeds and is not a time-limited trial, so you can decide whether it fits before paying for anything.