Copy from S3 parquet to Redshift table

Question

Hi!  
I tried to copy parquet files from S3 to Redshift table but instead I got an error:

```
  Invalid operation: COPY from this file format only accepts IAM_ROLE credentials
 ```

I provide User credentials what should work according to that document:    
 "COPY command credentials must be supplied using an AWS Identity and Access Management (IAM) role as an argument for the IAM_ROLE parameter or the CREDENTIALS parameter."   
  
My code:

```
COPY {table_name}
FROM {path_to_s3}
CREDENTIALS 'aws_access_key_id=...;aws_secret_access_key=...'
FORMAT PARQUET
;
```

Is it possible to load parquet data using user credentials ?

Answer

> "COPY command credentials must be supplied using an AWS Identity and Access Management (IAM) **role** as an argument for the IAM_ROLE parameter or the CREDENTIALS parameter."   
You must use a **role** but you can declare the role to either the IAM_ROLE or CREDENTIALS parameters.

```
CREDENTIALS 'aws_iam_role=arn:aws:iam:::role/'
IAM_ROLE 'arn:aws:iam:::role/

Copy from S3 parquet to Redshift table

相關內容