Advanced

Determine all jobs with given input table

Hello :) I want to determine all jobs that contain a specific table. We have a new feature and we need to change those jobs. It would be great if...

Time-out or notification, if job runs too long?

Recently, I had a scheduled Matillion job got stalled. One "Load" component that normally takes a few minutes had taken ~2 hours, when I noticed what was going on. I...

CDC using Oracle Redo/Archive logs

Hi, My requirement is i want to capture the changed data from Oracle database into Redshift. My source tables not have any timestamps, so how can i do a CDC...

How to launch Matillion jobs by event?

How to launch Matillion jobs by source file(S3) existance? I mean when source file is created used by Matillion job. JOb starts only then. What kind of solutions there are...

API profiles - read JSON object properties as rows

Hi, I am trying to consume JSON data from an API for currency exchange rates. I have created an API profile and an RSD script file for that. In my...

dynamic pivot

Is it possible to create a dynamic pivot (where you don't know the number of rows that will be transformed into columns)?

Validate Matillion jobs programmatically

Hi, We would like to validate (build) our Matillion jobs in our QA environment every night to ensure they are still valide after the last changes in the database(s). Example:...

How to connect to Google Ad Manager API

Hello, We would like to connect and fetch data from the Google Ad Manager API. Since there is no dedicated Matillion component for this purpose we have created an API...

Send an email with an attachment

Hello, Is it possible to send out an email with an attachment; the attachment being a csv from an S3 bucket? The only thing that I could find is using...

Create Temp Tables in Redshift

Is there a way to create temp tables in Redshift using standard components like the RDS Query component? In Redshift, temp tables (tables created with CREATE TEMPORARY...) can be written...