Advanced

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"

Specify value in identity column?

I want to have an "identity" column in a dimension data warehouse table. As a surrogate key. And an auto-generated one at that -- so that I don't have to...

s3 Load

I have files on s3 bucket, gzipped and delimited with ~|~. Trying to figure out a way to use S3 Load component however running into two issues/scenarios. First, I can't...

Metadata update skipped (Redshift)

What does 'Metadata update skipped' means in Task History? Does Matillion need CREATE on schema META? Cheers,

Youtube Data Attributes

Hello, I am evaluating the solution and would like to see a listing of the YouTube data attributes and entities that are extracted by Matillion. Can someone kindly share a...

String index out of range

I'm creating an API Profile to Harvest. I can connect with curl like this: curl "https://humanity34.humanity.com/app/" -H "origin: https://humanity34.humanity.com" -H "x-requested-with: XMLHttpRequest" --data "key=<mykey>=staff.login&method=GET&username=<myusername>&password=<mypassword>" If use the JSON file curl...

Handling a CSV report from an API request

I am making requests against an API which returns a CSV output. I have used the function jsonproviderGet and xmlproviderGet successfully in the past, but it seems like the API...