Enabling Change

BigQuery is the primary data lake solution for State Auto Insurance Companies ("State Auto"), offering substantially faster query times for employees compared to its previous data lake solution within Netezza. For instance, an 800GB query that previously took three hours on the company's legacy solution can now be executed in seven minutes.

The performance gains from BigQuery and Google Cloud Platform allow actuaries to efficiently evaluate and process customer insurance policies, leading to additional opportunities for revenue and customer growth. Cloud Dataproc provides auto scaling and manages Apache Spark jobs, while Cloud Storage offers a unified back-end location for internal data. This in turn helps State Auto use its resources efficiently without sacrificing performance.

By moving to Google Cloud Platform, State Auto benefited from simpler platform management resources, reduced costs, and improved data security for high-value customer information. Having its platform hosted on a single location eliminates data siloing, simplifying its IT architecture and allowing the company to explore machine learning applications to further advance its analytics abilities.

Google Cloud Premier Services Partner Datametica played a vital role in the data warehouse migration process to BigQuery, helping to seamlessly implement the new processes and technologies without disruption. Datametica continues to support State Auto in its endeavors and its move to the cloud for data management and analytics capabilities.

"After moving to Google Cloud Platform, we've seen query times go down from hours to minutes. From an IT standpoint, these types of material gains are exciting and make it easy to see the upsides of migrating to Google."