Comment by buremba

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?