Advanced

rolling 24 months

Community...I need to put a filter on my Table Input component to read only the last 24 months. I've tried using variables and something like: ${dt.now().add("months", -24)} but it's not...

Redshift is transitioning to ACM Certificates

We just got this notification from Amazon, about our Redshift cluster: https://docs.aws.amazon.com/redshift/latest/mgmt/connecting-transitioning-to-acm-certs.html Does this affect how Matillion works with Redshift? Will I have to do anything?

Database Query Component Mapping

I'm using a Db Query Component to stage data from a SQL Server source. I've noticed that source tables with BIT column are mapped to a VARCHAR(5) column. Is there...

Chnage color-theme

Hi. We are running Matillion on three different instances (Prod, QA and DEV). Is it possible to differentiate the instances by color in the interface or something else? At the...

Matillion Deployment using API

What are other people doing for deployment of ETL code from one server to the next? We are currently using the Matillion API and migrate from Dev to Test to...

Matillion API

We are using the Matillion API to migrate projects from Dev to Test to Prod. Is there any way to include the credentials for a project when it is imported...

Output to MySQL with AdditionalCopy parameters

Hi. I have MySQL server with default charset latin1. I need to output table to this DB, using RDS Bulk Output. My export data contains cyrillic chars. So, after using...

Reporting error states in a transformation

I'm trying to set up a multi-stage process to load a data warehouse. One of the first steps is to load data into a staging table. I then have some...

Facebook Public Pages

Is there a Data Store in the Facebook Query component which can access Graph APIs? I want to access the Facebook Public Pages fields which are available in the Graph...

Troubleshooting quides

Lets say when job results did not turn out to be within expectation (E.g data conversion failures, records went missing, joins are not accurate, ...), any reference to troubleshooting guides...