1. Export Campaign Data in Bulk from Snowflake to Salesforce Marketing Cloud Using GCP Storage
  2. About This Recipe

1 About This Recipe

Use this recipe to export campaign data in bulk from Snowflake to Salesforce Marketing Cloud (SFMC) using Google Cloud Platform (GCP) Storage.

Note:

This recipe is available as Snowflake — Salesforce Marketing Cloud | Export Campaign Data in Oracle Integration. Oracle provides this recipe as a sample only. The recipe is meant only for guidance, and is not warranted to be error-free. No support is provided for this recipe.

Overview

This recipe exports campaign data in bulk from Snowflake to Salesforce Marketing Cloud using an external stage (GCP Storage).

To use the recipe, you must install the recipe and configure the connections and other resources within it. You can activate and run the integration flow of the recipe manually or specify an execution schedule for it. When triggered, the integration flow fetches the campaign data from Snowflake and exports it to a GCP Storage bucket in comma separated value (CSV) format. Subsequently, it downloads the CSV file from the GCP Storage bucket and creates campaign objects in Salesforce Marketing Cloud. Basic data such as Name, Description, CampaignCode, Favorite, Color and so on are synchronized between Snowflake and Salesforce Marketing Cloud.

System and Access Requirements

  • Oracle Integration, Version 24.04 or higher

  • Snowflake

  • An account on Snowflake with the System Administrator role

  • GCP bucket that is configured with a storage integration in the Snowflake account as an external stage.

  • Salesforce Marketing Cloud

  • An account on Salesforce Marketing Cloud with the Administrator role

  • GCP Storage

  • An account on GCP Storage with the System Administrator role

  • Ensure your Snowflake storage integration has access to the GCP bucket by granting permission in the GCP bucket (by adding Principals and assigning the Storage Object Admin role)