Skip to main content

Matillion ETL for Snowflake on GCP, AWS, and Azure: Data Transformation for Your Multi-Cloud Strategy

Announcing Matillion ETL for Snowflake on GCP oWhen it comes to data computing and storage, businesses are always looking for new technology and efficiencies. Cloud data warehouses (CDWs) are at the forefront of revolutionizing the way modern businesses store, query, and transform their data. In our recent research with IDG, we found that 90% of responding enterprises are using a cloud data warehouse (CDW). Furthermore, recent research from IBM found that by 2021, 98% of companies plan to use multiple hybrid clouds. This is because businesses are looking for the best in breed solutions, security, and continuity when it comes to their data analytics technology stack. 

Matillion ETL supports Snowflake on GCP

In response to unprecedented market demand for more cloud options, Snowflake has launched its data warehouse on Google Cloud Platform (GCP). Matillion is thrilled to announce that alongside Snowflake, we are launching Matillion ETL for Snowflake on GCP. 

 

Matillion’s award-winning data transformation solutions are purpose-built to work with Snowflake on all major cloud platforms–GCP, Amazon Web Services, and Microsoft Azure – bringing our customers never before realized simplicity, speed, scale, and savings. 

 

Matillion ETL for Snowflake on GCP: Supporting a multi-cloud strategy

 

In addition to cloud-native functionality out of the box, Matillion ETL supports multi-cloud architectures. For several years, organizations have maintained a hybrid model of on-premises databases and cloud solutions.

However, as more companies adopt a multi-cloud strategy, they are retiring on-premises databases and replacing them with cloud alternatives. And using different cloud warehouses and platforms together increases flexibility and introduces cost-efficiencies into data workflows. Matillion ETL can be a critical component of a successful multi-cloud strategy.

Leverage both Snowflake and Google services

 

Matillion ETL for Snowflake on GCP employs the same great technology as other Matillion products, so users can really get the full advantage of cloud computing technology. Users can access all their data sources using more than 80 pre-built connectors or our universal API connector. Simple code-optional transformation components can be combined to create complex transformations to change that data into meaningful information for decision making. 

 

From within Matillion ETL for Snowflake on GCP, users can take advantage of a mix of Snowflake and Google services. For example, a user can: 

 

  • Build responsiveness into their data loading jobs by scaling up their Snowflake warehouse to run a large query, and then scaling back down with Snowflake’s ‘Alter Warehouse’ functionality–all within an automated Matillion orchestration job.
  • Monitor ETL job success with alerts and notifications using Google’s native Pub/Sub messaging service, ensuring that business critical data is where they need it when they need it.  
  • Use Google Cloud Functions to command-and-control Matillion ETL via its comprehensive API to run event-triggered jobs in response to events inside of GCP, such as an object being created on Google Cloud Storage.
  • Access data in any cloud storage area (Amazon S3, Azure Blob, Google Cloud Storage bucket) using Snowflake External Stages and Matillion’s flexible SQL component, which enables a multi-cloud strategy by closing data silos. Additional functionality to simplify multi-cloud data transfer coming soon. 

To get started with  Matillion ETL for Snowflake on GCP,  head to the GCP Marketplace for a free trial

To learn more and see the product in action, book a demo

The post Matillion ETL for Snowflake on GCP, AWS, and Azure: Data Transformation for Your Multi-Cloud Strategy appeared first on Matillion.