Bennie Health - GCP Data Warehouse PoC

Stewart Smith

Archive article - published on May 12 2023

WALT Labs worked with Bennie to review their existing GCP infrastructure and provide technical recommendations on scaling, security, and choosing the optimal solution for building a data pipeline using Postgres CloudSQL, Datastream, BigQuery, and Looker.

The challenge

Bennie is currently using Postgres CloudSQL. They want to build a data pipeline in GCP to do analytics, reporting, and data visualization. They wanted to build a Data Lake on the best solution using Postgres CloudSQL, Datastream, and BigQuery which is cost-efficient and performance efficient.

The solution

WALT Labs identified and built an architecture plan for the Data Pipeline in GCP. Using Terraform to automate creation and configuration of the Data Pipeline. Furthermore, recommendations were provided on how to improve and manage the Data Pipeline as the business continues to scale and expand on use cases.

The results

Deploying via Terraform, the recommended Data Pipeline in GCP using Postgres CloudSQL, Datastream, and BigQuery has unlocked the capability to use advanced Data Analytics and reporting. Leveraging best practices around Datastream and creating datasets in BigQuery granted the ability to analyze and visualize the data in Looker Studio.

Using the recommended and newly built pipeline in GCP using CloudSQL, Datastream, and BigQuery will improve their performance in data and as well reduce cost. Leveraging best practices around Datastream and creating datasets in BigQuery improves the performance and stability of the current environment.

bennie-health-logo

About Bennie Health, Inc
Bennies come from top benefits firms, technology startups, and insurance carriers to help companies create a healthier workplace.
Industry: Healthcare & Life Sciences
Primary project location: United States

WALTLabs Logo

About WALTLabs.io, LLC

We maximize your business potential with our cloud consulting, products, and 24/7 support.

Products: Google Cloud Platform

Stewart Smith
Share this post

Let’s just have a chat and see where this goes.

Book a meeting