Coalesce

What do you like best about the product?

I like that the UI of Coalesce is great and it's very easy to use. It's also very easy to explain to nontechnical users, which is a big plus. The initial setup is always incredibly easy.

What do you dislike about the product?

I think there could be some documentation improvements. I've been saying for years that they should have some sort of role management tool and a little more documentation on how to create custom nodes and what best practices look like.

What problems is the product solving and how is that benefiting you?

Coalesce solves transformation issues from Snowflake to the reporting layer and is used across numerous projects for our clients' transformation needs.

What do you like best about the product?

I appreciate Coalesce for simplifying the development process by modularizing code into reusable standard and custom node types, which enforces consistency and reduces development time. I like the combination of simplicity and flexibility, as I can quickly start building nodes and prototyping, while also having the flexibility of custom node types for complex use cases. The standard prebuilt node types are easy to use and applicable to a majority of data warehousing use cases without needing much configuration. I find it pretty easy to set up Coalesce - all I need is a simple connection to Snowflake and Git, and I can start working quickly. The documentation makes these configurations easy to follow.

What do you dislike about the product?

In the future it would be great to have additional options and capabilities to work side by side with data modeling tools. For example, being able to use the data modeling tool to create the logical and physical data model, and allowing Coalesce to easily work within the data model that is deployed to Snowflake from the modeling tool rather than having to recreate the facts, dims, etc. directly in Coalesce.

What problems is the product solving and how is that benefiting you?

Coalesce simplifies my development process by modularizing code into reusable node types, ensuring consistency and reducing development time.

What do you like best about the product?

I like the bulk editing abilities the most. A close second is the modular feel when building pipelines.

What do you dislike about the product?

Lack of online courses for features. There are webinars and quickstart guides but sometimes i just need a specific deep dive on node types when I'm building it from scratch for the first time.

What problems is the product solving and how is that benefiting you?

It solves generating code when building out entire data warehouses. I have so many features to pick from for just about any use case I have.

What do you like best about the product?

I like Coalesce for its ease of use and organization, especially how it allows different workspaces for different developers. I also appreciate that all processes are stored in a GitHub repository. It's easy to use and maintain, and deploying and managing jobs and logs is straightforward. The integration feels like working on GitHub from my local machine, but with a nice UI that makes creating and maintaining pipelines and nodes much easier. The initial setup was easy and straightforward, even for those with less coding experience. Additionally, Coalesce provides more benefits and is more user-friendly compared to dbt, which we used before.

What do you dislike about the product?

I would like an easy way to transform current SQL code that contains CTEs into one or many Coalesce nodes without the hard work or amount of time that it requires going into the original code and seeing how you can break that code to fit it in Coalesce nodes. Managing/storing environment and workspace credentials could definitely be improved. There have been many times that I have to go to Snowflake and copy and paste manually different sections instead of maybe having a drop-down menu based on my Snowflake access. Also, many times I have to input my credentials again because they got wiped.

What problems is the product solving and how is that benefiting you?

I use Coalesce to transform data from Snowflake and solve data transformation problems, making it easy to create any tables/views needed and generate reports.

What do you like best about the product?

I've worked with most major data transformation tools over the last 15 years, and Coalesce is hands-down my favorite among them all. We're able to deliver faster data integration, quality, and warehouse projects internally and for our clients because of Coalesce's no-code / low-code interface. What previously would take several data engineers now can be delivered with 1 or 2, and in less time.

Coalesce writes complex transformations for you and with proper best practices, allowing you to stand up an integrated data warehouse in significantly less time. The lineage feature makes it easy to troubleshoot errors and trace the root cause. The ability to propagate columns changes to downstream transformations with a few clicks saves hours of time per task. Using the software development best practices makes deployment fast and reliable. Onboarding new team members is very efficient - if they know SQL and understand data pipelines, then Coalesce is the most effective tool to quickly bring new team members up-to-speed.

It's also flexible enough to easily migrate from other platforms because you can easily drop your code into their AI engine and it will create the transformations for you. Whether it's a new project or moving away from an existing technology, you can implement fast and efficiently.

On top of the tools amazing features, the sales and support team members are the most responsive, knowledgeable, and helpful compared to any other software vendor I've ever worked with.

Lastly, they continue to add new features based on real feedback from customers to ensure we're always getting the best value for our money. Coalesce is easily one of my favorite products.

What do you dislike about the product?

Can't think of any. If we ever have a question or feature request, they're always very helpful in pointing us in the right direction or transparant on when it will be released.

What problems is the product solving and how is that benefiting you?

Coalesce is the backbone for data transformations, data quality, and governance within our Snowflake environment in support of our data products. It also is our go-to tool for deploying strategic data warehouses and data products for our clients in the biotechnology and pharmaceutical industries. It allows us to deliver projects faster, which means keeping overall costs down while also delivering high-quality data to help run our business and our clients' businesses more effectively. At a time when budgets are constantly being scrutinized, Coalesce is one of the tools that continues to stand out because teams are able to articulate and show the value it brings to them, ultimately helping teams cut costs and deliver better quality data to their end users in less time.