Experience the ETL with Matillion
March 25, 2024
Experience the ETL with Matillion
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Matillion
We use Matillion ETL (extract, transform, and load) with Bigquery to transform customer data to a standard format. There are 100+ sources and file formats are different. We use Matillion to transform these files and apply business logic to create and store it in a standard format which can be used by downstream and we deal with terra bytes of data on a daily basis.
- The jobs logging UI is very unique and helps in easy debugging
- It has a proper hierarchical structure. One can easily organise projects and related pipelines
- Access control and sharing necessary access is easy and quick
- I have seen good performance even with complex pipelines
- More features should be available with Git integration such as passing environment variables, schedules from git
- Need improvement in parallelism of job runs
- Sometimes cancelling a job gets stuck which can be improved
- We have seen 50 GB of complex data being processed in an hour which is an improvement for us
- Minimal time in creating pipelines in less than 4 hours
- Can handle large files, we had a scenario of 1000 files in a run
I have installed Matillion from the start. To deploy it in Google platform it took me 2 weeks of time as I was very new to the tool. Once the instance is available, to create project, GCP credentials and GIT setup, it may take a day. Finally creating a sample pipeline and to test it will be a matter of minutes
Better UI, logging, minimal configurations, easy previews and faster
Do you think Matillion delivers good value for the price?
Yes
Are you happy with Matillion's feature set?
Yes
Did Matillion live up to sales and marketing promises?
Yes
Did implementation of Matillion go as expected?
Yes
Would you buy Matillion again?
Yes