Advanced

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

API v1 - export/import "default" version

Hello, is it possible to export and import the default version via API? We have 2 environments, DEV and PROD and we use a shell script to export/import jobs from...

Batch delete old versions of projects?

Is there a good, quick way to delete a many old versions of my Matillion project? Doing it one at a time, within the Matillion app, is slow. I tried...

RDS Output Component - Oracle

Hi Guru, Can you please advise for RDS Bulk Output Component, is it support to output data to RDS Type oracle?

API v1 - extract all jobs in a given folder possible?

Is it possible to export all jobs in a give folder to a json file? Anything like this: curl -o export.json -X GET -u api_user:api_pwd --insecure "http://127.0.0.1:8080/rest/v1/group/name/[GroupName]/project/name/[ProjectName]/version/name/[VersionName]/folder/name/[FullPathName]/export"