A staging Amazon S3 bucket is required and is not configured. Go to account settings to configure a staging S3 bucket.

Question

I am using Redshift and trying to upload data from my local device through the Query Editor v2.  I receive the error message "A staging Amazon S3 bucket is required and is not configured. Go to account settings to configure a staging S3 bucket."  However, there is no account settings that I can find within Redshift.  I must be missing the obvious and would appreciate if someone can help.

Accepted Answer

Hi Samuel,

To update the account settings you need to click on the gear icon on the lower left of the Query Editor v2 page (see below).

![QEv2 settings](/media/postImages/original/IMqB0IZAjPQ2mZOq_dsA5sEg)

From here you can choose the 'Account Settings' option, and then update the S3 URI.

When you upload data to Redshift from the QEv2 loader, it will be staged in the S3 bucket specified in this account configuration. From there QEv2 will copy the data into Redshift.

Answer

Hello

I think these links might be helpful for you -

https://docs.aws.amazon.com/redshift/latest/mgmt/query-editor-v2-loading.html
https://aws.amazon.com/blogs/big-data/data-load-made-easy-and-secure-in-amazon-redshift-using-query-editor-v2/

There might be some permission issues with you accessing the account setting. Please take a look at this link - https://docs.aws.amazon.com/redshift/latest/mgmt/query-editor-v2-using.html

Thanks

A staging Amazon S3 bucket is required and is not configured. Go to account settings to configure a staging S3 bucket.

Contenus pertinents