Skip to main content

Exciting New Native Salesforce Snowflake Integration

Salesforce and Snowflake Integration

When it comes to optimizing your business processes and data analytics, Salesforce and Snowflake stand as two potent platforms, each with its own ecosystem of developers, stakeholders, and users. The Salesforce Snowflake Integration is an essential conduit that amplifies the bond between these two cloud platforms.

Salesforce and Snowflake Integration

Native Salesforce Snowflake Integration: A Milestone in Native Data Sharing

Earlier this week, Salesforce and Snowflake made a groundbreaking announcement: the general availability of native Salesforce data sharing for Snowflake,  via what is colloquially referred to as “BYOL” (Bring Your Own License). This is a significant advancement, especially for Snowflake users familiar with the benefits of zero-copy sharing, a core Snowflake feature. With this integration, gone are the days when you needed layers of additional software, services, and complex processes to bridge the two platforms. This is where the Salesforce Snowflake Connector comes into play, simplifying data access and queries between Salesforce and Snowflake.

Skill Enhancement through Certification Paths

Salesforce Data Cloud serves as a data hub orchestrating a wide range of business activities—be it CRM, marketing, or or any web/mobile activities. To encourage this, Salesforce recently launched its Certified-Data-Cloud-Consultant learning path. This will help Salesforce organizations readily find skilled professionals adept in Salesforce Snowflake Integration.

Salesforce Runs on Snowflake: Following the Leader

In a revelation that should add credibility and assurance to the Salesforce Snowflake Integration, Salesforce’s internal data and analytics have migrated to run on Snowflake. This shows Salesforce is not just advocating for the technology but using it themselves, setting the stage for rapid advancements in Salesforce and Snowflake connectivity.

Transforming AI/ML Workloads

The Salesforce and Snowflake partnership holds tremendous promise for accelerating the time-to-value from your Salesforce data assets. From curating data to deploying ML models, the integration, facilitated by the Salesforce Snowflake Connector, will enable enterprises to leverage their data in novel ways, including the utilization of advanced AI features. There are many first and third party powered solutions to weave your model deployment efforts.

Need Help Navigating these Waters?

We have been in front of Salesforce and Snowflake integrating analytics apps for years. We recreantly wrote the  Salesforce data synchronization to Snowflake Guide and can’t wait to extend this into DataCloud. We have an incredible partner network that can help you implement any Salesforce or Snowflake Cloud components (CDP, MarketingCloud, Tableau).

Schedule a meeting to learn more

Ultimate Salesforce and Snowflake Guide on Salesforce Ben

Salesforce Ben

This week Ryan released a guide for Salesforce and Snowflake on Salesforce Ben. Salesforce Ben is the leading independent Salesforce.com community and authority on all things Salesforce.com.

Snowflake and Salesforce is a perfect marriage of cloud business applications and cloud data platform to turn data into information. Salesforce has built a powerful first-class integration within Salesforce Data Cloud that is the most advanced of any third party connectivity

If you are currently using Salesforce Data Cloud or Salesforce Tableau CRM this article is for you. Additionally, while at SnowflakeSummit2023, we saw some incredible Salesforce Data Cloud enhancements for Snowflake that will be game changing for enterprise cusetomers.

We can’t wait to write about upcoming zero copy feature from Salesforce to Snowflake. Included in our article is step by step tutorials how to integrate Salesforce with Snowflake to day. Should you have any questions how these capabilities apply to your enterprise or how Snowflake can advance your Salesforce analytics, we are here to help!

5 Min Snowflake Data Lake Powered by Azure Data Factory

Snowflake data lake powered by Azure Data Lake

In this video tutorial we build a Snowflake Data lake filled with Salesforce data using the power of Azure Data Factory. We built an ADF template that uses a few simple prompts to power a meta-data driven pipeline.

New Salesforce to Snowflake data pipeline template

View complete documentation

View more Tutorials

Download our Azure DataFactory Template Now

Name(Required)
This field is for validation purposes and should be left unchanged.

MVP Released in 2023

Learn more about the origins of our 5 Minute Snowflake data lake concept, where we automated our entire Salesforce data extraction process with a meta data driven approach. We used our own MVP to work with clients and refine our ELT solution with clients that invest in Azure for cloud infrastructure, Salesforce for sales, service, and operations, and Snowflake as a data platform for analytics.

Webinar: Streamlining Data Migration to Salesforce in 2024 using Datameer and Snowflake

Datameer Webinar

View our recorded webinar with Datameer and Data Tools Pro discover how you can optimize your Salesforce data migration process in 2023 using a reverse ETL process powered by Datameer and Snowflake. This webinar will be presented by Datameer and Ryan Goodman, creator of Data Tools Pro. Ryan will showcase how Datameer has been the secret sauce to accelerate a reverse ETL data stack to effectively prepare, transform, and analyze data.

Whether you’re a Salesforce administrator, a data analyst, or data professional, this webinar will equip you with practical insights to streamline your data migration. Don’t miss out on this opportunity to learn and ask live questions how to enhance your data migration practices.

What you will Learn?

During the webinar, we’ll cover , real-world examples of successful reverse ETL scenarios for Snowflake specifically for Salesforce. Additionally, Ryan will share best practices and pitfalls to avoid during a typical Salesforce.com data migration.

On Demand Recording

Name(Required)
This field is for validation purposes and should be left unchanged.

How my Snowflake Powered Lead Distro Test Turned Out to be Reverse ETL

Snowflake Cloud Data Pipelines for Reverse ETL

A year ago, I worked on a small project to help us improve our data driven funnel. I learned what I called “Snowflake to Salesforce analytics sync” had a more buzzworthy term called “Reverse ETL.” This article shares some of the lessons learned along the way and some thoughts about where reverse ETL is headed.

Low Level of Effort Solution

All of the data and metrics were already available and calculated in Snowflake for reporting, so the process to push those measurements back into a Salesforce object using Azure Data Factory was quite simple.

The transformation work was prepared using Datameer on top of Snowflake which I had previously written about: Slice Through your Snowflake Data like a Buzzsaw with Datameer

Salesforce.com Migration Research Q&A with ChatGPT

ChatGPT from OpenAI is a very powerful generative AI system for research that has quickly captivated millions of users.

I decided to put ChatGPT to the test to do a focused Q&A session about moving to Salesforce.com and how to plan for your data migration. The results were absolutely amazing!

Check out this article on Medium to get the most common questions answered by ChatGPT about moving to Salesforce.com and what to expect for migrating your data into Salesforce:

Read More on Medium