Orchestration Components

Azure Blob Storage Unload

Azure Blob Storage Unload Component Creates files on a specified Azure Blob Storage account and loads them with data from a table or view. By default, your data will be unloaded in...

Twilio Query

Twilio Query This component uses the Twilio API to retrieve data and load it into a table. Warning: This component is potentially destructive. If the target table undergoes a change in structure,...

Azure SQL Query

Azure SQL Query Run an SQL Query on an Azure SQL Database and copy the result to a table, via Azure Blob Storage. This component is for data-staging - getting data into...

DoubleClick For Publishers Query

DoubleClick for Publishers Query This component retrieves data from the DoubleClick API and loads that data into a table. Doing this stages the data, so that the table is reloaded each time....

Azure Queue Storage Message Component

Azure Queue Storage Message Component Note: This feature is only available for instances hosted on Azure. Post a message to an Azure Queue Storage. Other applications (including Matillion ETL instances) can read...

Redis Query Component

Redis Query This component retrieves data from the Redis database and loads that data into a table. Doing this stages the data, so that the table is reloaded each time. After this,...

JDBC Table Metadata To Grid

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

Splunk Query Component

Splunk Query The Splunk Query component integrates with the Splunk API to retrieve data from a Splunk server and load that data into a table. Warning: This component is potentially destructive. If...

Create External Table (Snowflake)

Create External Table This component enables users to create an "external" table that references externally stored data. Note that this creates a table that references the data that is held externally, meaning...

Salesforce Marketing Cloud Query

Salesforce Marketing Cloud Query This component uses the Salesforce Marketing Cloud API to retrieve data and load it into a table. This stages the data, so the table is reloaded each time....