Coalesce.io Reviews

I have chosen Coalesce.io to replace PowerCenter, and we are doing the ELT work for VodafoneZiggo with the help of Coalesce, which provides a way to streamline and standardize our working process.

For VodafoneZiggo, we have created templates from data ingestion, starting from data ingestion through exports, which we provide to downstream applications as a file. When I need to onboard a source in VodafoneZiggo or in our data warehouse, we use a data ingestion template that we have created which can read files from S3, whether XML, JSON, or CSV. Using that template, we can load the data into Snowflake, and then when the data is in Snowflake, we load the data using another three templates of Data Vault: hub, link, and satellites. That is our warehouse where we store the data for years, and from there, when the data is loaded, we load the data into our business data vault, which has another three templates that we have created for users to use. Finally, when the data is in the business vault, we load the data into Data Marts, which are dimensions and facts. If someone wants to give a file to a third party or within VodafoneZiggo, we have created export templates that can be used to export the data into a file. The advantage of Coalesce.io is that if a company has a good naming convention, a lot can be done under the hood in the template, and developers have to do very minimal work on the template, so there are fewer chances of making mistakes or typos.

Regarding my main use case with Coalesce.io, I would say the APIs are really helpful in retrieving log information and dumping it into Snowflake. We are looking for those APIs to create nodes in bulk, which helps us in migrating simple mappings of PowerCenter into Coalesce, and the advantage of Coalesce.io is the bulk edits that we can do at the node or column level. For example, if we want to change a column end-to-end, we can just do a bulk edit and replace the source with a new source. I also appreciate the column level lineage; if the developer fills in the source column correctly, you can see the usage of that column along with the transformation from the ingestion node to the export node. If there is any change in the middle of your pipeline, you can easily find out where the change will impact and who will be impacted by it. The introduction of the SQL node is a game-changer, at least in VodafoneZiggo, because many SQL enthusiasts can simply write their SQL, and based on the template, it will create the mapping grid, map the data type, and create a table or view based on the template we have set behind it.

The best features Coalesce.io offers in my experience include lineage, which is the most important from the Ziggo perspective, and the APIs, which I would rank as the second most valuable. The third feature is the bulk edit option, so we don't have to do repetitive tasks again and again. The new SQL feature they are introducing, where you can dump your SQL and have your table or view created without manually creating columns, is also valuable. These are the four features I appreciate the most, and the fifth one would be the recently implemented GUI change where you can put a node in a spotlight to see the upstream and downstream based on what you need, setting up the depth and those settings.

Coalesce.io has positively impacted my organization by reducing our development time and the time to market from around 15 days to a couple of days. This is the biggest impact we have experienced, and we are able to enforce a standardized way of working among developers, eliminating silos or customized solutions that developers create for themselves. If a satellite is loaded by ten different processes, all ten different processes generate the same type of SQL, making it easier to debug later if someone new joins the team. Additionally, since it is a SaaS solution, there is no need to maintain any software or install anything on laptops, which has helped us at VodafoneZiggo. Another feature is the API feature and the CLI command tool, which aid us significantly in moving from PowerCenter to Coalesce, enabling the migration of mappings from PowerCenter to Coalesce in bulk.

Coalesce.io can be improved regarding the APIs that still do not support all types of scenarios within a node, which is a blocking issue for us and potentially for other companies as well. If they could strengthen their APIs, that would help. The SQL node I mentioned can also be improved, as there are some issues or features that need refinement. Furthermore, the GUI can still be somewhat cluttered, and there could be more filters available in the deploy section to filter jobs and search for different jobs.

I have been using Coalesce.io for almost two and a half years.

I chose a rating of seven because the aspects VodafoneZiggo wants to achieve, such as customization, a standardized way of working, templating, lineage, and customer support for Coalesce have improved, particularly with the addition of new features which were quite slow in 2025 but now are more proactive and useful. Another thing I should mention is the AI part, which is improving. Coalesce.io's Co-pilot has evolved significantly from the first version to the current one, but there is still a need for improvement, such as losing context and other issues. The AI Co-pilot could be noted as a sixth feature that I appreciate about Coalesce.io, as it handles basic tasks if I give it an example.

