Contents x
Intercom Output
  • Dark
    Light
Contents

Intercom Output

  • Dark
    Light
This article is specific to the following platforms - Snowflake - Redshift - BigQuery - Synapse.

Intercom Output

The Intercom Output component lets users push data held in cloud data warehouse tables or views to their Intercom account via the Intercom REST API. Presently, users have the option to insert or update data.

Properties

Snowflake Properties
Property Setting Description
Name String A human-readable name for the component.
Intercom Access Token Select | String Provide the Intercom access token. Users can either create a named entry for the token using the Matillion ETL Password Manager or store the access token within the component. The advised method is to create a named entry in the Password Manager.
Database Select Select the Snowflake database. The special value, [Environment Default], uses whichever database is configured in the Matillion ETL environment.
Schema Select Select the schema. The special value, [Environment Default], uses whichever schema is configured in the Matillion ETL environment.
Source Table Select Select the source table containing the data to be output to Intercom. The selected source schema determines which tables will be available in the dropdown list.
Target Object Select Select the target endpoint. Users can choose either Company or Contact.
Output Operation Select Select the output operation.
The Company endpoint has only one output operation available: Update.
The Contact endpoint has two output operations available: Insert and Update.
Intercom ID Select The ID the component uses to update the target object.
This property is only available when the Output Operation is set to Update.
Column Mappings Source Columns The columns in the Source Table that will be output.
Target Columns The columns in the Target Object where the Source Columns will be output to.
Custom Attributes Name Select a custom attribute. Custom attributes have to have been created in the Intercom workspace before use.
Source Columns Map source table columns to the custom attribute. The available values in this column are determined by the specified Source Table property.

Redshift Properties
Property Setting Description
Name String A human-readable name for the component.
Intercom Access Token Select | String Provide the Intercom access token. Users can either create a named entry for the token using the Matillion ETL Password Manager or store the access token within the component. The advised method is to create a named entry in the Password Manager.
Source Schema Select Select the source schema. The special value, [Environment Default], uses whichever schema is configured in the Matillion ETL environment.
Source Table Select Select the source table containing the data to be output to Intercom. The selected source schema determines which tables will be available in the dropdown list.
Target Object Select Select the target endpoint. Users can choose either Company or Contact.
Output Operation Select Select the output operation.
The Company endpoint has only one output operation available: Update.
The Contact endpoint has two output operations available: Insert and Update.
Intercom ID Select The ID the component uses to update the target object.
This property is only available when the Output Operation is set to Update.
Column Mappings Source Columns The columns in the Source Table that will be output.
Target Columns The columns in the Target Object where the Source Columns will be output to.
Custom Attributes Name Select a custom attribute. Custom attributes have to have been created in the Intercom workspace before use.
Source Columns Map source table columns to the custom attribute. The available values in this column are determined by the specified Source Table property.

BigQuery Properties
Property Setting Description
Name String A human-readable name for the component.
Intercom Access Token Select | String Provide the Intercom access token. Users can either create a named entry for the token using the Matillion ETL Password Manager or store the access token within the component. The advised method is to create a named entry in the Password Manager.
Project Select Select the project. The special value, [Environment Default], uses the project configured in the Matillion ETL environment.
Dataset Select Select the dataset. The special value, [Environment Default], uses the dataset configured in the Matillion ETL environment.
Source Table Select Select the source table containing the data to be output to Intercom. The selected source schema determines which tables will be available in the dropdown list.
Target Object Select Select the target endpoint. Users can choose either Company or Contact.
Output Operation Select Select the output operation.
The Company endpoint has only one output operation available: Update.
The Contact endpoint has two output operations available: Insert and Update.
Intercom ID Select The ID the component uses to update the target object.
This property is only available when the Output Operation is set to Update.
Column Mappings Source Columns The columns in the Source Table that will be output.
Target Columns The columns in the Target Object where the Source Columns will be output to.
Custom Attributes Name Select a custom attribute. Custom attributes have to have been created in the Intercom workspace before use.
Source Columns Map source table columns to the custom attribute. The available values in this column are determined by the specified Source Table property.

Synapse Properties

Property Setting Description
Name String A human-readable name for the component.
Intercom Access Token Select | String Provide the Intercom access token. Users can either create a named entry for the token using the Matillion ETL Password Manager or store the access token within the component. The advised method is to create a named entry in the Password Manager.
Source Schema Select Select the table schema. The special value, [Environment Default], will use the schema defined in the environment. For more information on schemas, please see the Azure Synapse documentation.
Source Table Select Select the source table containing the data to be output to Intercom. The selected source schema determines which tables will be available in the dropdown list.
Target Object Select Select the target endpoint. Users can choose either Company or Contact.
Output Operation Select Select the output operation.
The Company endpoint has only one output operation available: Update.
The Contact endpoint has two output operations available: Insert and Update.
Intercom ID Select The ID the component uses to update the target object.
This property is only available when the Output Operation is set to Update.
Column Mappings Source Columns The columns in the source table that will be output.
Target Columns The columns in the target object where the source columns will be output to.
Custom Attributes Name Select a custom attribute. Custom attributes need to be created in the Intercom workspace before use.
Source Columns Map source table columns to the custom attribute. The available values in this column are determined by the specified Source Table property.
What's Next

Cookie consent

We use our own and third-party cookies to understand how you interact with our knowledge base. This helps us show you more relevant content based on your browsing and navigation history.