command = f"COPY {extract_table.table_name} from S3_LOCATION({escape_string_literal(path_to_csv)},
ACCESS_KEY_ID 'somekey',
SECRET_ACCESS_KEY 'someid',
REGION 'us-east-2')"
Please let me know how i can make this work, tried different syntaxes but still doesn't work (doesn't work only for s3 CSV files).
3 answers
This looks like an issue on the AWS side. There is a problem wth the access key you've provided. Check that access key and make sure it's correct. https://aws.amazon.com/premiumsupport/knowledge-center/s3-access-key-error/