Advanced

Google OAuth2 - service account

Hello, Can we use Service Accounts when setting up OAuth2 for Google APIs, or the only option is Web Application? Thanks, Danail

Importing a single schedule, via V1 API

Hi, I wanted to know how to import a single schedule via the V1 API into a Matillion project? I can perfectly export single schedules in json format, which I...

Updating Variables

Hi, I'm using this python script to update an Environment Variable : cursor = context.cursor() cursor.execute('select cast(max(right("$path",8)) as int) from eds') max_mill = cursor.fetchone()[0] context.updateVariable('Mill_max_date', max_mill) After running the script,...

API profile - POST request body

Hello, I am creating an API profile for Feefo authentication - https://support.feefo.com/support/solutions/articles/8000041717-api-authentication. It requires a POST request, sending several credential parameters in the body. I found several examples, which indirectly...

Version control + upgrade

I am trying to understand, how version controlling individual jobs in git will be impacted by upgrade of Matillion version to the next release version. Currently when we try to...

SNS message

How do I import a table/view into an SNS message?

Access the Matillion "Task History" data, directly?

Hi, In a webinar today, I think I heard that it is possible to access my Matillion "Task History" data, in a database. I might like to use it as...

AWS Secrets Manager

Has anyone retrieved info from the AWS Secrets Manager with Matillion? I'm looking at this to store some credentials that I need to use within Matillion processes, but not sure...

JSON format - UI vs API

Hi, Is there an intention to have only 1 JSON format regardless of we export the Job manually through Matillion's UI or we export the Job from Matillion's API? The...

Assigning Values to Variables in Matillion

Hi Community, Could you please let me know if we can achieve the following requirement using a Matillion : Req: We want to provide the flexibility of changing the variable...