Redshift Archives - Cloud Data Integration Software | Matillion
matillion-twitter

Using the Twitter Query Component in Matillion ETL for Amazon Redshift

Matillion’s “Twitter Query” component enables you to extract data from your Twitter account and load it into Amazon Redshift.  The Twitter Query component uses the ETL principle to load data from...

changing your matillion etl for amazon redshift instance size

Upgrading your Matillion ETL for Amazon Redshift instance size

When you first launch Matillion ETL for Amazon Redshift, you must choose which instance size you’d like to use. This is the main factor which determines the hourly cost....

json files redshift matillion 5

Loading JSON Files into Amazon Redshift using the Matillion S3 Load Component

Matillion uses the Extract-Load-Transform (ELT) approach to delivering quick results for a wide range of data processing purposes: everything from customer behaviour analytics, financial analysis, and even reducing the...

salesforce matillion etl amazon redshift

Using the Salesforce Query Component in Matillion ETL for Amazon Redshift

The Salesforce Query component in Matillion ETL for Amazon Redshift presents an easy-to-use graphical interface, enabling you to connect to live Salesforce and Force.com accounts. Many of our customers...

s3-put-object-matillion-redshift

Using the S3 Put Object component in Matillion ETL for Amazon Redshift

The S3 Put Object presents an easy-to-use graphical interface, enabling you to connect to a remote host and copy files to an S3 bucket. This can be used to...

couchbase-data-matillion-etl-for-redshift

How to load data from Couchbase into Amazon Redshift using Matillion ETL

Couchbase Server, originally known as Membase, is an open-source, distributed multi-model NoSQL document-oriented database software package that is optimized for interactive applications. These applications may serve many concurrent users...

google analytics connector matillion etl amazon redshift

Tracking your customer journey using the Google Analytics connector

Matillion uses the Extract-Load-Transform (ELT) approach to delivering quick results for a wide range of data processing purposes: everything from customer behaviour analytics, financial analysis, and even reducing the...

matillion data quality framework

Matillion Data Quality Framework

When you’re using Matillion to build data processing jobs, you are acting as a data consumer. There are upstream systems (probably many) in which primary producers are actively creating...

matillion etl paging data

A Case for Paging

In this article we will discuss Paging in the context of a REST API and how Matillion can help you download data from your REST APIs as manageable chunks,...

ELT lie Matillion

The “ELT lie” and how to get real benefit from ELT architecture

Here at Matillion we have a breadth of customers, from startups to large enterprises, all taking advantage of the Extract-Load-Transform (ELT) approach for delivering quick results. They are using...