Understanding Columnar vs Row Storage Formats for Data Analytics and Reporting

Shanmukh Sista
Level Up Coding
Published in
8 min readOct 4, 2022

--

If you’ve ever worked on data, reporting or analytics, chances are you’ve already heard of Big Query, Amplitude, Google Analytics, Snowflake, Redshift, and a few other data products. Additionally, you may have heard about Postgres, MySQL, Oracle while developing applications at some point.

--

--