Mandrill Extract

Mandrill Extract


Mandrill Extract

The Mandrill Extract component uses the Mandrill API to retrieve and store data to then be referenced by an External Tableloaded into a table. You may then use transformations to enrich and manage the data.

Note: This component may return structured data that requires flattening. Please see the Nested Data Load Component for information on how to accomplish this.

Note: This component may return structured data that requires flattening. Please see the Extract Nested Data Component for information on how to accomplish this.


Redshift Properties

Property Setting Description
Name Text The descriptive name for the component.
Data Source Choice Select a data source from a list. Returned columns and Component Properties are dependent on the data source chosen.
Key Password Enter an API Key to connect your Mandrill App. See the 3rd Party OAuth documentation for a guide on how to acquire an API Key. We recommend storing API Keys in the Password Manager.
Query Text (Data Source: Messages Search) Enter a string to match to queried messages. Only rows that include the string will be returned.
Date From Text (Data Source: Messages Search) A date to query messages from. Format of YYYY-MM-DD
Date To Text (Data Source: Messages Search) A date to query messages up to. Format of YYYY-MM-DD
Tags Text Multiple (Data Source: Messages Search) Enter tags for the query to be filtered by.
Senders Text Multiple (Data Source: Messages Search) Enter the names of Senders for the query to be filtered by.
API Keys Text Multiple (Data Source: Messages Search) Enter API Keys for the query to be filtered by.
Limit Integer (Data Source: Messages Search) The maximum number of messages to return from a query.
Note: A maximum of 1000 results can be returned at a time due to a limitation of the Mandrill API. To load larger amounts of data, we recommend iterating the component using "Date From" and "Date To" to page results.
Location Text/Select Provide an S3 Bucket path that will be used to store the data. Once on an S3 bucket, the data can be referenced by an external table. A folder will be created at this location with the same name as the Target Table.
External Schema Select Select an External Schema that will hold your new External Table.
Target Table Text Provide a name for the External Table to be used.
Warning: This table will be recreated and will drop any existing table of the same name.

Snowflake Properties

Property Setting Description
Name Text The descriptive name for the component.
Data Source Choice Select a data source from a list. Returned columns and Component Properties are dependent on the data source chosen.
Key Password Enter an API Key to connect your Mandrill App. See the 3rd Party OAuth documentation for a guide on how to acquire an API Key. We recommend storing API Keys in the Password Manager.
Query Text (Data Source: Messages Search) Enter a string to match to queried messages. Only rows that include the string will be returned.
Date From Text (Data Source: Messages Search) A date to query messages from. Format of YYYY-MM-DD
Date To Text (Data Source: Messages Search) A date to query messages up to. Format of YYYY-MM-DD
Tags Text Multiple (Data Source: Messages Search) Enter tags for the query to be filtered by.
Senders Text Multiple (Data Source: Messages Search) Enter the names of Senders for the query to be filtered by.
API Keys Text Multiple (Data Source: Messages Search) Enter API Keys for the query to be filtered by.
Limit Integer (Data Source: Messages Search) The maximum number of messages to return from a query.
Note: A maximum of 1000 results can be returned at a time due to a limitation of the Mandrill API. To load larger amounts of data, we recommend iterating the component using "Date From" and "Date To" to page results.
Location Text/Select Provide an S3 bucket path, GCS bucket path, or Azure Blob Storage path that will be used to store the data. Once on an S3 bucket, GCS bucket or Azure Blob, the data can be referenced by an external table. A folder will be created at this location with the same name as the Target Table.
Integration Select Choose your Google Cloud Storage Integration. Integrations are required to permit Snowflake to read data from and write to a Google Cloud Storage bucket. Integrations must be set up in advance of selecting them in Matillion ETL. To learn more about setting up a storage integration, read our Storage Integration Setup Guide.
Warehouse Select Choose a Snowflake warehouse that will run the load.
Database Select Choose a database to create the new table in.
Schema Select Select the table schema. The special value, [Environment Default], will use the schema defined in the environment. For more information on using multiple schemas, see this article.
Target Table Text Provide a new table name.
Warning: This table will be recreated and will drop any existing table of the same name.

BigQuery Properties

Property Setting Description
Name Text The descriptive name for the component.
Data Source Choice Select a data source from a list. Returned columns and Component Properties are dependent on the data source chosen.
Key Password Enter an API Key to connect your Mandrill App. See the 3rd Party OAuth documentation for a guide on how to acquire an API Key. We recommend storing API Keys in the Password Manager.
Query Text (Data Source: Messages Search) Enter a string to match to queried messages. Only rows that include the string will be returned.
Date From Text (Data Source: Messages Search) A date to query messages from. Format of YYYY-MM-DD
Date To Text (Data Source: Messages Search) A date to query messages up to. Format of YYYY-MM-DD
Tags Text Multiple (Data Source: Messages Search) Enter tags for the query to be filtered by.
Senders Text Multiple (Data Source: Messages Search) Enter the names of Senders for the query to be filtered by.
API Keys Text Multiple (Data Source: Messages Search) Enter API Keys for the query to be filtered by.
Limit Integer (Data Source: Messages Search) The maximum number of messages to return from a query.
Note: A maximum of 1000 results can be returned at a time due to a limitation of the Mandrill API. To load larger amounts of data, we recommend iterating the component using "Date From" and "Date To" to page results.
Project Text The target BigQuery project to load data into.
Dataset Text The target BigQuery dataset to load data into.
Target Table Text Provide a new table name.
Warning: This table will be recreated and will drop any existing table of the same name.
Cloud Storage Staging Area Text The URL and path of the target Google Storage bucket to be used for staging the queried data.
Load Options Multiple Select Clean Cloud Storage Files: Destroy staged files on Cloud Storage after loading data. Default is On.
Cloud Storage File Prefix: Give staged file names a prefix of your choice. The default setting is an empty field.
Recreate Target Table: Choose whether the component recreates its target table before the data load. If Off, the component will use an existing table or create one if it does not exist. Default is On.
Use Grid Variable: Check this checkbox to use a grid variable. This box is unchecked by default.