Context

We use Salesforce connector to sync a few objects to our Data Platform. 

Recently, we updated the connection details to use a new set of credentials. However, the credentials didn't have appropriate permissions in Salesforce to read all the objects. 

What was observed

• The "Connection Test" was successful.
• During the sync, the connector silently skipped the affected objects (they were shown as disabled in the Schema tab later)
• No errors were seen in logs or any notification reported from Fivetran

One of our downstream DBT source freshness checks caught the issue. 

What is the expected behaviour

• Connection tests should not just verify credentials but read access issues as well
• Such issues should be logged as errors and notifications triggered. This is to address scenarios when credential authorization changes, after initial setup.