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).
An SQL transformation could be used after loading data to the destination, where the total could be divided by 1000000 (e.g.,
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
Fivetran syncs raw data from Pinterest and uses minimal preprocessing. As such, when we pull data from the API, we receive it in the