Advanced

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

Matillion pattern to flatten a parent-child hierarchy?

What's the best pattern y'all have come up with, in Matillion, for "flattening" a parent/child (AKA self-referencing) hierarchy? In a way that produces results like this: https://jsimonbi.wordpress.com/2011/01/16/flattening-or-naturalizing-a-parent-child-hierarchy/ http://www.daxpatterns.com/parent-child-hierarchies/ I've started...

API Variable Defaults

I am looking for a way to set defaults as part of deployments. Can this be done via the API?

slowly changing dimensions

the Type 6 Slowly Changing Dimensions example does not appear to work correctly. I was able to create a similar one that takes care of getting rid of the cartesian...

can't review "Task History" records ?

I am trying to review Task History but it is not working. "Fetching records" all the time. Please check it. Thank you

Pull data from mysql aurora and load into postgresql rds?

Is it possible to pull data from a mysql aurora instance and load that data into a postgresql rds database? We use both redshift for our data warehouse but are...