I couldn't really understand how you replaced Mixpanel and other analytics services with Redshift. AFAIK Redshift is optimized for bulk inserts so the micro-batch approach (a few seconds) is not is not optimal and in fact quite expensive. Also the data in Mixpanel is not structured and if you're using JSON in Redshift, you can't take advantage of the columnar storage format which is actually the main point of using Redshift. Do you care to explain how you solve these issues?
Hi,
Alooma uses batch size appropriate to the data volume, the bigger the data volume is, the bigger the batch size will be.
Alooma not loading into a JSON column, but provides mapping UI and transformation layer to in order structure and normalize the data into different appropriate columns, thus leverages the columnar storage properties.