Salesforce Frequently Asked Questionslink
Updated 12 days ago
Read answers to frequently asked questions about the Fivetran Salesforce connector.
Which naming conventions does Fivetran use?link
Fivetran follows a set of standard naming conventions for schemas, tables, and columns. To learn more about our naming conventions, read the naming conventions section of our Core Concepts document.
Why is a particular table or column missing?link
There are some common reasons that you may not be able to find a Salesforce object that you're looking for:
- Fivetran cannot access the Salesforce object because the connecting user does not have sufficient Salesforce permissions.
- An installed package needs a license to view the associated custom objects. Assign your account a license.
- The missing column represents a "formula" or "compound" Salesforce object field.
- The table name is different from what you expected. Fivetran names the tables it creates in your data warehouse based on the Salesforce "name" field for a given object. This is a field that an organization gives to the object, and it may differ from the display name or internal "label."
Note that we do not sync any pre-aggregated objects or views because you already have access to the underlying source objects. We also do not sync archived objects because of Salesforce's limitations.
Can I sync empty objects and fields?link
Fivetran can sync empty objects and fields for your Salesforce connector. For more information, see our Features documentation.
How do I connect to the Salesforce Sandbox?link
Learn how in our Salesforce sandbox troubleshooting page.
Who sets the values of SystemModStamp?link
Fivetran doesn't set the values of SystemModStamp for the Salesforce objects. These values are set by Salesforce.
To provide more insight into our process, Fivetran adds the
_fivetran_synced column into each table. This column stores the sync end times for every record in the table.
What happens when I change a field name in Salesforce?link
If you change a field label that is displayed in Salesforce reports, it won't affect your connector.
If you change a field name, we keep the old field and add a new field in your destination table. However, old data will not get backfilled, and you have to trigger a table re-sync.
If you add a new column in the destination, any old values in that column won't be backfilled. If you remove permissions to a column and then grant permissions, Fivetran will only sync the new records and not the old ones. To fetch older data, you have to trigger a table re-sync.
How can I change the precision of the CURRENCY data type?link
For CURRENCY data type values, we use the precision and scale from the SObject Describe API to sync these values into the destination. You can increase the precision of the CURRENCY data type values from the Salesforce dashboard. For more information, see Salesforce's documentation.
What happens if I add new columns or custom fields in Salesforce?link
For each account that you connect, we create a different schema in your data warehouse. The schema we create maps closely to the native Salesforce schema so that the data is in a familiar format for you to work with. If the structure of the data in the source changes (for example, you add new columns, custom fields, or change a data type), Fivetran automatically detects and pushes these changes into your data warehouse.
Why is a table not updated every sync?link
Not all tables are updated at every sync. When Fivetran finds that an object in the source is not updated for seven days in a row, we switch our strategy to checking that infrequently updated object for new data once a day. When the object is updated in the source again, we return to our usual update strategy.
Because we only check infrequently updated objects once a day, there can be a delay of up to one day when an infrequently updated object is updated in the source for the first time.
Another reason a table is not updated every sync is that it could be a re-import object.
Fivetran automatically detects objects with the
replicateable = false value as re-import objects. We re-sync these objects because we can't capture deletes from them. These objects are included in the incremental sync but are re-imported in full at different frequencies.
The re-import frequency of the objects depends on how fast we can ingest data. The faster we can sync a table, the more frequently we will sync it.
|Object Import Duration||Import Frequency|
|3 seconds or less||Every sync|
|Between 3 seconds and 5 minutes||Twice a day|
|More than 5 minutes||Once a week|
We mark the re-imported tables as
notRecommended in the dashboard and include a message that we will re-import them in full if they are selected to be synced. We exclude the objects from incremental syncs by default because they degrade performance. However, you can select them to be synced.
Why are Formula Fields not synced?link
To ensure data integrity, you must recreate the formula fields after loading the data to your destination. To help with this, Fivetran provides the following:
FIVETRAN_FORMULA_MODELtables. For more information, see our Formula and Lookup Fields documentation.
- A pre-built, dbt Core-compatible set of data models for Salesforce for automation. For more information, see our Fivetran data models documentation. Find the model in Fivetran's dbt hub.
Why Are Tables in My Salesforce Connector Being Excluded?link
Learn why in our Tables Excluded troubleshooting page.
Why Am I Receiving an API Usage Limit Error?link
Salesforce limits the total inbound API requests (calls) for an organization. When your Salesforce account reaches 90% of the API call limitation, the Salesforce connector gets automatically rescheduled. Multiple connectors or different applications using the same Salesforce account exhaust the API call limitation.
To resolve this error, do either of the following:
- Tie different credentials to your Salesforce organization. Use different credentials for the Fivetran connectors and your internal applications so that the API calls are not shared among the Fivetran connectors and your internal applications.
- Increase the API requests limitation. For more information about Salesforce API limitations, see API Request Limits and Allocations.
Why Am I Receiving Incorrect Formula Field Values?link
You may receive incorrect formula field values if you are using an older version of the Salesforce Formula Utils dbt package. To resolve the issue, do the following:
- Make sure you are using the latest version of the dbt package.
- Create models using the recommended option.
If you still observe incorrect values, contact our support team.
Why Do History Tables Use Large Amounts of MAR?link
Learn why in our History Table MAR troubleshooting page.
Why Do I See an Increase in MAR?link
Learn why in our MAR Increase troubleshooting page.
How Can I Distinguish Between Bulk API and REST API Calls?link
Learn how in our Identify API Calls troubleshooting page.
How Does Fivetran Capture Deletes?link
Learn how in our Capture Deletes troubleshooting page.
How Is Decimal Precision Decided?link
Learn how in our Decimal Precision troubleshooting page.
How To Identify Deleted Rows?link
Learn how in our Identify Deleted Rows troubleshooting page.
Is the API Name or Text Value Replicated for Picklist Value?link
Learn which value will be visible in our Picklist Value troubleshooting page.
Why Is the
ACTIVITY Table Missing in my Salesforce Connector?link
Learn why in our ACTIVITY Table Missing troubleshooting page.
Why Is the
OPPORTUNITY_LINE_ITEM Table Not Capturing Deletes?link
How To Stop a Table-Level Historical Sync?link
Learn how in our Stop Historical Data Sync troubleshooting page.
Unable To Locate the
Learn why in our Locate FIVETRAN_FORMULA Table troubleshooting page.
What Happens To Records That Exist Temporarily?link
Learn how in our Temporary Records Capture troubleshooting page.
What Version of the Salesforce API Is Fivetran Using?link
Learn more in our API Version troubleshooting page.
Why Are Date Time Fields Different in Salesforce and My Destination?link
Learn why in our Different Date Time Fields troubleshooting page.
Why Is My Sync Taking Too Long After Adding a New Table?link
Learn why in our Prolonged Sync troubleshooting page.
Why Is the Connector Taking Longer Than Usual to Sync My Data?link
Learn why in our Longer Sync Time page.
Why Am I Receiving an Authentication Failed Error?link
Learn why in our Authentication Failed Error troubleshooting page.
Why Am I Unable to Re-Authorize an Existing Connection?link
What Should I Do to Resolve the Warning That Appears for the
FEED_COMMENT Table in My Connector Logs?link
Learn how in our
FEED_COMMENT Table Warning troubleshooting page.
Does the Salesforce Connector Sync Digital Files?link
Can I Connect to Salesforce With an API Only User?link
Learn in our API Only User troubleshooting page.
How do I Query Points In Time in Salesforce History Mode?link
Learn how in our Query Points in History Mode troubleshooting page.
Error: This App Is Blocked by Adminlink
Learn more in our App Is Blocked Error troubleshooting page.
Why Am I Seeing
Delete API Calls in the Connection Log?link
Learn why in our Delete API Calls in the Connection Log page.
How Can I Change the Salesforce User Authenticated With the Connection?link
Why Do I Have Empty Tables in the Destination?link
Learn why in our Empty Tables in the Destination page