Regarding Coalesce.io's AI capabilities, I would rate the accuracy and reliability of the output from Co-pilot at about 60 percent because it sometimes hallucinates or gives a different answer for the same question. Therefore, I would estimate it at 60 or at most 70 percent.

I don't have specific numbers or costs because I don't look into that part, but I can say, for example, that when transitioning from PowerCenter to Coalesce.io, initially we would estimate it would take one sprint, around 10 working days, for one developer to create one hub link and satellite. When that developer started working on Coalesce.io, he finished in a couple of days or at most three days, including testing. Thus, I would say we saved about 70 percent, as one developer booked for 10 days eventually had an extra seven days for other tasks.

From the governance and security perspective, Coalesce.io looks good from a user standpoint. However, we haven't yet explored the MCPs and those aspects of Coalesce.io; we are just using the inbuilt Coco. By nature, Coalesce.io is a metadata tool, so there is not too much worry until we start using MCP servers extensively, which we plan to do in the near future.

If you want to standardize your ELT process and are more into SQL-related tasks, then I think Coalesce.io can be your way forward, as it offers low-code development and allows you to define your path for your organization. In such scenarios, Coalesce.io can be a good choice, but I haven't yet explored whether Spark can be utilized or if those functionalities are feasible using DataBricks.

I believe our relationship with this vendor is just as a customer; I don't know if we have any other business relationship such as a partner or reseller. My overall rating for this product is seven.

My main use case for Coalesce.io is creating flows, tables, and views that model dependencies from source to target. I created a flow from ADF to Snowflake, and from that Snowflake instance, I created flows for both the stage layer and target layer. I created curated and consumer layers to feed Power BI reports from the stage schema, which was built using the raw data vault model with tables and views.

Coalesce.io's primary value for me is creating the transformation layer. Using this capability, I created stage tables and target tables. This has allowed me to avoid creating stored procedures in Snowflake and managing process timing, which has helped reduce costs and dependencies. I create jobs in Coalesce.io, monitor my flows, and provide outputs to downstream consumers.

The best features Coalesce.io offers in my experience are metadata-driven code generation, column-level lineages, and user-defined node types with Git-native GitOps. I have used all of these features in Coalesce.io.

When using Coalesce.io with Snowflake API and CLS, I created SCD Type 2 mechanisms and implemented column-level lineage. This has been helpful for metadata-driven processing into Snowflake's processing layer. The Git-native driven features have also been beneficial.

Using Coalesce.io, I have reduced my transformation process and eliminated macros that were previously used, creating reusable programs that are helpful for other projects and models. This has reduced code dependencies between teams. I have saved approximately three hundred to four hundred dollars per day in processing costs.

Coalesce.io could be improved from the stage layer perspective. It would be helpful to have the ability to drag code and write tables with dependency lineages displayed, especially to show which objects are involved in downstream dependencies. This would be beneficial for business analyst teams and data scientist teams so they can analyze stakeholders and customers can see the relevant data without needing to involve multiple teams.

I have been using Coalesce.io for four years and onwards.

Coalesce.io is stable and has very useful lineage capabilities.

The scalability of Coalesce.io is based on data volume handling. Data volumes can be huge depending on different countries' data sources. We are handling approximately one to two terabytes of data processing. Sometimes processing takes time, but we consider stateless services, data protection, caching, query response time, and data latency when using Coalesce.io.

Customer support has been very good for us. Whenever we receive any issues, we reach out by submitting tickets, and the Coalesce.io team approaches our requests by gathering updates and resolving issues as needed. I would rate customer support ten out of ten.

Previously, I used Snowflake-based stored procedures, which took a long time and consumed significant costs in terms of storage and processing. I used Coalesce.io to lineage data from different databases and servers for transformation and then transformed that data into Snowflake as the destination. This approach reduced processing time, costs, and allowed for reusability.

I previously used Data Build Tool as well, which was cost-based depending on project requirements from management. After that, I switched to Coalesce.io for new projects. Since making this switch, I have seen improvements in lineages, dependencies, and formulas needed for my work.

Licensing costs are based on the region. We are using the US region, so charges are determined accordingly.

Because I work with code writing, Coalesce.io has helped me reduce code and create reusable components for other projects. I would rate this capability ten out of ten.

Regarding Coalesce.io's governance and security features, these are good offerings. Hiding columns that are not required for user visualization, implementing roles, and applying masking policies are features that can interact with source systems effectively.

