Contents x
    Pardot Output
      • Dark
        Light
      Contents

      Pardot Output

        • Dark
          Light
        Article Summary

        This article is specific to the following platforms - Snowflake.

        Pardot Output

        The Pardot Output component uses the Pardot API to write back the contents of a source table (or view) from their cloud data warehouse (CDW) into a table in Pardot.


        Important Information

        Please be aware of the following:


        1. The Column Mappings property will fail to validate if the following columns are not mapped:

        • campaign_id
        • email

        2. Where any data is wrapped in quotation marks " ", the quotation marks will be encoded and sent to Pardot.

        3. When a record is created with the columns campaign_id, email, and Salesforce_FID, you can update the record using either:

        • campaign_id, email, and Salesforce_FID, OR
        • campaign_id, email

        4. However, when a record is created with the columns campaign_id and email, you can update the record with only the following:

        • campaign_id, email

        5. An error will occur if you send a blank Salesforce_FID to a record that was created using only campaign_id and email. The error message will cite "No CRM is provided".

        6.The following fields (columns) are read-only, and Pardot cannot write to them:

        • created_at
        • crm_last_sync
        • crm_url
        • is_archived
        • last_activity_at
        • opted_out
        • recent_interaction
        • updated_at

        Warning: this component is potentially destructive. The output operations performed by this component can delete, overwrite, and truncate target objects within Pardot, and these operations may be irreversible.


        Properties

        Snowflake Properties

        PropertySettingDescription
        NameStringA human-readable name for the component.
        OAuthSelectSelect an OAuth entry to authenticate this component. An OAuth entry must be set up in advance. For help, read Pardot Authentication Guide.
        Business Unit IdStringYour Pardot Business Unit ID. To learn more, read Authentication.
        DatabaseSelectSelect the Snowflake database. The special value, [Environment Default], will use the database defined in the Matillion ETL environment. For more information, read Databases, Tables, & Views.
        SchemaSelectSelect the Snowflake schema. The special value, [Environment Default], will use the schema defined in the Matillion ETL environment. For more information, read Database, Schema, & Share DDL.
        Source TableSelectSelect the source table to be output to Pardot. The chosen source schema determines what tables will be available for selection.
        Target ObjectSelectThe Pardot object (table) into which local data will be loaded (input). Users can choose Import API (For Prospects).
        Output OperationSelectSelect the output operation to be performed on the target object. Users can choose Upsert.
        Column MappingsSource ColumnsSpecify the columns in the source table that will be unloaded (output).
        Target ColumnsSpecify columns in the target object where the source columns will be output to.

        Video

        What's Next