Orchestration Components

Append To Grid

Append To Grid This component will append data to a preexisting grid variable in Matillion ETL. This does not add columns to the grid but can add rows to existing columns. Properties...

Remove From Grid

Remove From Grid This component will take in Grid Variable data and remove data from it. This can be used to remove rows from grid columns but not the columns themselves. To...

Table Metadata To Grid

Table Metadata To Grid This component will take the metadata from a table and use this data to populate a grid variable with data. The component can take the following metadata from...

LinkedIn Query

LinkedIn Query This component uses the LinkedIn API to retrieve data and load it into a table. This stages the data, so the table is reloaded each time. You may then use...

Open Exchange Rates Query

Open Exchange Rates Query This component uses the Open Exchange Rates API to retrieve data and load it into a table. This stages the data, so the table is reloaded each time....

Grid Iterator

Grid Iterator Component Loop over values of a simple sequence. This component implements a simple loop over the rows of a Grid Variable. It enables you to run an attached component multiple...

Bing Search Query Component

Bing Search Query This component uses the Bing Search API to retrieve search data and load it into a table. This stages the data, so the table is reloaded each time. You...

Bing Ads Query Component

Bing Ads Query This component uses the Bing Ads API to retrieve data and load it into a table. This stages the data, so the table is reloaded each time. You may...

DynamoDB Query Component

DynamoDB Query Component Important Notice: Matillion ETL for Redshift offers two methods of loading data from DynamoDB. This component uses a custom driver to load from DynamoDB to Redshift. DynamoDB Load component...

Zuora Bulk Query Component

Zuora Bulk Query This component uses the Zuora AQuA API to retrieve data and load it into a table. This stages the data, so the table is reloaded each time. You may...