I need to be able to run a monthly total query which I do within druid using the Moving Average Plugin. Unfortunately I don’t see Native Query support in Apache Superset as it uses Alchemy JDBC driver which only supports SQL. Is there a way in SQL to achieve Monthly Total queries?
Using Druid 0.22.1 and Superset 1.4.2
We could potentially solve this by putting a month column in the Datasource during ingestion and grouping on it. I would prefer doing it at query time, though.
I think you could do this in a druid SQL query. If you don’t need to worry about more than one year’s data, you could probably group on DATE_TRUNC(‘MONTH’,__time) AS myMonth (eg).