Simple and Powerful
October 05, 2020
Simple and Powerful
Score 7 out of 10
Vetted Review
Verified User
Overall Satisfaction with Matillion
Matillion is being used only by data engineering team, which is part of Data Science department. It's our ETL tool to populate our data warehouse on Snowflake. Orchestration jobs are running on a daily basis and are basis of BI reports, which are used across the whole organization. Except that, it's used to generate new feature sets for data scientist for modelling.
- Super easy to use. Anyone can start using it with very little previous experience.
- Lots of connections available to fetch data from most popular sources available.
- Great UI.
- Not very much scalable. Sometimes there are server shutdowns when it goes out of memory.
- Speed of processing can be improved, but not bad.
- SQL compilation errors are very vague and there is no way to understand what the actual error is. It steals extra time to debug.
- Modifying code and deploying to production is very simple and takes very little time.
- Easy UI and simple flow creation enabled us to create pipelines in a very short time, rather than spending lot of man-power to get to the same level with other tools.
- In the long run, requirements and complexity grow a lot, it might not be the best solution. Perfect for small-medium sized companies.
Within 2-3 weeks from starting Matillion, we had our first simple pipeline in production: extracting data from our operational database and putting it into data warehouse.
At that time, ~3 years ago, none of the competitors were as easy to start using as Matillion. As our team was not so experienced with ETL, Matillion was the best and easiest way to get our hands dirty with defining pipelines.