QuickSight cannot connect to S3 bucket

Question

I tried to create a dataset by linking to S3 in QuickSight, by attempting to upload manifest.json files containing either JSON or CSV URIs as below:

JSON:
```
{
  "fileLocations": [
    {
      "URIs": [
        "s3://yucheng816/dummy/dummy.json"
      ]
    }
  ],
  "globalUploadSettings": {
    "format": "JSON"
  }
}
```

CSV:

```
{
  "fileLocations": [
    {
      "URIs": [
        "s3://yucheng816/dummy/dummy.csv"
      ]
    }
  ],
  "globalUploadSettings": {
    "format": "CSV",
    "delimiter": ",",
    "textqualifier": "\"",
    "containsHeader": "true"
  }
}

```
I also tried "providing an URL for manifest.json"(after uploading it to S3) and "uploading the manifest.json". But they all sent me errors as: **"We can’t connect to this S3 bucket. Make sure any S3 buckets you specify are associated with the AWS account used to create this QuickSight account."** and **"We cannot find or cannot access one or more of the buckets listed in the manifest. Follow the instructions atManaging Amazon QuickSight Permissions to AWS Resources to grant QuickSight permissions to that Amazon S3 bucket."**.

I noticed that in the S3 "Permissions", it says **"Block Public Access settings for this account are currently turned on"**, but I don't think connecting S3 bucket to QuickSight under the same account is public access?

Would appreciate any help!

re:Post Agent · Answer

To resolve the connection issue between QuickSight and your S3 bucket, you need to explicitly grant QuickSight permission to access your S3 bucket. This is required even when both services are in the same AWS account.

Here's how to fix the issue:

1. In the QuickSight console, click on your profile icon in the top-right corner
2. Select "Manage QuickSight"
3. Choose "Security & permissions"
4. Under "QuickSight access to AWS services", click "Manage"
5. Select "Select S3 buckets"
6. On the "Select Amazon S3 buckets" screen, find and select your bucket "yucheng816"
7. Click "Select buckets" to confirm your selection
8. Click "Finish" and "Save" to apply the changes

After granting these permissions, try creating your dataset again by uploading your manifest file.

The error you're seeing isn't related to the S3 bucket's public access settings. The "Block Public Access" setting prevents public internet access to your bucket, but it doesn't affect service-to-service permissions within AWS. QuickSight needs explicit permission to access your S3 bucket regardless of whether they're in the same account.

If you continue to have issues, verify that:
1. Your manifest file format is correct
2. The S3 paths in your manifest file are accurate
3. You're referencing your bucket directly with the proper syntax (which you are with "s3://yucheng816/dummy/dummy.csv")  
**Sources**  
[I can't connect to Amazon S3 - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/troubleshoot-connect-S3.html)  
[Datasets using S3 files in another AWS account - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/using-s3-files-in-another-aws-account.html)  
[Integrate private Amazon S3 hosted images with Amazon QuickSight dashboards | AWS Business Intelligence Blog](https://aws.amazon.com/blogs/business-intelligence/integrate-private-amazon-s3-hosted-images-with-amazon-quicksight-dashboards/)

QuickSight cannot connect to S3 bucket

Add your answer

Relevant content