Orchestration Components

Database Query Connection URL as Variable

Database Query component used to take Connection URL value through parameter / variable. Now it is not accepting. How can we send the connection url dynamically (Through parameter / variable),...

Job Variables API

Saw several posts but not sure if I am seeing this specific scenario I have Jobs that require metadata stores outside of Matilion (job level not environment). So I want...

OData V2 Error

Hi there, I am trying to load data from an OData source with no username/password required. After I enter the URL and click on data source I get an error:...

current_timestamp in jython component printing datetime function for cursor.execute

Hi team, I am trying to feed current_timestamp value (redshift) in sql query inside python cursor, further storing the result into list, however current_timestamp inside select cursor is changing into...

Excel Query

Hi, I am loading multiple excel file from S3 as orchestration components. All of them load, except from one file where I get the following error: "Error parsing double value...

Load JSON file with S3 Load component

Hi, I want to load a JSON file with the following structure: [ { "advertiserId": 1234, "campaignType": "Test", "campaignId": 5678, "campaignStatus": "Running", "advertiserName": "Test", "budgetId": 78910, "campaignName": "Test", "campaignBid": {...

Restars a job when it failed

Hi , I would like to restart my job from the first component when it failed (at any component of the job). Is there any component to do this or...

Run SQL Script from file on s3?

Is there a reasonably straightforward way to run a SQL script that is stored as a file on s3? I do that with AWS Data Pipeline, and it is handy...

Updating grid variable from SQL result via python component

Hi team, I am trying to update grid variable from sql result where SQL result is having required columns only but for every run , I am getting below error....

passing variables from linux server using python API call to Matillion

Hi Team, I need to pass some variables input values from python scripts while executing the API request from Linux server to kick start Matillion job via python request library....