Issue

In the Pinterest UI, the metric spend_in_micro_dollar appears as 2089.27 (decimal format). However, in the destination, it appears as 2089265952 (int8 format).

Environment

Connector: Pinterest

Answer

An SQL transformation could be used after loading data to the destination, where the total could be divided by 1000000 (e.g., spend_in_micro_dollar/1000000).

Here is a query to convert this in Oracle:

nvl(round((convert(decimal(16, 2), cr.spend_in_micro_dollar)/1000000), 2), 0) as spend

Cause

Fivetran syncs raw data from Pinterest and uses minimal preprocessing. As such, when we pull data from the API, we receive it in the int8 format.