{"action":"reopened","issue":{"url":"https://api.github.com/repos/getredash/redash/issues/889","repository_url":"https://api.github.com/repos/getredash/redash","labels_url":"https://api.github.com/repos/getredash/redash/issues/889/labels{/name}","comments_url":"https://api.github.com/repos/getredash/redash/issues/889/comments","events_url":"https://api.github.com/repos/getredash/redash/issues/889/events","html_url":"https://github.com/getredash/redash/issues/889","id":139064031,"node_id":"MDU6SXNzdWUxMzkwNjQwMzE=","number":889,"title":"Alerting/visualizing on row counts rather than just field values","user":{"login":"tsibley","id":79913,"node_id":"MDQ6VXNlcjc5OTEz","avatar_url":"https://avatars2.githubusercontent.com/u/79913?v=4","gravatar_id":"","url":"https://api.github.com/users/tsibley","html_url":"https://github.com/tsibley","followers_url":"https://api.github.com/users/tsibley/followers","following_url":"https://api.github.com/users/tsibley/following{/other_user}","gists_url":"https://api.github.com/users/tsibley/gists{/gist_id}","starred_url":"https://api.github.com/users/tsibley/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tsibley/subscriptions","organizations_url":"https://api.github.com/users/tsibley/orgs","repos_url":"https://api.github.com/users/tsibley/repos","events_url":"https://api.github.com/users/tsibley/events{/privacy}","received_events_url":"https://api.github.com/users/tsibley/received_events","type":"User","site_admin":false},"labels":[{"id":275841237,"node_id":"MDU6TGFiZWwyNzU4NDEyMzc=","url":"https://api.github.com/repos/getredash/redash/labels/Feature%20Request","name":"Feature Request","color":"d4c5f9","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2016-03-07T19:06:58Z","updated_at":"2018-12-08T02:37:26Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"It'd be great to have alerts which could trigger when the number of rows a query returns crosses a certain threshold.  This would better support queries which return “suspicious” rows that need further investigation by a human.  Currently to accomplish that, you basically need two queries: one for actually grabbing the data (that the human can look at) and one for triggering the alert which just aggregates the first with `count()` (or does something clever like inspect redash's own metadata about the first query).  With two queries, there's lots of potential for divergence over time.  You can also hack it by including a window function in your select list (such as `row_number() over ()`) and alerting on that, but it's kinda ugly.\n"}}
{"actor":{"display_login":"deecay"}}