Advanced

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

Table update in SQL server database to trigger Matillion job

How can we go about triggering Matillion job based on an update in SQL server database table for certain column. We have a scenario where we want near real time...

PowerBI

Hi - I am wanting to have Matillion fire an API Data refresh to the PowerBI service on successful completion of running our ETL orchestration (Final step being posting the...

Cassandra encrypted column extraction

Hi there, I would like to know if Cassandra query component in Matillion able to see/extract encrypted columns in Cassandra? At the moment, it's only possible with using thrift driver...

V1 API Import Project

The v1 documentation [1] includes details about exporting a project, but there is no documentation relating to importing a project via the v1 API. Please can you add that capability...