I have a “for each” snap that calls a pipeline to connect to Google Analytics query explorer and extracts the data for 20 different websites. The problem that I encounter is that when I execute the “for each” for multiple interactions, I get the following:
Error copying data from S3 to Redshift.
Fix issue which caused copy to fail.
[Amazon]JDBC Parameters cannot be used with normal Statement objects, use PreparedStatements instead.
The error is always at a random website connection and it always happens when I execute the “for each” for more than 1 day.
Each “for each” interaction is doing 20 different connections per day for x amount of dates.