# \#data-explorer **URL:** https://meta.discourse.org/tag/data-explorer/126.md [Latest](https://meta.discourse.org/latest.md) · [Categories](https://meta.discourse.org/categories.md) · [Tags](https://meta.discourse.org/tags.md) --- ## [Monthly triggered recurring automation is not running as expected](https://meta.discourse.org/t/monthly-triggered-recurring-automation-is-not-running-as-expected/402664)
**Author:** [@gassim](https://meta.discourse.org/u/gassim)\ **Replies:** 19\ **Last updated:** [September 16, 2026, 1:29am UTC](https://meta.discourse.org/t/monthly-triggered-recurring-automation-is-not-running-as-expected/402664 "2026-09-16T01:29:59Z")
Hi there! I’ve been facing an issue with an automation that is supposed to trigger at the start of the month; however, even though it is enabled it’s not automatically being triggered. I can’t find any logs or a way to … --- ## [Garbled text in CSVs with special characters downloaded from Data Resource Manager](https://meta.discourse.org/t/csv/411280)
**Author:** [@singi2016cn](https://meta.discourse.org/u/singi2016cn)\ **Replies:** 1\ **Last updated:** [September 9, 2026, 8:58am UTC](https://meta.discourse.org/t/csv/411280 "2026-09-09T08:58:45Z")
--- ## [Set group access when creating a Data Explorer query](https://meta.discourse.org/t/set-group-access-when-creating-a-data-explorer-query/411415)
**Author:** [@lindsey](https://meta.discourse.org/u/lindsey)\ **Replies:** 0\ **Last updated:** [September 1, 2026, 8:18pm UTC](https://meta.discourse.org/t/set-group-access-when-creating-a-data-explorer-query/411415 "2026-09-01T20:18:19Z")
You can grant Data Explorer access to groups to allow folks that aren’t admins or moderators to access information about your community. This is valuable for sharing community data for stakeholders that don’t need or wan… --- ## [Data Explorer refresh](https://meta.discourse.org/t/data-explorer-refresh/411155)
**Author:** [@lindsey](https://meta.discourse.org/u/lindsey)\ **Replies:** 0\ **Last updated:** [August 28, 2026, 2:57pm UTC](https://meta.discourse.org/t/data-explorer-refresh/411155 "2026-08-28T14:57:49Z")
Data Explorer is one of our most powerful features for understanding your community’s health and value. We want to make it easier to use for all customers, particularly those who are just getting started with Discourse. … --- ## [Automation \> Data Explorer Query parameters \> config \> save button also saves the main form](https://meta.discourse.org/t/automation-data-explorer-query-parameters-config-save-button-also-saves-the-main-form/410784)
**Author:** [@andresfromsonar](https://meta.discourse.org/u/andresfromsonar)\ **Replies:** 0\ **Last updated:** [August 24, 2026, 1:18pm UTC](https://meta.discourse.org/t/automation-data-explorer-query-parameters-config-save-button-also-saves-the-main-form/410784 "2026-08-24T13:18:31Z")
Hey there, I ran into a behavior which is in my opinion a bug (or at least, very unexpected!). Here we go: Go to Plugins \> Automation \> Add automation. Select script: Schedule a PM with Data Explorer results. Set Trigg… --- ## [Empower the SQL helper](https://meta.discourse.org/t/empower-the-sql-helper/366949)
**Author:** [@nathank](https://meta.discourse.org/u/nathank)\ **Replies:** 1\ **Last updated:** [July 23, 2026, 2:43am UTC](https://meta.discourse.org/t/empower-the-sql-helper/366949 "2026-07-23T02:43:01Z")
Continuing the discussion from Creating custom AI Bot personas: It would be super helpful to have this bot enabled to actually open Data Explorer and run the query it suggests. --- ## [Data Explorer 🤝 AI - Generate Data Explorer queries with AI](https://meta.discourse.org/t/data-explorer-ai-generate-data-explorer-queries-with-ai/408227)
**Author:** [@nat](https://meta.discourse.org/u/nat)\ **Replies:** 0\ **Last updated:** [July 23, 2026, 2:34am UTC](https://meta.discourse.org/t/data-explorer-ai-generate-data-explorer-queries-with-ai/408227 "2026-07-23T02:34:03Z")
After some testing and refinements for Data Explorer, we are now happy to share that you can make use of Discourse AI to generate Data Explorer queries from right within the plugin. Here’s a quick run through … --- ## [Integrate shared DataExplorer reports into the UI](https://meta.discourse.org/t/integrate-shared-dataexplorer-reports-into-the-ui/407234)
**Author:** [@one1](https://meta.discourse.org/u/one1)\ **Replies:** 4\ **Last updated:** [July 10, 2026, 6:46am UTC](https://meta.discourse.org/t/integrate-shared-dataexplorer-reports-into-the-ui/407234 "2026-07-10T06:46:41Z")
I’d really like to see a better interface for non-admin users to view DataExplorer reports. Currently, if moderators want to see reports I have made for them they have to go to the moderators group page and find the pro… --- ## [Data Explorer Query generator 403 Error](https://meta.discourse.org/t/data-explorer-query-generator-403-error/406694)
**Author:** [@MCobb](https://meta.discourse.org/u/MCobb)\ **Replies:** 2\ **Last updated:** [July 2, 2026, 10:56pm UTC](https://meta.discourse.org/t/data-explorer-query-generator-403-error/406694 "2026-07-02T22:56:08Z")
Is anyone experiencing a 403 error when trying to create a new query? Is there a known bug? or maybe user error?? Thanks --- ## [Queries in Data Explorer result in an empty query result](https://meta.discourse.org/t/abfragen-im-data-explorer-fuhren-zu-einem-leeren-abfrage-ergebnis/404957)
**Author:** [@dickel](https://meta.discourse.org/u/dickel)\ **Replies:** 3\ **Last updated:** [June 18, 2026, 6:00am UTC](https://meta.discourse.org/t/abfragen-im-data-explorer-fuhren-zu-einem-leeren-abfrage-ergebnis/404957 "2026-06-18T06:00:35Z")
When I create a new query in the Data Explorer, I first see a text field where I enter the query name. Then I click "Create New" and add the description and the … --- ## [Explorer reports limited to 5 rows no matter how much data you have :(](https://meta.discourse.org/t/explorer-reports-limited-to-5-rows-no-matter-how-much-data-you-have/401611)
**Author:** [@ganncamp](https://meta.discourse.org/u/ganncamp)\ **Replies:** 6\ **Last updated:** [April 28, 2026, 12:03pm UTC](https://meta.discourse.org/t/explorer-reports-limited-to-5-rows-no-matter-how-much-data-you-have/401611 "2026-04-28T12:03:03Z")
I’m working in the Data Explorer today for the first time in a while. What I’m noticing is that I have to scroll the results table, which is pinned to stay within the page height, no matter how much data I have. … --- ## [Sharing a Data Explorer Query](https://meta.discourse.org/t/sharing-a-data-explorer-query/401612)
**Author:** [@ganncamp](https://meta.discourse.org/u/ganncamp)\ **Replies:** 1\ **Last updated:** [April 27, 2026, 2:12pm UTC](https://meta.discourse.org/t/sharing-a-data-explorer-query/401612 "2026-04-27T14:12:06Z")
As an admin, I write a Data Explorer query. From that query, I can administer the groups with access to it. But if I just copy/paste the URL from the query itself to share, my target audience gets 403’d because what I s… --- ## [More charting options for Data Explorer](https://meta.discourse.org/t/more-charting-options-for-data-explorer/401130)
**Author:** [@nat](https://meta.discourse.org/u/nat)\ **Replies:** 4\ **Last updated:** [April 22, 2026, 2:57pm UTC](https://meta.discourse.org/t/more-charting-options-for-data-explorer/401130 "2026-04-22T14:57:19Z")
The Data Explorer plugin lets you dive deep into your community’s data with custom queries. It’s now easier to visualize the results of those queries, thanks to a few recent updates that expand the plugin’s charting capa… --- ## [Coping with deprecated columns in Data Explorer](https://meta.discourse.org/t/coping-with-deprecated-columns-in-data-explorer/400264)
**Author:** [@ted](https://meta.discourse.org/u/ted)\ **Replies:** 3\ **Last updated:** [April 22, 2026, 9:46am UTC](https://meta.discourse.org/t/coping-with-deprecated-columns-in-data-explorer/400264 "2026-04-22T09:46:53Z")
One infrequent but annoying problem is Data Explorer queries can start breaking when columns are dropped and renamed in core or plugins. Downstream this can cause automations to start failing. To that end, I have opened… --- ## [Tracking LLM Crawler Activity: Can we identify which topics are being indexed/crawled most frequently?](https://meta.discourse.org/t/tracking-llm-crawler-activity-can-we-identify-which-topics-are-being-indexed-crawled-most-frequently/401083)
**Author:** [@noahl](https://meta.discourse.org/u/noahl)\ **Replies:** 3\ **Last updated:** [April 21, 2026, 5:26am UTC](https://meta.discourse.org/t/tracking-llm-crawler-activity-can-we-identify-which-topics-are-being-indexed-crawled-most-frequently/401083 "2026-04-21T05:26:30Z")
We’re looking to identify which specific topics are being indexed/crawled most frequently by AI crawlers to ensure our most “cited” content isn’t feeding LLM hallucinations. Is there a way with Data Explorer to attribute… --- ## [Double HTML escaping in data explorer output](https://meta.discourse.org/t/double-html-escaping-in-data-explorer-output/400018)
**Author:** [@RGJ](https://meta.discourse.org/u/RGJ)\ **Replies:** 1\ **Last updated:** [April 8, 2026, 5:07am UTC](https://meta.discourse.org/t/double-html-escaping-in-data-explorer-output/400018 "2026-04-08T05:07:56Z")
After finding my workaround for this issue, I still could not get the HTML escaping right. Until I found out that that was not a SQL issue but a display issue. Query: SELECT 'Fish & Chips' Output: Fish & Chips De… --- ## ["Remove the semicolons from the query"](https://meta.discourse.org/t/remove-the-semicolons-from-the-query/400015)
**Author:** [@RGJ](https://meta.discourse.org/u/RGJ)\ **Replies:** 1\ **Last updated:** [April 8, 2026, 5:07am UTC](https://meta.discourse.org/t/remove-the-semicolons-from-the-query/400015 "2026-04-08T05:07:48Z")
Problem: When creating a data explorer query that replaces some HTML entities, I could not save the query because it contained semicolons. However, these semicolons are not part of the actual DQL syntax and (thus) inno… --- ## [Create a Data Explorer query using the API](https://meta.discourse.org/t/create-a-data-explorer-query-using-the-api/394388)
**Author:** [@Discourse](https://meta.discourse.org/u/Discourse)\ **Replies:** 3\ **Last updated:** [March 29, 2026, 7:46pm UTC](https://meta.discourse.org/t/create-a-data-explorer-query-using-the-api/394388 "2026-03-29T19:46:03Z")
Create a Data Explorer query with the API :bookmark: This how-to guide explains how to create a Data Explorer query using the Discourse API. :person\_raising\_hand: Required user level: Administrator Prerequisites B… --- ## [Has something changed in the data explorer? Can't get query via API](https://meta.discourse.org/t/has-something-changed-in-the-data-explorer-cant-get-query-via-api/398172)
**Author:** [@pfaffman](https://meta.discourse.org/u/pfaffman)\ **Replies:** 8\ **Last updated:** [March 11, 2026, 5:46pm UTC](https://meta.discourse.org/t/has-something-changed-in-the-data-explorer-cant-get-query-via-api/398172 "2026-03-11T17:46:37Z")
This stopped working two days ago for a hosted customer: HTTP\_STATUS=$(curl -s -o /tmp/discourse\_response.json -w "%{http\_code}" \\ -X POST "https://HOSTNAME/admin/plugins/discourse-data-explorer/queries/3/run" \\ … --- ## [Broken links in existing posts after Data Explorer URL change](https://meta.discourse.org/t/broken-links-in-existing-posts-after-data-explorer-url-change/396815)
**Author:** [@Moin](https://meta.discourse.org/u/Moin)\ **Replies:** 5\ **Last updated:** [February 25, 2026, 2:49am UTC](https://meta.discourse.org/t/broken-links-in-existing-posts-after-data-explorer-url-change/396815 "2026-02-25T02:49:03Z")
The link in messages and posts containing scheduled Data Explorer results created by the automation plugin has changed. While the texts have been updated so that new posts will include the correct URL\[1\], this breaks all… --- ## [Discourse Data Explorer](https://meta.discourse.org/t/discourse-data-explorer/32566)
**Author:** [@Discourse](https://meta.discourse.org/u/Discourse)\ **Replies:** 30\ **Last updated:** [October 22, 2025, 12:31pm UTC](https://meta.discourse.org/t/discourse-data-explorer/32566 "2025-10-22T12:31:20Z")
:discourse2: Summary Discourse Data Explorer allows you to make SQL queries against your live database, allowing for up-to-the-minute stats reporting. :open\_book: Install Guide This plugin is bundled with… --- ## [Automate the syncing of Discourse queries to Google Sheets](https://meta.discourse.org/t/automate-the-syncing-of-discourse-queries-to-google-sheets/394473)
**Author:** [@Discourse](https://meta.discourse.org/u/Discourse)\ **Replies:** 0\ **Last updated:** [January 27, 2026, 6:31pm UTC](https://meta.discourse.org/t/automate-the-syncing-of-discourse-queries-to-google-sheets/394473 "2026-01-27T18:31:01Z")
Sync Discourse Data Explorer queries to Google Sheets :bookmark: This how-to guide explains how to automate importing Discourse Data Explorer query results into Google Sheets using Google Apps Script. … --- ## [Run Data Explorer queries with the Discourse API](https://meta.discourse.org/t/run-data-explorer-queries-with-the-discourse-api/120063)
**Author:** [@Discourse](https://meta.discourse.org/u/Discourse)\ **Replies:** 14\ **Last updated:** [May 6, 2025, 5:15pm UTC](https://meta.discourse.org/t/run-data-explorer-queries-with-the-discourse-api/120063 "2025-05-06T17:15:01Z")
:bookmark: This guide explains how to use the Discourse API to create, run, and manage queries with the Data Explorer plugin. :person\_raising\_hand: Required user level: Administrator Virtually any action that can b… --- ## [Data Explorer results persist when navigating between queries](https://meta.discourse.org/t/data-explorer-results-persist-when-navigating-between-queries/396564)
**Author:** [@tshenry](https://meta.discourse.org/u/tshenry)\ **Replies:** 2\ **Last updated:** [February 20, 2026, 3:15pm UTC](https://meta.discourse.org/t/data-explorer-results-persist-when-navigating-between-queries/396564 "2026-02-20T15:15:12Z")
At the moment, if you run a Data Explorer query, the results will persist even when you navigate to other queries. Reproduction steps: Find and run a Data Explorer query that produces results Using the UI, navigate ba… --- ## [Using Parameters in Data Explorer Queries](https://meta.discourse.org/t/using-parameters-in-data-explorer-queries/277934)
**Author:** [@SaraDev](https://meta.discourse.org/u/SaraDev)\ **Replies:** 6\ **Last updated:** [February 10, 2026, 2:20pm UTC](https://meta.discourse.org/t/using-parameters-in-data-explorer-queries/277934 "2026-02-10T14:20:25Z")
Parameters are a powerful tool that can be used in Data Explorer queries on Discourse. Parameters allow for more dynamic and customizable queries, and instead of hard-coding values in your queries, you can declare vari… --- ## [Exploring your Discourse Data with Discourse MCP](https://meta.discourse.org/t/exploring-your-discourse-data-with-discourse-mcp/395383)
**Author:** [@Falco](https://meta.discourse.org/u/Falco)\ **Replies:** 0\ **Last updated:** [February 6, 2026, 5:15pm UTC](https://meta.discourse.org/t/exploring-your-discourse-data-with-discourse-mcp/395383 "2026-02-06T17:15:23Z")
We just added Data Explorer integration to Discourse MCP, allowing both technical and non-technical users alike to explore the vast data on their Discourse instances. The MCP uses the existing Data Explorer workflow, ru… --- ## [Can I create a new query in Data Explorer using API?](https://meta.discourse.org/t/can-i-create-a-new-query-in-data-explorer-using-api/264529)
**Author:** [@utku](https://meta.discourse.org/u/utku)\ **Replies:** 2\ **Last updated:** [January 26, 2026, 11:34pm UTC](https://meta.discourse.org/t/can-i-create-a-new-query-in-data-explorer-using-api/264529 "2026-01-26T23:34:16Z")
I can run the existing queries with or without parameters. I tried some POST calls to create a new query in Data Explorer without using the Admin console, but failed. Is there a method to create/delete a query in Data Ex… --- ## [Challenges with automating Data Explorer results](https://meta.discourse.org/t/challenges-with-automating-data-explorer-results/357327)
**Author:** [@ganncamp](https://meta.discourse.org/u/ganncamp)\ **Replies:** 3\ **Last updated:** [September 17, 2025, 10:20pm UTC](https://meta.discourse.org/t/challenges-with-automating-data-explorer-results/357327 "2025-09-17T22:20:47Z")
I’ve crafted a Data Explorer query to find the threads a group participated in publicly and extract any Jira tickets they included in those posts. I’m quite pleased with the results: Using the x\_id magic, I get the … --- ## [Is there a way to see what posts have been hidden and by whom?](https://meta.discourse.org/t/is-there-a-way-to-see-what-posts-have-been-hidden-and-by-whom/372083)
**Author:** [@MikeNolan](https://meta.discourse.org/u/MikeNolan)\ **Replies:** 1\ **Last updated:** [September 17, 2025, 7:51pm UTC](https://meta.discourse.org/t/is-there-a-way-to-see-what-posts-have-been-hidden-and-by-whom/372083 "2025-09-17T19:51:25Z")
Our organization is in the final stage of its biennial election and that’s usually when our forums get a bit more controversial. Our moderators have the authority to hide a post if it violates our acceptable usage guide… --- ## [Populate Data Explorer params with URL params](https://meta.discourse.org/t/populate-data-explorer-params-with-url-params/169404)
**Author:** [@Nacho\_Caballero](https://meta.discourse.org/u/Nacho_Caballero)\ **Replies:** 12\ **Last updated:** [September 3, 2025, 12:51am UTC](https://meta.discourse.org/t/populate-data-explorer-params-with-url-params/169404 "2025-09-03T00:51:53Z")
It would be great if I could share a Data Explorer query with a group and have the query params be pre-filled with the URL params. For example, if I have this param -- string :username, I should be able to share it with… [Next page](https://meta.discourse.org/tag/data-explorer/126.md?match_all_tags=true&page=1&tags%5B%5D=data-explorer)