Pardot Output
  • Dark

Pardot Output

  • Dark

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.


Snowflake Properties

Property Setting Description
Name String A human-readable name for the component.
OAuth Select Select an OAuth entry to authenticate this component. An OAuth entry must be set up in advance. For help, read Pardot Authentication Guide.
Business Unit Id String Your Pardot Business Unit ID. To learn more, read Authentication.
Database Select Select 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.
Schema Select Select 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 Table Select Select the source table to be output to Pardot. The chosen source schema determines what tables will be available for selection.
Target Object Select The Pardot object (table) into which local data will be loaded (input). Users can choose Import API (For Prospects).
Output Operation Select Select the output operation to be performed on the target object. Users can choose Upsert.
Column Mappings 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.


What's Next