Question
How is Decimal Precision decided?
Environment
Connector: Salesforce
Answer
Decimal Precision is declared in the Salesforce API response.
To change Decimal Precision:
- Follow the Salesforce Overriding Salesforce Field Metadata guide.
- Resync the table.
Cause
Fivetran uses the precision Salesforce explicitly says to use. This is part of the field metadata as scale and precision.