Data source question.

What is the difference between using a data source that is connected directly to Salesforce versus one that is connected to a Snowflake warehouse where the Salesforce data is stored?