Building a Data Pipeline to Connect Salesforce to Snowflake Using Hevo

Steps to Build the Pipeline for Salesforce to Snowflake

Step 1: Configure Salesforce as your Source.

  1. Click on ‘Create Pipeline’ button.
  2. Search for ‘Salesforce’ and select it.
  3. Authorize your Salesforce account and select the duration for Historical Load.
  4. Finally, click ‘Continue.’

Step 2: Configure Objects

  1. Select the objects you want to replicate to your destination.
  2. Click on ‘Continue’ to move ahead.

Step 3: Configure Snowflake as your Destination.

  1. Select ‘Snowflake’ as your destination.
  2. Fill the required connection details to connect to your Snowflake account.
  3. Now, click on ‘Save & Continue.’

You can also refer to the official documentation from Snowflake to get a better understanding of how to configure Snowflake as your Destination.

Step 4: The Final Step

  1. Give a suitable Table prefix.
  2. For the final step, click ‘Continue.’

And that’s it! You are done creating a pipeline to connect Salesforce to Snowflake.

FAQs about Salesforce Snowflake Integration

1. How do I send data from Salesforce to Snowflake?

To send data from Salesforce to Snowflake, you can use ETL tools like Fivetran or Hevo, which automate the extraction of data from Salesforce and load it into Snowflake.

2. Is Salesforce built on Snowflake?

No, Salesforce is not built on Snowflake. Salesforce is a cloud-based CRM platform, while Snowflake is a cloud data warehouse solution.

3. Is Snowflake just a data warehouse?

Snowflake is primarily a cloud-based data warehouse but also integrates data lake capabilities, supports data sharing, and offers a marketplace for data services.

Chirag Agarwal
Principal CX Engineer, Hevo Data

Chirag is a seasoned support engineer with over 7 years of experience, including over 4 years at Hevo Data, where he's been pivotal in crafting core CX components. As a team leader, he has driven innovation through recruitment, training, process optimization, and collaboration with multiple technologies. His expertise in lean solutions and tech exploration has enabled him to tackle complex challenges and build successful services.