Regarding Coalesce.io's accuracy and reliability of output, this is based on service packs and new modules that find the accuracy of the data.

Coalesce.io is deployed on a private cloud environment that we use exclusively for our data at a secure level. We are using a built-in AI data catalog that tracks lineages across databases, applies data quality measures, and implements data platform-specific logic for columns. These capabilities need to be cloud-based and are running in our private environment.

We are using Snowflake for our private cloud deployment. I would give this review an overall rating of ten out of ten.

My main use case for Coalesce.io is data transformation.

A specific example of how I use Coalesce.io for data transformation is that we have data coming from multiple sources, which resides in Snowflake. We read it, perform some transformations, merge data from multiple sources, and add it into sync tables.

Regarding my main use case and how I use Coalesce.io day-to-day, we use data vault architecture from Coalesce.io, where we have hubs, links, satellites, and other stage tables before moving the data to the final layer of tables.

Coalesce.io has positively impacted my organization by making development faster and keeping the logic clearer, so we do not have to see 1000-2000 lines of code every time. We can go to a specific table and see its logic.

The best features Coalesce.io offers include the stage layer of transformations where we have to do step-wise transformation, which is very helpful. Additionally, when we have all the data within Snowflake, it is very helpful as well. It is very easy to make changes once we complete the development.

The UI is what makes it easier to make changes after development, and version control is very helpful as well. We can directly commit the changes to Git.

One additional feature I would like to highlight is that when we have a lot of sources with similar end logic, we can collate all the source data and then apply the end logic at the end. If we want to add any column or new logic, we can directly add it in one place, which will be applied to all the data for all the sources.

Coalesce.io is very good overall.

I believe the editing should be a bit easier, or there should be a bulk edit option where a column can be added in one go in multiple places.

Sometimes a sub-graph or workflow becomes too heavy. For example, we can have 30-40 nodes or tables in one sub-graph, so sometimes that might be a bit slow or a bit much, but it is still acceptable.

I have been using Coalesce.io for two years.

My advice to others looking into using Coalesce.io is that first, the design needs to be thought out well, and many future things have to be taken into consideration before starting any development. It will be very helpful if we know what scaling we have to do further. I would rate this product an 8 overall.

My main use case for Coalesce.io was with a healthcare provider client whose team was not particularly tech savvy, so we wanted something easy to use. I was debating between two options: Coalesce.io and DBT. Coalesce.io had a GUI interface where I could drag and drop objects and build easily, so I was exploring it for building data vault models.

For that specific use case, I was able to accomplish what I was trying to do during the demo, but we encountered certain scenarios such as post-hooks, update statements, edge cases, or particular SQL query modifications and custom cases that could not be implemented through the GUI interface. Additionally, jobs that were interdependent on each other and orchestration features were not available at that time, which made us reconsider our options and ultimately go with DBT since it was open source and DBT Cloud had all the features we wanted.

I used Coalesce.io to build a data vault model by reaching out to the Coalesce.io team when the initial account provided to us did not have access to packages used for data vault modeling. They enabled a package specific for data vault modeling within the account. In that specific scenario, we wanted to replicate or build a small demo for the client to show them how we could leverage Coalesce.io to build data vault models. In data vault, we have a use case of needing to build multiple objects for creating dimensions and facts with an intermediate layer of hubs, links, and satellites. We used the package provided by the Coalesce.io team, which streamlined the process of creating these objects and provided a template that had all these columns in a particular format. We only needed to enter the column names and drag and drop to create our final model, which was very convenient. However, there were some problems and nuances due to which we went with DBT.

Some of the best features that Coalesce.io offers include the easy graphical interface where I can see the data flow, lineage graph, and how the data is moving from the source to the end target table. It has an easy drag and drop interface so I do not need to write SQL queries. Especially for my use case of data vault modeling, which required a lot of coding, using Coalesce.io would reduce the development process and I could quickly develop models.

Coalesce.io has positively impacted my organization by being a tool that can be leveraged by a non-technical team, especially business analysts who are working on bringing data from different sources. This is particularly beneficial for those who do not prefer coding or want to build their data models as quickly as possible. That is what I would consider to be the best use case for any organization.

