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
Question
COPY FROM S3 OBJECT WORKING ON CLI BUT NOT WORKING WHILE ON CODE.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.