Reading Json data file

Helloe

Good day¡

Is it possible to read files generated in Druid? as to analyze with another tool (BI),
Thank you,

FCV

The short answer is yes. Druid provides API based access and JDBC driver that can be used by BI tools like Tableau, etc.

Rommel Garcia

Thanks Rommel,

Ok, is it possible to generate a Json file in a query (sql), to be accessed by url, so consume it?

If I understand it right, you want the result of a query to be in json format? If so you could set the result format in the request payload. See Responses section in this doc https://druid.apache.org/docs/latest/querying/sql. You could use object or array result format as applicable for your requirement.

Thanks,

Sashi