Advanced

Adobe Analytics

Currently loading information from Adobe Analytics data feed into Snowflake via an orchestration. The transformation aspects are quite daunting. Looking for articles or reference data that might provide some guidance...

Update default job variable value

Is it somehow possible to update default job variable value? e.g. I have job variable foo=0 Then I update it foo=5 in Python script, but value remains updated only in...

How do we use Netsuite SuiteAnalytics

Hello, I know matillion Netsuite connector is using SOAP based web services to extract data from Netsuite but Netsuite also has SuiteAnalytics which is kind extracting from database using JDBC/ODBC...

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