Sign in
Categories
Your Saved List Partners Sell in AWS Marketplace Amazon Web Services Home Help

Trifacta Data Preparation for Amazon Redshift and S3

Trifacta | Trifacta Data Preparation 8.2.1 for Amazon Redshift and S3

Linux/Unix, CentOS 7.9.2009 - 64-bit Amazon Machine Image (AMI)

Reviews from AWS Marketplace

0 AWS reviews
  • 5 star
    0
  • 4 star
    0
  • 3 star
    0
  • 2 star
    0
  • 1 star
    0

External reviews

108 reviews
from G2

External reviews are not included in the AWS star rating for the product.


    Retail

DataPrep: Handy tool for Data Management and Data Quality

  • July 17, 2020
  • Review provided by G2

What do you like best?
Easy to set up
Easy to start with
Easy to perform easy tasks
What do you dislike?
Not an ETL, even if it can cover some ETL uses
Limited scheduling options
Not easy to transfer flows between environments as you have to remap each table
What problems are you solving with the product? What benefits have you realized?
Transform and transport data stored on BigQuery database


    Bhavani Priyadarshini J.

User friendly tool with lots of scope for improvement

  • July 17, 2020
  • Review verified by G2

What do you like best?
The ease of loading unclean data into bigquery. Different formats & edits can be made while loading. The feature to show the number of records that don't align to the type of data makes it extremely useful.
The scheduling feature that runs seamlessly.
The multiple different output & input formats & locations.
What do you dislike?
When the number of unclean records are shown, there needs to be a way to view just these and be able to correct each of them or have a feature of make edits for specific records.
There needs to be a way to notify when there is an error, an email to the owner of the flow.
Default access to all the workflows within the organisation, instead to needing to share them one by one.
What problems are you solving with the product? What benefits have you realized?
Loading Data into BigQuery. The tool is extremely user friendly. BigQuery's native data upload functionality is very basic and extremely hard to debug in case of errors.
This tool is not available on Safari.


    Terry S.

Trifacta - importing into Bigquery Sandboxes

  • July 16, 2020
  • Review verified by G2

What do you like best?
Trifacta is easy to pick up and play, to import, cleanse data and export to another system (in our case Bigquery) is really simple and intuitive. The tool's suggestion on data cleansing options is spot on as well.

For a cloud based system data uploads incredibly quick.
What do you dislike?
Lacks some of the functionality of rivals such as setting up a joint workspace, although flows and dataset can be sent to others it would be great to share some sort of project with colleagues.
What problems are you solving with the product? What benefits have you realized?
Working in a 100+ year old business that has a habit of acquiring smaller businesses and then requiring reporting in one location, and with Bigquery, one table, Data Cleansing and transfers is a big part of my job. Trifacta is useful to analyse massive datasets from POS systems that possible haven't had the resource behind them before to standardise.
Recommendations to others considering the product:
Probably the easiest pick and play option for ETLs


    Hospitality

Cloud dataprep works very well for the applications I need it for!

  • July 16, 2020
  • Review verified by G2

What do you like best?
The automatic data profiling is my favorite feature
What do you dislike?
It can be a bit clunky and unintuitive to use at times
What problems are you solving with the product? What benefits have you realized?
I've used Trifacta as the transformation layer in an ELT process. It was easy to spin up and use


    Wholesale

Powerful but too much crashes since the recent update. Too complex in terms of rights.

  • July 16, 2020
  • Review verified by G2

What do you like best?
Managing datas from Bigquieries and reinject datas
What do you dislike?
sampling and also the time for doing recipes et sampling.
What problems are you solving with the product? What benefits have you realized?
Manage data in real time


    Jean-Baptiste G.

Easy-to-handle ETL for data cleanup

  • July 15, 2020
  • Review verified by G2

What do you like best?
The tool is easy to use, without having to code, and without having to read a lot of documentation. Everything is quite intuitive.
Most of the needs for splicing, transformation, standardization are covered.
What do you dislike?
Sometimes the tool is a little slow. Also the price model is likely to evolve towards something much less affordable.
What problems are you solving with the product? What benefits have you realized?
All the sales data from our e-commerce website are gathered together with our shipping invoices, in order to calculate with BigQuery and Datastudio the real profitability of our business.
Recommendations to others considering the product:
Becareful about the pricing in the future


    Simon O.

Powerful but heavy and slow

  • July 15, 2020
  • Review verified by G2

What do you like best?
All transformation possibilities.
Scalable infrastructure.
GCP integration.
What do you dislike?
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.
What problems are you solving with the product? What benefits have you realized?
Importing many sources and large amount of data.
Auto detect columns and data type from input data.
Automatic job run.
No coding system.
User centric.
Recommendations to others considering the product:
It's a really good product to import in a fast and simple way raw and unstructured data like csv, json, avro.


    Joshwin L.

Trifacta is one of the best Data Preparation tool available & now it is implemented on cloud too.

  • July 15, 2020
  • Review provided by G2

What do you like best?
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.
What do you dislike?
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.
What problems are you solving with the product? What benefits have you realized?
I'm using it for my work. Creating & preparing the data for Analysis. Importing data from Buckets & BigQuery after preparing exporting it as .csv file.


    Rubens B.

A Very Productive Tool

  • July 15, 2020
  • Review verified by G2

What do you like best?
the possibility of analyzing each variable separately and, together with the others.
The generation of graphs directed to certain parameters is also very interesting.
What do you dislike?
The operational procedures for preparing and generating the workflow is somewhat confusing. I usually spend a little time trying to understand what is being done.
What problems are you solving with the product? What benefits have you realized?
I am working with a medical tourism data analysis. Identifying parameters and making inferences. So far, the work has gone well.
Recommendations to others considering the product:
The software is very good and worth testing and using. He really delivers what he promises.


    Paolo M.

Data wrangling using scheduled jobs

  • July 14, 2020
  • Review provided by G2

What do you like best?
Dataset insights are really useful especially when you need to discover data distribution between dataset features. Usage can be learnt by no technical people.
Job are monitored in a very simple way using dataflow UI.
What do you dislike?
No sources despite gstorage and big query. Lack of udf transformations
I can't specify max number of workers in job creation.
Apache beam version is not the latest one.
Some jobs making use of views stopped working without any clear reason.
What problems are you solving with the product? What benefits have you realized?
Trifacta solves the problem of creating scheduled jobs to process historical data creating an aggregated view of them. We also used trifacta to run big query ml algorithms.
Recommendations to others considering the product:
Use trifacta to perform easily data transformations on large datasets allowing not technical users to performs this kind of tasks