A very convenient platform for data wrangling. I love the detailed features available to fine-tune the data, like "remove leading and trailing white spaces / quotation marks", "split columns on delimiters", data joining (inner & outer) etc. that are not usually available on regular spreadsheets. Review collected by and hosted on G2.com.

Sometimes transferring data can be a little difficult. The split columns on multiple delimiters did not work too well sometimes. It's not very easy to understand the flows that are created while dealing with several datasets.

While scrolling through the data, it can be a little tricky to get a good overview of the data. Review collected by and hosted on G2.com.

Trifacta is a software used by data analysts, scientists & engineers like me. To be honest, I thoroughly enjoyed the process of data preparation while using this tool since it works smarter and faster as compared to other tools. Besides, the need for accurate and deep insights out of raw and messy datasets is something that can help the growth of the business. Using Trifacta makes the preparation of data efficient at the initial stage by obtaining deep insights. Review collected by and hosted on G2.com.

Limitation to edit each cell. In Excel, editing each cell makes it easier, but in the case of Trifacta, there is a limitation to edit a cell individually. Review collected by and hosted on G2.com.

How easy it is to create a data processing pipeline. The UI is very smart, although it sometimes freezes a little bit. The ability to see what each transformation would do to your data helps a lot. Review collected by and hosted on G2.com.

It's difficult to share any project with other accounts. It would also be ideal if there was a way to edit workflows you have exported. That way, one could export from one account, edit with a simple text editor the resulting JSON (or even make a script for that) and then import into another account. For us, that we work with several clients, each with a different account, it would make our lives easier.

The whole "checksum validation" is a pain in the ...

Also, the new price model for the future years will make the solution impossible to use for some companies (probably mine included) Review collected by and hosted on G2.com.

Numerous of features & functions available which can be used easily. We can easily import many type of files, and also export the prepared flows for Data Analysis or for other uses to other Google Platforms like BigQuery or Cloud Functions. Huge flows will run within few minutes. Fast response from the support team for every queries & also work hard for solving the issues soon. Provide regular updates once or twice a month. Review collected by and hosted on G2.com.

When it comes to cloud there are some limitations now such as some performance issues. But they are improving it day by day by adding more features. The exported flow format is unique for Trifacta so we cannot open with other similar tools or we cannot convert it to other format. There is some slowness experiencing in the User Interface of Cloud Trifacta. Review collected by and hosted on G2.com.

We use this for transferring a medium amount of data daily from avro files. The transformation rules and macros are very powerful---this is a good way of importing data into BigQuery without having to write the transformations programmatically. Review collected by and hosted on G2.com.

The UI is fine for setting up a few transformations and scheduling them, but it's tedious when you have to set up 10 or 50 of them. If I could script the setup I'd probably rate Trifacta a 10. As it is, it takes several minutes per table to click, click, click your way through the procedure.

There are also a few minor UI shortcomings---e.g. you often end up with the wrong number of parameters in the last step of setting up an export, but it doesn't always tell you which ones they are, so you have to go all the way back and try again.

Also, it would be great if it was compatible with more databases and flat-text formats. But it sounds like this is on the roadmap. Review collected by and hosted on G2.com.

The integration with Google cloud makes it so easy to transfer files back and forth. The best part about the tool is its data visualization on top of each column that makes it easy to identify the parameters. The easy to use User Interface is also something I like the most. Review collected by and hosted on G2.com.

Limitation to not use SQL queries and also the limitation to individually select a specific column and edit it like Excel. Lacking the Highlight duplicates feature. Review collected by and hosted on G2.com.

You can see a preview of the data cleaning and processing rules you setup

You can schedule runs and output the data to different destinations, including BigQuery database

Many pre-set rules to apply in one click

Able to work with huge volumes of data Review collected by and hosted on G2.com.

There is a limit of how many rows you can see in the sample, the limit is quite big but in some cases you are not able to view all special cases and can miss handling them Review collected by and hosted on G2.com.

Simple to start , logical to use.Easy to follow the logic of someone else's flows. Easy to correct and go back to the previous steps. Add/delete the wrong transformations. Easy to automate the data preparation. Review collected by and hosted on G2.com.

Performance sometimes but rare. It looks like when it was some release of the DataPrep on Google Cloud - there were some performance challenges. Review collected by and hosted on G2.com.

All transformation possibilities.

Scalable infrastructure.

GCP integration. Review collected by and hosted on G2.com.

Interface is too much heavy and very slow.

UX bad design like the horizontal scroll that sometime slide the columns and sometime back to the previous windows : That's makes me totally crazy!!

Slow system for small data set.

Expensive for small data set manipulation.

Documentation : is sometime hard to find appropriate solution or expected support. Review collected by and hosted on G2.com.

Google Data Prep data has been extremely useful in terms of data cleansing and harmonizing the data with recipes. In the recipes we find it useful to analyze the data quickly and recognize errors in the data. Given we work with several different clients across several different industries that come to us with a host of data issues that we have to clean before we can get quality datasets into our database this tool has cut down a lot on that prep time. The feature that I find most useful is the unpivot feature, this tool has probably saved me 3.5 hours of work each week. This tool has also cut down on the SQL work and skill sets required to do the work. Review collected by and hosted on G2.com.

There is incremental logic that i have not been able to get Google Data Prep to pick up on so that i can stream line the data process as much as i want and therefore have to do some level of prep outside with Tableau. Recently we have been working with US Facts data that adds a new date column for new COVID cases or deaths each day ( with date as a column header), and we were not able to use Google Data Prep to pick up on the logic and adjust the recipes to handle this type of file that has new column additions each day. Review collected by and hosted on G2.com.