Every new enterprise solution introduces a multitude of problems. For the enterprise, the solution that has introduced the most complexity to the business has been cloud transformation. According to IDG, 73% of organizations have at least one application, or a portion of their computing infrastructure already in the cloud, while an additional 17% plan to do so within the next 12 months. A majority of these companies are migrating analytical workloads to cloud platforms like Snowflake, Google BigQuery and Amazon Redshift, from traditional data platforms like Teradata, Netezza, Oracle and Vertica.
While the cloud promises enterprises incredible cost and performance benefits, decision makers still must weigh which platform offers the best solution to achieve their analytics goals and how to adopt the cloud without disrupting the day to day functions of the business.
How Ebates Seamlessly Migrated to the Cloud
Ebates, a $10 million member cash back and shopping rewards company, was recently faced with these decisions as they undertook a cloud transformation journey. Ebates’ ultimate goal was to arm all of their employees with the ability to derive insights from their company data. Ebates originally implemented AtScale to utilize its virtual OLAP capability to performantly analyze data stored in their Hadoop data lake. While the AtScale solution provided the query performance and optimization they were looking for, the Hadoop cluster’s physical limitations to successfully execute 1.5 million queries per month quickly emerged. As a result, Ebates’ Director of Analytics, Mark Stange-Tregear, decided to adopt Snowflake’s cloud data warehouse on top of Amazon S3.
Ebates’ business analysts drive their analytical dashboards and reporting through Tableau. With Tableau, analysts are given the freedom to either write their own SQL queries or simply use Tableau’s drag and drop data analysis. When the decision was made to migrate to the cloud, it was imperative to complete the transformation without disrupting the day to day analytics functions of the business.
Ebates relied on AtScale’s Virtual Data Warehouse to overcome all of their cloud transformation obstacles while delivering added value to their new analytics investments. Because Ebates’ business intelligence applications were already connected to AtScale, migrating their business logic and applications to Snowflake was the easiest part of their cloud transformation. Ebates simply repointed AtScale from their old Hadoop environment to Snowflake. Analytics users never noticed any downtime and saw a significant improvement in query responsiveness.
AtScale’s Virtual Data Warehouse also helped Ebates to streamline its data on Snowflake. With AtScale, Ebates was able to deliver a single, virtualized view of their data that could easily be consumed by business analysts. Ebates was also able to take advantage of the automated intelligent aggregates created by AtScale’s Virtual Data Warehouse. AtScale’s intelligence analysts enabled data requests to only query relevant data, shortening response times and economizing computing resources. Finally Ebates’ business users and data scientists were able to use AtScale’s user friendly design tools to quickly build queries that would allow them to explore the data within Ebates’ data warehouse, without the need to write complicated SQL scripts.