Advanced

Capture Errors in SNS component

Hi, we are using SNS component to notify the user for any job fail, now we want to send the notification email with Error message included in it , is...

JSON straucture

Hi Matillion Team, I am developing ELT process in which one of the source column is varchar thats need to be converted to Variant data type. I am able to...

Who ran which job?

Hi all, We have several developers using one XL instance of Matillion, and frequently we need to look at the Task History. When in Task History though, there doesn't seem...

Export/Import Environment Variable throught API

Hi, I see here: https://redshiftsupport.matillion.com/customer/portal/articles/2916124-api-v1 that it's possible to import an Environment Variable but I didn't find any further details in the rest of the documentation. What's the format of...

Using snowflake as a source

I have a requirement to move some data from snowflake into SalesForce. I see all kinds of information about moving data into snowflake, but nothing on moving data out. Is...

JOB status in Task bar

I have cancelled a long running job in my Task bar , job got cancelled by it is still showing in Task bar as running . logoff and login didn't...

Data replication

Do Matillion has option to load all the salesforce tables into snowflake by creating the tables dynamically and then maintain the salesforce and snowflake in sync by loading data incrementally...

Table Output Row to Outer job

Is there a way to pass the table output results to the outer job without using a Global variable? I'm worried there could be conflicts if I use a global...