Advanced

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

Custom SQL Query as an Iterator

Hi, For some reasons we don not want to use Table iterator. But we want to use a column values of an SQL query which would act as an Iterator....

S3 Object Prefix (File extension issue)

I have a staging table - Account and I am trying to load a text file (Delimited by Pipe) from S3. This is a text file (.TXT) But I do...

Filechecker and update status flag

Hello, I am loading a file into a table (single column) - which has several file names. - This is a S3 load Now in the second step - I...

Component not in a valid sate error

Hi ! I have one transformation job. Table Input and Table Output (Truncate load) Table Input - (Target Table name) - I have defined a variable Var1 and schema is...

Python Script - Syntax to define Variable

Hi, I have a python script and a Table iterator. Can you please validate if the way variable is defined is correct ? cursor = context.cursor() cursor.execute('select count(*) from md_staging.${stage_table}')...