You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2020/06/12 13:40:45 UTC
[GitHub] [incubator-superset] dolorez opened a new issue #10049: Is there a way to programmatically access query history as available in SQL Lab -> Query Search
dolorez opened a new issue #10049:
URL: https://github.com/apache/incubator-superset/issues/10049
SQL Lab -> Query Search has some preset filters (single user, preset date intervals etc)
Is there a way to programmatically access this data (preferrably through SQL, but anything else is OK too) in order to conduct a more refined search or aggregate usage data?
Example:
select user, count(1) from queries where time between X and Y and user in (A, B, C) group by user
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] rumbin commented on issue #10049: Is there a way to programmatically access query history as available in SQL Lab -> Query Search
Posted by GitBox <gi...@apache.org>.
rumbin commented on issue #10049:
URL: https://github.com/apache/incubator-superset/issues/10049#issuecomment-643690272
Provided you want to give access to users, you may simply expose Superset's application Database to Superset as a data source.
This way the Superset data is browsable in SQLLab. There you can easily address all of the usage and query history and perform custom queries on this data.
However, be aware that the data model of Superset's app database may change during upgrades. The migration is managed by Alembic. It might break existing analyses on this database, as it will not respect the queries that you defined on this data.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] dolorez commented on issue #10049: Is there a way to programmatically access query history as available in SQL Lab -> Query Search
Posted by GitBox <gi...@apache.org>.
dolorez commented on issue #10049:
URL: https://github.com/apache/incubator-superset/issues/10049#issuecomment-645949049
Thanks!
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] dolorez closed issue #10049: Is there a way to programmatically access query history as available in SQL Lab -> Query Search
Posted by GitBox <gi...@apache.org>.
dolorez closed issue #10049:
URL: https://github.com/apache/incubator-superset/issues/10049
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] issue-label-bot[bot] commented on issue #10049: Is there a way to programmatically access query history as available in SQL Lab -> Query Search
Posted by GitBox <gi...@apache.org>.
issue-label-bot[bot] commented on issue #10049:
URL: https://github.com/apache/incubator-superset/issues/10049#issuecomment-643276363
Issue-Label Bot is automatically applying the label `#question` to this issue, with a confidence of 0.84. Please mark this comment with :thumbsup: or :thumbsdown: to give our bot feedback!
Links: [app homepage](https://github.com/marketplace/issue-label-bot), [dashboard](https://mlbot.net/data/apache/incubator-superset) and [code](https://github.com/hamelsmu/MLapp) for this bot.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org