Intercom Output
Overview
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
Name = string
A human-readable name for the component.
Intercom Access Token = drop-down
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 = drop-down
The Snowflake database. The special value, [Environment Default], will use the database defined in the environment. Read Databases, Tables and Views - Overview to learn more.
Schema = drop-down
The Snowflake schema. The special value, [Environment Default], will use the schema defined in the environment. Read Database, Schema, and Share DDL to learn more.
Source Table = drop-down
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 = drop-down
Select the target endpoint. Select either Company or Contact.
Output Operation = drop-down
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 = drop-down
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 = columns editor
- Source Columns: Specify the columns in the source table that will be unloaded (output).
- Target Columns: Specify columns in the target object where the source columns will be output to.
Custom Attributes = columns editor
- 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.
Name = string
A human-readable name for the component.
Intercom Access Token = drop-down
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 = drop-down
Select the table schema. The special value, [Environment Default], will use the schema defined in the environment. For more information on using multiple schemas, read Schemas.
Source Table = drop-down
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 = drop-down
Select the target endpoint. Select either Company or Contact.
Output Operation = drop-down
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 = drop-down
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 = columns editor
- Source Columns: Specify the columns in the source table that will be unloaded (output).
- Target Columns: Specify columns in the target object where the source columns will be output to.
Custom Attributes = columns editor
- 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.
Name = string
A human-readable name for the component.
Intercom Access Token = drop-down
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 = drop-down
Select the Google Cloud project. The special value, [Environment Default], will use the project defined in the environment. For more information, read Creating and managing projects.
Dataset = drop-down
Select the Google BigQuery dataset to load data into. The special value, [Environment Default], will use the dataset defined in the environment. For more information, read Introduction to datasets.
Source Table = drop-down
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 = drop-down
Select the target endpoint. Select either Company or Contact.
Output Operation = drop-down
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 = drop-down
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 = columns editor
- Source Columns: Specify the columns in the source table that will be unloaded (output).
- Target Columns: Specify columns in the target object where the source columns will be output to.
Custom Attributes = columns editor
- 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.
Name = string
A human-readable name for the component.
Intercom Access Token = drop-down
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 = drop-down
Select the table schema. The special value, [Environment Default], will use the schema defined in the environment. For more information on schemas, read the Azure Synapse documentation.
Source Table = drop-down
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 = drop-down
Select the target endpoint. Select either Company or Contact.
Output Operation = drop-down
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 = drop-down
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 = columns editor
- Source Columns: Specify the columns in the source table that will be unloaded (output).
- Target Columns: Specify columns in the target object where the source columns will be output to.
Custom Attributes = columns editor
- 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.
| Snowflake | Delta Lake on Databricks | Amazon Redshift | Google BigQuery | Azure Synapse Analytics |
|---|---|---|---|---|
| ✅ | ❌ | ✅ | ✅ | ✅ |