Sales force updating databases
Alternatively, you may checkout Blendo to load your data from Salesforce to Snowflake in minutes for you, so you can focus on what really matters, which is how to extract more value from your data.
You can’t use a Data Warehouse without data, so the first and most important step is to extract the data you want from Salesforce.
Another interesting way of interacting with Sales Force is through the Streaming API.
Or create your own using the WSDL using the information provided by this guide.
From the above list, the complexity and feature richness of the Salesforce API is more than evident.
The REST API and the SOAP API are exposing the same functionalities but using different protocols.
Snowflake in contrast to other technologies like Redshift, does not require a data schema to be packed together with the data that will be copied.
Instead the schema is part of the query that will copy the data into the data warehouse.