Why people often use a database like Redshift together with an ElasticSearch purely for analytics / reporting queries?
<p>Per the title - I have seen that many companies - especially in ad tech - use a data warehouse solution like Redshift, where they store all the transactional data to do aggregations and analytics, and also pump their data in elastic search for possibly the same reason (not for search anyways).</p>

<p>Apologies if this questions looks daft but wanted to understand the reasons behind this. </p>

<p>Is it to get real-time queries out of one and do historical data analysis on the other? </p>

<p>Thanks</p>