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] uses 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] uses 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
✅	❌	❌	❌	❌