This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Using the bulkloader, I'm trying to update a Redshift table...but get the following error:
Output Data (23) The COPY failed with error: [Amazon][RedShift ODBC] (30) Error occurred while trying to execute a query: ERROR: Load into table 'subscriptionattributiontl' failed. Check 'stl_load_errors' system table for details.¶ Last entry in stl_load_errors: 1207, Invalid digit, Value 'e', Pos 0, Type: Double
At first glance, the error message seems to be referencing record 1207, with perhaps some improper characters. I would investigate around that area in your data and try uploading just single rows to see if you can narrow down exactly what's causing the issue.
To follow up...Brandon had mentioned that it might be a "permission issue", and I did notice that I didn't have access to the table that this query was pulling from. I was helping the owner out and updated the S3 Access/secret keys with the new keys without any issue. The scheduled workflow was running fine. But, for some reason later in the week I got the above error.
Bottom line, the owner went ahead and updated the workflow with new keys and the workflow has been running fine since.