Edit on GitHub
How Is the Decimal Precision Decided?link
Updated 12 days ago
Questionlink
How does Fivetran decide the decimal precision?
Environmentlink
Connector: Salesforce
Answerlink
Salesforce specifies the decimal precision in the API response.
To change the decimal precision, do the following:
Follow Salesforce's Overriding Salesforce Field Metadata documentation.
Re-sync the table.
Causelink
Fivetran uses the precision that Salesforce specifies explicitly. It is part of the field metadata as scale and precision.