COPY FROM S3 OBJECT WORKING ON CLI BUT NOT WORKING WHILE ON CODE.

My objective is to dump s3 file data into temp table. I tried create a temp_Data table and execute COPY Command with valid aws region, aws access key and secret key.
COPY FROM S3 OBJECT COPY temp_Data ("userid", "user_name") FROM 's3://app-upload/data.csv.gz' GZIP DELIMITER ',' ENCLOSED BY '"' NULL AS 'NULL'
Over it. When I execute it locally it inserts users into vsql . But when I execute on golang it fails saying Unable to do get rows impacted no RowsAffected available after DDL statement what can be the reason of failure

Tagged:

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file