Periscope Data, a data analysis and visualization company, tested the top cloud-based data warehouse options to better advise customers on which technology to choose. Periscope Data voted Amazon Redshift over BigQuery and Snowflake to win.
“After investigating Redshift and Snowflake, and [Google] BigQuery], we found that Redshift was the best choice for real time query speeds on customers’ typical data volumes,” the company stated in an undated blog post titled “Interactive Analytics” (Redshift vs Snowflake, vs BigQuery), apparently published yesterday.
Periscope is a data analysis platform that uses SQL queries for hooking into databases and data warehouses to create analytic reports. It specializes in data visualization.
Periscope analysts wrote queries on 1 billion rows internal page visit logs to determine the performance of each offering in real-world scenarios. The query weighted in at 150GB uncompressed data. Periscope stated that its customers often work with tens of millions to tens of billions of rows data.
According to the company, it conducted cost/performance data warehouse research with an emphasis on interactive analytics to better assist customers who are looking for assistance in choosing a cloud platform that will work with Periscope’s offerings.
“Our customers want to know where they can get the fastest query times, what data their data warehouse can handle and how much it will cost. “We want to provide the best recommendations to our customers when they ask us for help in navigating the data warehouse space. So we put Redshift and Snowflake to the test,” the company stated.
Periscope went beyond raw performance data and conducted initial run-time testing to determine the fastest possible speeds. Then, Periscope incorporated costs to better serve its budget-conscious clients.
“Bolstered by the warehouse solutions’ comparable performance, we stepped into more queries,” the company stated. While speed is important, budget is the deciding factor for many users. We want to know how much performance is available at different price points.
The company’s report was largely focused on Redshift and Snowflake. Periscope uses Redshift in its own platform, and recently partnered up with Snowflake to help support its warehouse solution on Periscope Data Platform. It also tested against BigQuery which it claimed is used by “a vocal minority of Periscope customers”.
The company also examined the performance and cost of the three offerings.
Redshift is the best choice for technical teams that manage workloads ranging from millions to billions. The company stated in a “takeaway.” Redshift’s pricing model is simple to understand and prevents unanticipated fluctuations in cost. Additionally, query speeds are available at lower prices for daily-active clusters.
Periscope also published a report analyzing the data warehouse management capabilities for the three offerings. However, it didn’t pick a winner in that report.
The company stated that Redshift, Snowflake, and BigQuery all have Web-based consoles that allow you to manage your data, clusters and users, as well as query logging and system analysis. “In this post, we will examine the management consoles of each system as well as the supporting tools to manage your warehouse deployments.
For more information on this analysis, visit the Data Warehouse Management: Redshift and BigQuery post.
