On Tue, Jul 2, 2024 at 6:48 PM Francesco Negri fnegri@wikimedia.org 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