Using redshift for metrics, mostly OLAP. Think about drilldown to 3 level, based on device, os, placement, country, ISP etc... along with click stats per varia

Using redshift for metrics, mostly OLAP. Think about drilldown to 3 level, based on device, os, placement, country, ISP etc... along with click stats per variable. I've never used elastic search for this. Before that used bigquery but every query takes atleast 2 seconds. So we had to move to a dedicated redshift cluster.