Values for spend_in_micro_dollar Displayed in INT8 Format

Issue

In Pinterest, values for the metric, spend_in_micro_dollar, are displayed in a DECIMAL format. However, in the destination, values are displayed in INT8 format.

For example, a value of 2089.27 appears as 2089265952 in the destination.

Environment

Connector: Pinterest Ads

Resolution

After loading data to the destination, use a SQL transformation to divide the total by 1000000. For example, spend_in_micro_dollar/1000000.

Cause

Fivetran syncs raw data from Pinterest and uses minimal preprocessing. When data is pulled from API, it is received in INT8 format.