Make ETL/ELT to Redshift easier with Matillion
Matillion ETL for Amazon Redshift is very efficient. I try a few other ETL tools and with Matillion I achieved results effectively with the least waste of time and effort.
It is very flexible and allow parametrize all properties using variables that can change values dynamically - I like it.
Matillion is perfectly integrated with AWS. We can simply manage files in S3 or use SQS and SNS, for more advance task we can use AWS API from Python or Bash scripts.
Matillion is exploiting the power of Redshift to ETL - it is very clever that
transformation use views in Redshift. It results in sensational performance.
Keep it up ! :)