Skip to content

Pardot Output

Overview

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

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

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.

Video

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