Advanced

Variables

Overview Note: Grid Variables are discussed on a dedicated article. Variables are name-value pairs stored within each environment. Variables can be used in all sorts of parameters and expressions to allow the...

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 (dependent on platform)...

Securing Matillion ETL

Overview By default Matillion ETL 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 and...

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 when using Matillion ETL, a customer requires the ability to...

GoogleCustomSearch Data Model

Connection String Options Api Key Auto Cache Cache Connection Cache Driver Cache Location Cache Metadata Cache Query Result Connect On Open Custom Search Id Firewall Password Firewall Port Firewall Server Firewall Type...

Google 3rd Party OAuth Setup

Note: It may be that some of these services incur costs to your GCP account. Please consult the GCP documentation for pricing. In order to connect to Google data from various services...

Schema Support

Overview Matilion ETL is aware that you may have multiple schemas. Each Matillion ETL environment specifies a default schema. The default schema is used by Matillion ELT in the following ways: It...

Year-On-Year Analysis

Using Matillion for Year on Year and Month on Month analysis. Year On Year (also 'Year Over Year' or 'YOY') analysis is a popular method used to estimate the health of a...

Using incron to automatically copy data to S3

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

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...