On Tue, Jul 2, 2024 at 6:48 PM Francesco Negri <[email protected]> wrote: > In Superset, databases must unfortunately be added individually
This has been solved [1], and all ToolsDB public databases (the ones ending with "_p") can be queried from both Quarry and Superset. > The last request in the parent task (T151158) was to be able to query > Quarry's own database. This is not implemented yet This feature has now been implemented [2] and you can type "quarry" or "quarry_p" as the database name in Quarry to query 4 tables on the internal database (query, query_revision, query_run, star). These tables contain information about all queries that are being run and starred by users in Quarry. This information was already public through the web interface, but you can now query it using SQL. I have marked the original task [0] as Resolved, almost 8 years after it was created by intracer in 2016. Thanks to all the people who participated with patches, comments and requests over this time, and thanks all for your patience! Francesco [0] https://phabricator.wikimedia.org/T151158 [1] https://phabricator.wikimedia.org/T367393 [2] https://phabricator.wikimedia.org/T367415 -- Francesco Negri (he/him) -- IRC: dhinus Site Reliability Engineer, Cloud Services team Wikimedia Foundation _______________________________________________ Cloud-announce mailing list -- [email protected] List information: https://lists.wikimedia.org/postorius/lists/cloud-announce.lists.wikimedia.org/ _______________________________________________ Cloud mailing list -- [email protected] List information: https://lists.wikimedia.org/postorius/lists/cloud.lists.wikimedia.org/
