Our attempts to replicate the Stripe BalanceTransaction table are consistently failing. The run logs report the following error: "Object error / Value was either too large or too small for an Int32.: [Value: '-2182099740', Table: "BalanceTransactions", Column: "Amount", Id: '']"
Doing our own investigation for the data in the account, we have not identified any records that approach the indicated value (over $-2b??). The closest we could find was some kind of balancing entry for $-17985916 ($-17m).
Moreover, we adjusted the size of the target table (Redshift "bigint" data type) in order to accommodate this value - but that change had no effect.
Two questions:
1) Can you tell us the ID of the record that is throwing this error?
2) Why did changing the data type of the target table have no effect on the error? Is this error being thrown by some internal intermediary table that you use for processing the data before loading to the destination?
Thanks in advance.