Skip to content

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.

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 of the following:

    • campaign_id, email, and Salesforce_FID
    • 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 can't write to them:

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


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.


Name = string

A human-readable name for the component.

OAuth = drop-down

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 = 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 to be output to Pardot. The chosen source schema determines what tables will be available for selection.

Target Object = drop-down

The Pardot object (table) into which local data will be loaded (input). Users can choose Import API (For Prospects).

Output Operation = drop-down

Select the output operation to be performed into the target object. Users can choose Upsert.

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.


Snowflake Delta Lake on Databricks Amazon Redshift Google BigQuery Azure Synapse Analytics