Why Does the sku Data Type Differ Between Fivetran and the Recharge API?

Question

Why is the sku column's data type INT8 or BIGINT in my destination when the Recharge API reference defines the sku field as a STRING?

Environment

Connector: Recharge

Answer

We infer the data type based on the data returned during syncs, not the API reference. Although the Recharge API defines the sku field as a STRING, the values are often entirely numeric. When all values are numeric, we may infer a numeric data type, such as INT8 or BIGINT.