Amazon Redshift

Increase Concurrent Connections, decrease ETL run time

September 03, 2019 at 2:40pm

Currently, for each job you run in Matillion, only one connection will be made to the target database- Amazon Redshift,...

What’s new in Matillion ETL version 1.40

August 20, 2019 at 11:16am

Want the very best Matillion ETL experience? Each new version of is better than the last. Make sure you are...

Optimize Amazon Redshift Performance: 5 Top Tips

August 04, 2019 at 2:49pm

WRITTEN IN COLLABORATION WITH SAUNAK CHANDRA, SENIOR SOLUTIONS ARCHITECT, AMAZON WEB SERVICES     Amazon Redshift is one of the...

What’s new in Matillion version 1.39?

June 12, 2019 at 7:13pm

The latest release of Matillion, version 1.39, includes a whole host of new components, new features, and enhancements to make...

mongodb integration matillion bigquery

How to Flatten Nested Arrays from MongoDB with Matillion ETL for Amazon Redshift

April 05, 2019 at 2:14pm

Problem Statement A customer came to us who had lots of data in a MongoDB with many nested elements. Including...

What’s new in Matillion version 1.38?

April 01, 2019 at 3:59pm

The latest release of Matillion, version 1.38, includes a whole host of new components, new features, and enhancements to make...

Matillion AWS Architecture Diagram - General Amazon Redshift

Matillion Architecture – Amazon Redshift

November 26, 2018 at 3:10pm

Your business needs a way to move all your business’ diverse data to a centralized location. Matillion is a data...

matillion etl for amazon redshift 1.35 version release

What’s new in Matillion ETL for Amazon Redshift version 1.35?

October 16, 2018 at 12:03pm

The latest release of Matillion ETL for Amazon Redshift version 1.35, includes a whole host of enhancements, new features and new components...

Grid Variables in a Matillion ETL job to Apply Business Rules

Using Grid Variables in a Matillion ETL job to Apply Business Rules

October 15, 2018 at 11:18am

In this blog, we will show you how to use grid variable to apply business rules in a Transformation job...

Using the Open Exchange Rates Query component in Matillion ETL for Amazon Redshift

October 07, 2018 at 11:32am

Matillion uses the Extract-Load-Transform (ELT) approach to delivering quick results for a wide range of data processing purposes: everything from...