Coalesce.io can be improved by making it handle more edge cases and providing better documentation. When I was initially working and trying to find information, there was not much available on their official website. Documentation with screenshots and steps on how to leverage this tool should be developed. An online community was not present either, which would help users deal with any issues or errors they are facing or ask developmental questions related to edge cases that are not generally used. I believe those are some of the things that can help the community of developers using Coalesce.io.

I have been using Coalesce.io for two months for a demo in my previous company.

I cannot think of anything else to add about the features since I used it only for two months, and it has been a while since I used it.

I saw measurable benefits during my demo since I found that the general impression was that I was developing much faster, and the development time was saved significantly. Work that could take me a day could be done in an hour or so, so I believe time saving is the most important factor.

I did not explore Coalesce.io's AI capabilities much, so I cannot provide an opinion on its governance and security.

While I was using Coalesce.io, it was a very new tool and I did not come across its AI capabilities, because it was mostly an open account I was using and it did not have those capabilities at that point in time, which was around last year, probably in 2024. So it did not have many capabilities at that point in time.

I would rate this product a six out of ten.

My main use case for Coalesce.io involves data transformation for the finance company that I have been working with.

A specific example of how I use Coalesce.io for data transformation in my finance company is that we start with the raw layer and engage in all sorts of data transformations, creating different nodes, layer by layer on top of each other, moving from the raw layer to the curated, report-specific views, which helps us adopt a data-driven approach to find the best suitable results.

Regarding my main use case, it is a basic one where we perform all the transformations such as deleting duplicate records, cleaning up transformations, and handling some complex queries, including breaking out the CTEs into separate nodes, which makes it easier to track and debug.

Coalesce.io's best features include its drag-and-drop approach, which is convenient for someone who is not very well-versed with coding. Although it can be hectic for people who have been coding for a while, overall the drag-and-drop functionality makes it easier as it eliminates the need to specify data types repeatedly as it traces back from where it began up to the curated layer, which is handled end-to-end.

Additionally, Coalesce.io is intelligent enough to understand the requirements and work on itself. I have also been using Coalesce.io AI, which is handy when creating new nodes, helping to save nodes, particularly for someone who prefers fewer clicks, where I think AI significantly aids in this sphere.

Coalesce.io AI helps me create new nodes or saves me time by allowing me to interface with it when working for a finance database. For instance, when many changes came in as the client wanted something different than what we planned, I would give the code to the AI and ask Coalesce.io to backtrack and fix it. While it works well for most node creation, when it comes to editing, it sometimes makes mistakes, but I find it really helpful for creating new tables and backing up data.

Coalesce.io has positively impacted my organization by improving workflow, productivity, and business outcomes. For example, the company has been doing well with any data transformations since this is a pretty new use case for them, where they were not very report-based before, but now they actively make use of the reports we provide. Coalesce.io allows some users to track bugs directly when developers are unavailable, making support activities easier for end users with basic SQL knowledge.

A specific outcome I can share is that for a report we created for the marketing team, they used to spend almost three days fixing data and creating their transformations using basic Excel. However, now it is a daily run report curated by data transformation within Coalesce.io, making it easy for them to track and update daily and saving almost two days of work hours for employees.

One improvement I would suggest for Coalesce.io is that it can be pretty slow at times. For example, when I make a change within Coalesce.io and click the debug button, the changes do not always reflect quickly, requiring me to click again to see the updates, which can be frustrating as a developer.

Additionally, while the AI can be helpful in creating nodes, it can sometimes place them unexpectedly, and undoing those changes does not always work as intended, which I consider a negative aspect of using Coalesce.io. I would emphasize that the speed could definitely be improved, and sometimes the drag-and-drop functionality is hectic, particularly when dragging a column rather than a table. It can go null or not pop up at all, and although Coalesce.io does identify if you want to join one table to another based on naming convention, occasionally it fails to recognize this, which is frustrating. Overall the features look good and only need these specific improvements.

I have been using Coalesce.io for almost one and a half years.

Regarding the accuracy and reliability of Coalesce.io's output, I am not entirely sure it is reliable. However, for a developer familiar with their data end-to-end, it is effective, but it is not very reliable for someone without a basic understanding of coding.

