We need near real-time but the query runs every hour

Knowi supports two modes per query:

1. scheduled (run query every n minutes/hours, etc), or
2. direct (realtime)

It can be found in the Warehousing Strategy section at the bottom of the query page and will execute queries against your database in real-time: http://recordit.co/rMwPL6l4gL