Advanced

Triggering ETL from an S3 Event via AWS Lambda

Overview This example links the arrival of a new object in S3 and automatically triggers a Matillion ETL job to load it, transform it and append the transformed data to a fact...

Using Variables

Overview Variables are name-value pairs stored within each environment. Variables can be used in all sorts of parameters and expressions to allow the user to pass and centralise environment specific configuration. Variables...

Expression Editor

Overview The Expression Editor in Matillion ETL allows the user create expressions in the Calculate and Join components. From the editor, users can browse from lists of available functions and data columns...

Securing Matillion ETL

Overview By default Matillion ETL is users are authenticated against an internal user file however it is possible to authenticate users against an Active Directory or other LDAP directory server, turn on...

Type 6 Slowly Changing Dimensions Example

Overview Here we outline Matillion's approach to maintaining slowly changing dimension data using Matillion ETL by way of an extended example. Often than using Matillion ETL, a customer requires the ability to...

Integration with Amazon SQS

Setting up When using a Matillion ETL for Redshift as part of a larger process the best practice way to initiate an orchestration job is to use Simple Queue Service or SQS....

Schema Support

Overview Matilion ETL for Redshift is aware that you may have multiple schemas in your database cluster. Each Matillion ETL for Redshift environment specifies a default schema. The default schema is used...

Using incron to automatically copy data to S3

Overview This is not strictly related to Matillion ETL for Redshift however it is a common task to get data easily into S3 from a premise or system. This approach is especially...

Populating an Audit Table

Auditing Runtime Data Each component can make runtime information available. In this example, we are interested in how long an S3 load takes to complete and we want to show how to...

Twitter Data Model

Connection String Options Account Id Auto Cache Cache Connection Cache Driver Cache Location Cache Metadata Callback URL Connect On Open Firewall Password Firewall Port Firewall Server Firewall Type Firewall User Initiate OAuth...