What we did
Pythian completed a small-scope proof of concept (POC) for Transat that proved replicating data from their Microsoft SQL Server to Google BigQuery was achievable. During the POC, approximately 10 percent of their total data landscape was replicated successfully to BigQuery using a simple data ingestion pipeline.
Pythian also installed and configured Enterprise Data Platform (EDP) QuickStart for Google Cloud to integrate, clean, and organize Transat’s data into Google BigQuery and quickly make datasets available for marketing analytics reporting. Pythian also built a pipeline using Google Cloud Build to manage organizational policies, folder structure, audit log configuration, and access at the organization and folder level.