Q: do you know any presto connector for osquery?

Is the intended outcome to be able to SELECT tables that live in a database outside of osquery? You can create an extension that 1. connects to your database 2. enumerates the tables 3. creates a new table plugin for each discovered table 4. when a query happens in the extension, it is forwarded to the external database

I am think alternative of https://www.kolide.com/fleet which I write a query, send to presto, it connects my machine(s)' osqueryd and response live data

I don't think anything like that exists. You could implement it using the same APIs that Fleet uses.

got it, thanks 😄