Troubleshoot the Salesforce Marketing Cloud connector
This feature is in Beta. Workspace admins can control access to this feature from the Previews page. See Manage Databricks previews.
Learn how to troubleshoot common issues with the Salesforce Marketing Cloud connector.
Invalid characters in column names
Error message:
Found invalid character(s) among ' ,;{}()\n\t=' in the column names of your schema.
Cause: The data extension at the source contains column names with invalid characters that are not supported by Delta.
Solution: Check the column name from the error trace and rename the column at the source so that it doesn't contain invalid characters. Then, rerun the pipeline.
Duplicate key violation
Error message:
DUPLICATE_KEY_VIOLATION
Cause: The entire row is duplicated at the source. The connector cannot currently support this scenario.
Solution: Either remove the duplicate row from the data extension, or set a primary key for the data extension in Salesforce Marketing Cloud. Then, run a full refresh of the pipeline.
Insufficient permissions
Error message:
SFMC_INSUFFICIENT_PERMISSIONS
Cause: The API Integration Package does not have the required scope to access the data.
Solution: Check the required scope from the error message, and ensure that you've added that scope in the API Integration package that you created in Salesforce Marketing Cloud. Then, rerun the pipeline.