My advice for others looking into using Coalesce.io is that I would definitely recommend it for its user-friendly setup, which is manageable for business analysts who may not be very tech-savvy, making it easy for them to navigate. It is an excellent choice for companies needing a baseline setup and where users can take it from there, thus I see Coalesce.io as a strong option. I would rate this product a 7 out of 10.

I use Coalesce.io to implement Data Vault architecture and design ETL in Medallion architecture to achieve good orchestration and utilize features like creating DDLs and ingesting data into other layers. For different sources, I have used Coalesce.io with a Data Vault approach, where I created different satellites, hubs, and links to ingest the data. After that, I created a star schema where all dimensions and facts were created using Coalesce.io.

I create DDLs on the back end using Coalesce.io as a SaaS service. I use Snowflake as a processing tool for querying the data, and the front end uses their Jinja code where all nodes have been created for different domains and use cases. If I need to use the Data Vault approach, I can use the Skillfree packages. If I need to use Cortex, different packages for Cortex are available in their marketplaces. I can simply import their marketplace packages and use them.

Coalesce.io helps me make alterations and updates quickly. I can add transformation logics easily and see how the data is flowing. I can watch the lineage and understand how my data is traversed. Everything I need is available in Coalesce.io.

Creating nodes is more reliable, where all my attributes can easily be copied and I can implement my transformation logics or transform my data from one layer to another in an easy form.

It saves time and development time. Creating an end-to-end pipeline takes time, but with Coalesce.io, it became a time-saving endeavor.

Coalesce.io could improve in their AI features that they have enabled now. From the AI perspective, if I have different semantic models, I could incorporate or orchestrate different semantic models using Coalesce.io. That would be more helpful. If that functionality comes into Coalesce.io, it would be excellent.

If Coalesce.io could bring orchestration between different semantic models, such as in Snowflake where I can have multiple different YAML files, there should be a routing technique in Coalesce.io so I can route my query or my natural language query into the right model.

Every product needs enhancements. No product can be perfect. If Coalesce.io can save efforts and time, that is valuable. Enhancements to the AI side or semantic modeling techniques would surely improve Coalesce.io.

Coalesce.io is a good governance tool, but it can improve in that area as well. By having better data governance practices, improving masking or PII approvals, and integrating all activities related to governance, Coalesce.io can enhance their application.

Coalesce.io saves a lot of time for development. I only have to put my business logic. From a statistics perspective, if I have to create DDLs for four hundred different tables or provide transformations for that, it would easily take three to four sprints, and peer review, testing, and everything else would extend the timeline. Usually it takes six to seven weeks to develop all those things, but with Coalesce.io, I can complete those things in one week.

I have not tested the AI feature much in Coalesce.io, so I am not certain about that capability.

I would surely recommend using Coalesce.io if you want to save your development time. I rate this product a seven out of ten.

Coalesce.io is used as a main platform for developing ETL pipelines.

Coalesce.io allows you to create ETL pipelines in a low-code approach. It natively supports templates for integrating with different systems and is built to deeply integrate with Snowflake.

Coalesce.io is a very complete platform because it also integrates all the tools needed for building CI/CD pipelines and an AI agent to support developers in their activities.

Coalesce.io has impacted our organization positively by providing a low-code approach. It supports different sources, so we don't need to write custom code. It is also a collaborative tool, making it suitable for teams with a large number of developers.

At the moment, the only improvement I see is deeper support for AI agents to support the developer's job.

Coalesce.io is a very complete platform, but it could be an even better product if it supported more developer jobs, speeding up development.

Coalesce.io has been used for one year and a half.

Coalesce.io is stable.

As far as I have seen, Coalesce.io is very scalable. In case of excessive load, we can easily handle it by adding more resources.

When Coalesce.io needs to be updated or maintained, we need to declare the maintenance window. We cannot use the tool during maintenance, but we try to keep maintenance time low to avoid any issues.

We did not use any solution before Coalesce.io. We used a more raw approach for development and deploying on Snowflake. That's why we decided to standardize, improve, and be more efficient with development by introducing Coalesce.io.

The setup of Coalesce.io was not complex, and the licensing is very clear.

We were provided with official documentation and also had some introductory courses and lessons by support.

Unfortunately, I don't have any numbers to share, but Coalesce.io had a very good impact on development and was very appreciated by the development team.

