Merge to scale code-first, GUI-driven data transformations by $26 million

Today, data warehouses are crucial for decision-making. They have grown significantly over the years and help companies bring together information from different source systems, such as traditional on-premises platforms, for historical and trend analysis. But consolidating data in a data warehouse is not enough to achieve that. The information must also be converted into a consumable format.

There are plenty of options for data transformation, but each has its own limitations. For example, legacy wizards or widget-based GUI tools are simple to use, but rigid and unable to handle complex transformations at scale, while code-first transformation solutions are flexible, but require mountains of manual work and a significant amount of technical resources. .

Coalesce brings the best of both worlds

To fill this gap, based in San Francisco merging provides a code-first, GUI-driven tool that brings the best of both worlds – without the drawbacks – for managing and building transformations in the Snowflake data cloud. The company today announced $26 million in a Series A funding round.

“Our product solves the biggest bottleneck in today’s analytics by combining the speed of an intuitive graphical user interface with the flexibility of code, plus a healthy dose of automation, to enable rapid data transformations. Coalesce simplifies data modeling, cleansing, management and documentation by bringing unprecedented efficiency and flexibility to the analytics landscape,” Armon Petrossian, CEO and founder of the company, told VentureBeat, ultimately resulting in high-quality data for analysis. and an increase in the productivity of data engineers.

The transformation offering, as the company explained, organizes data in an easily accessible and readable way. It is powered by a column-aware architecture that uses column names and mappings to easily manage transformations with insight into how the data is related or connected. Plus, there are data transformation automation templates, which users can edit, save, and share to keep everyone in their team on the same page.

“Coalesce provides business users with the extensibility they need to adapt and automate their data transformations in a way that no other technology can. The product’s simple and easy-to-use interface enables data teams to accelerate even the most complex data transformations,” noted Petrossian.

Data Transformation Competitors

While Coalesce claims differentiation with its code-first, GUI-driven approach and automation capabilities, it’s not the only player in the space.

The growing volume of data within the enterprise has led to the emergence of multiple transformation-specific offerings, including: dbt Labs, Matillion, incorta and etleap. Dbt Labsa high demand, especially in recent years. The company’s framework is used by more than 9,000 companies, and sales have grown sixfold in the past year alone.

The CEO of Coalesce did not share the exact growth figures of his company. However, he noted that they have taken on multiple Fortune 500 customers in all major geographies (EMEA, North America, and APAC).

Way forward

With this funding round, led by Emergence Capital, the company plans to invest in its product and ecosystem and gear up for a major surge in demand for data transformation tools.

“Going forward, our mission is to empower organizations challenged by massive amounts of growing data that want to be data-driven and more productive by automating as many transformations as possible. Our mission is to help organizations and people democratize data by providing them with technology that simplifies and automates the most complex part of the analytics workflow,” said Petrossian.