Contents x
    Intercom Output
      • Dark
        Light
      Contents

      Intercom Output

        • Dark
          Light
        Article Summary

        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

        PropertySettingDescription
        NameStringA human-readable name for the component.
        Intercom Access TokenSelect | StringProvide 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.
        DatabaseSelectSelect the Snowflake database. The special value, [Environment Default], uses whichever database is configured in the Matillion ETL environment.
        SchemaSelectSelect the schema. The special value, [Environment Default], uses whichever schema is configured in the Matillion ETL environment.
        Source TableSelectSelect 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 ObjectSelectSelect the target endpoint. Users can choose either Company or Contact.
        Output OperationSelectSelect 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 IDSelectThe ID the component uses to update the target object.
        This property is only available when the Output Operation is set to Update.
        Column MappingsSource ColumnsThe columns in the Source Table that will be output.
        Target ColumnsThe columns in the Target Object where the Source Columns will be output to.
        Custom AttributesNameSelect a custom attribute. Custom attributes have to have been created in the Intercom workspace before use.
        Source ColumnsMap source table columns to the custom attribute. The available values in this column are determined by the specified Source Table property.

        Redshift Properties

        PropertySettingDescription
        NameStringA human-readable name for the component.
        Intercom Access TokenSelect | StringProvide 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 SchemaSelectSelect the source schema. The special value, [Environment Default], uses whichever schema is configured in the Matillion ETL environment.
        Source TableSelectSelect 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 ObjectSelectSelect the target endpoint. Users can choose either Company or Contact.
        Output OperationSelectSelect 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 IDSelectThe ID the component uses to update the target object.
        This property is only available when the Output Operation is set to Update.
        Column MappingsSource ColumnsThe columns in the Source Table that will be output.
        Target ColumnsThe columns in the Target Object where the Source Columns will be output to.
        Custom AttributesNameSelect a custom attribute. Custom attributes have to have been created in the Intercom workspace before use.
        Source ColumnsMap source table columns to the custom attribute. The available values in this column are determined by the specified Source Table property.

        BigQuery Properties

        PropertySettingDescription
        NameStringA human-readable name for the component.
        Intercom Access TokenSelect | StringProvide 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.
        ProjectSelectSelect the project. The special value, [Environment Default], uses the project configured in the Matillion ETL environment.
        DatasetSelectSelect the dataset. The special value, [Environment Default], uses the dataset configured in the Matillion ETL environment.
        Source TableSelectSelect 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 ObjectSelectSelect the target endpoint. Users can choose either Company or Contact.
        Output OperationSelectSelect 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 IDSelectThe ID the component uses to update the target object.
        This property is only available when the Output Operation is set to Update.
        Column MappingsSource ColumnsThe columns in the Source Table that will be output.
        Target ColumnsThe columns in the Target Object where the Source Columns will be output to.
        Custom AttributesNameSelect a custom attribute. Custom attributes have to have been created in the Intercom workspace before use.
        Source ColumnsMap source table columns to the custom attribute. The available values in this column are determined by the specified Source Table property.

        Synapse Properties

        PropertySettingDescription
        NameStringA human-readable name for the component.
        Intercom Access TokenSelect | StringProvide 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 SchemaSelectSelect 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 TableSelectSelect 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 ObjectSelectSelect the target endpoint. Users can choose either Company or Contact.
        Output OperationSelectSelect 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 IDSelectThe ID the component uses to update the target object.
        This property is only available when the Output Operation is set to Update.
        Column MappingsSource ColumnsThe columns in the source table that will be output.
        Target ColumnsThe columns in the target object where the source columns will be output to.
        Custom AttributesNameSelect a custom attribute. Custom attributes need to be created in the Intercom workspace before use.
        Source ColumnsMap source table columns to the custom attribute. The available values in this column are determined by the specified Source Table property.
        What's Next