Amazon Redshift vs Snowflake: What are the differences?
Developers describe Amazon Redshift as "Fast, fully managed, petabyte-scale data warehouse service". Redshift makes it simple and cost-effective to efficiently analyze all your data using your existing business intelligence tools. It is optimized for datasets ranging from a few hundred gigabytes to a petabyte or more and costs less than $1,000 per terabyte per year, a tenth the cost of most traditional data warehousing solutions. On the other hand, Snowflake is detailed as "The data warehouse built for the cloud". Snowflake eliminates the administration and management demands of traditional data warehouses and big data platforms. Snowflake is a true data warehouse as a service running on Amazon Web Services (AWS)—no infrastructure to manage and no knobs to turn.
Amazon Redshift and Snowflake can be primarily classified as "Big Data as a Service" tools.
Lyft, PedidosYa, and Zapier are some of the popular companies that use Amazon Redshift, whereas Snowflake is used by Instacart, HousingAnywhere, and Auto Trader. Amazon Redshift has a broader approval, being mentioned in 267 company stacks & 63 developers stacks; compared to Snowflake, which is listed in 27 company stacks and 10 developer stacks.
What is Amazon Redshift?
What is Snowflake?
Want advice about which of these to choose?Ask the StackShare community!
Aggressive archiving of historical data to keep the production database as small as possible. Using our in-house soon-to-be-open-sourced ETL library, SharpShifter.
Data warehouse solution that fully separates compute and storage. Better management facility than directly using S3.