Coalesce.io was purchased through the AWS marketplace.

Different tools were evaluated as far as I know. I did not participate directly in the selection, and I cannot say what other tools were compared.

Developers can share within Coalesce.io.

I would rate Coalesce.io as nine out of ten.

We do not track any metrics at the moment.

Coalesce.io is deployed in a private cloud.

When Coalesce.io needs to be updated or maintained, we must declare the maintenance window. We cannot use the tool during maintenance, but we try to keep maintenance time low to prevent any issues.

I don't have much information about security features.

Coalesce.io offers capabilities that we managed to use, but we also use external tools.

The Coalesce.io integration was planned to be smooth because before it, we used another tool, so we had to migrate what we had on the previous tool to Coalesce.io and then switch off when everything was done.

I suggest Coalesce.io to everyone who wants a collaborative environment deeply integrated with Snowflake that supports developers in their job.

My main use case for Coalesce.io typically involves building pipelines, as I was working in a data migration project where I source data from the source system and move it to the target view using intermediate stages such as stage nodes and dimension nodes.

There was one module for which I had to work, so I created sources for that module, including customer dimensions and raw data for customer sales. Once that data became available from the upstream process, our pipeline started executing, reading data from the raw sources, staging them in stage nodes, and moving it to the dimension node where I created type two dimensions, after which the data moved to the fact node. Once the data was available in the fact node, that data was consumed by the downstream team for reporting purposes.

I have covered my main use case with Coalesce.io.

The best features Coalesce.io offers include the user interface and column-level lineage, which allows me to add an extra column to upstream and downstream stages by clicking on one stage and selecting others to propagate that column, making it easy to manage lineage at the column level. Unlike DBT, which shows only job level or model level lineage, Coalesce.io provides a great column-level lineage feature.

Coalesce.io has positively impacted my organization by making it easy to build and maintain the pipeline, providing traceability, and enabling easy debugging at both the pipeline level and Snowflake level. If I create a node and declare the metadata, I can refer to a specific source, and any issue will be highlighted for fixing there. If there is also a SQL level issue, it is highlighted at the interface, making debugging easy.

Coalesce.io is compatible with Snowflake only, so it must be configured with other platforms such as Databricks and BigQuery, which is a limitation and a drawback.

Coalesce.io should work on the aspects I highlighted, particularly making it compatible with other popular platforms such as Databricks, BigQuery, and Redshift, among other tools.

I have been working in my current field for almost five years.

I chose a rating of seven out of ten because of its limitations with compatibility to platforms such as Databricks and BigQuery, which prevents me from giving it a perfect score. However, it is still a good tool, being easy to implement, maintain, and featuring a good user interface that requires no coding work.

If others are not much interested in writing code or SQL, then they should definitely consider Coalesce.io, which provides a good user interface that is easy to maintain and trace in case of a pipeline failure. With the column level lineage feature, backtracking errors and finding data propagation roots becomes easier, decreasing implementation time significantly. What previously took three months can now be done within four weeks.

Coalesce.io has helped me develop projects faster, as it is easy to implement and maintain, reducing execution time by thirty to forty percent, while also helping me design a modular approach.

I rate Coalesce.io a seven out of ten.

My main use case for Coalesce.io is ETL transformations. I use Coalesce.io to process my bronze layer data into silver and gold layer tables.

The best features that Coalesce.io offers include a very rigid ETL framework that ensures all developers use the same pattern. Coalesce.io has positively impacted my organization because it solves many of the problems of SSIS.

I cannot tell you more about which specific problems of SSIS Coalesce.io solves for me. I do not know that Coalesce.io can be improved. I have no opinion regarding Coalesce.io's AI capabilities, governance, and security.

I have had mixed success with Coalesce.io's AI features regarding its accuracy and reliability of output; sometimes it performs correctly, and sometimes it does not.

I have been using Coalesce.io for four months.

I do not want to add anything else about the features; I do not find anything particularly helpful or something that stands out yet. Coalesce.io is the type of tool I would provide to business analysts for their ad hoc and prototyping purposes. I think it is well-suited for that audience because it provides a rigid structure that will minimize the tech debt that gets produced.

I would rate Coalesce.io overall a six on a scale of one to ten. I choose a six because it is only good for a very limited set of use cases.