> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-postgresql-tls-support.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# How to create an AWS IAM user and S3 bucket

> How to create an AWS IAM user and S3 bucket.

export const Image = ({img, alt, size = "lg"}) => {
  const normalizedSize = ["sm", "md", "lg"].includes(size) ? size : "lg";
  return <div className={`ch-image-${normalizedSize}`}>
      <Frame>
        <img src={img} alt={alt} />
      </Frame>
    </div>;
};

> This guide shows you how you can set up an IAM user and S3 bucket in AWS,
> a prerequisite step for taking backups to S3 or configuring ClickHouse to
> store data on S3

<h2 id="create-an-aws-iam-user">
  Create an AWS IAM user
</h2>

In this procedure, we'll be creating a service account user, not a login user.

1. Log into the AWS IAM Management Console.

2. In the `Users` tab, select `Create user`

<Image size="lg" img="https://mintcdn.com/private-7c7dfe99-postgresql-tls-support/cTIaEq6k6KYDgBI1/images/_snippets/s3/2025/s3-1.webp?fit=max&auto=format&n=cTIaEq6k6KYDgBI1&q=85&s=6652145afb02ddacab5f8f19ce1cf03a" alt="AWS IAM Management Console - Adding a new user" width="4040" height="1940" data-path="images/_snippets/s3/2025/s3-1.webp" />

3. Enter a user-name

<Image size="lg" img="https://mintcdn.com/private-7c7dfe99-postgresql-tls-support/cTIaEq6k6KYDgBI1/images/_snippets/s3/2025/s3-2.webp?fit=max&auto=format&n=cTIaEq6k6KYDgBI1&q=85&s=827c2eb10bd567ed20064de3a51123da" alt="AWS IAM Management Console - Adding a new user" width="4040" height="1408" data-path="images/_snippets/s3/2025/s3-2.webp" />

4. Select `Next`

<Image size="lg" img="https://mintcdn.com/private-7c7dfe99-postgresql-tls-support/cTIaEq6k6KYDgBI1/images/_snippets/s3/2025/s3-3.webp?fit=max&auto=format&n=cTIaEq6k6KYDgBI1&q=85&s=ae570c728118f6d0e9494e2bb93ee79d" alt="AWS IAM Management Console - Adding a new user" width="4040" height="1860" data-path="images/_snippets/s3/2025/s3-3.webp" />

5. Select `Next`

<Image size="lg" img="https://mintcdn.com/private-7c7dfe99-postgresql-tls-support/cTIaEq6k6KYDgBI1/images/_snippets/s3/2025/s3-4.webp?fit=max&auto=format&n=cTIaEq6k6KYDgBI1&q=85&s=bd412e333ebe6dba4606baf78972029c" alt="AWS IAM Management Console - Adding a new user" width="4040" height="1850" data-path="images/_snippets/s3/2025/s3-4.webp" />

6. Select `Create user`

The user is now created.
Click on the newly created user

<Image size="lg" img="https://mintcdn.com/private-7c7dfe99-postgresql-tls-support/cTIaEq6k6KYDgBI1/images/_snippets/s3/2025/s3-5.webp?fit=max&auto=format&n=cTIaEq6k6KYDgBI1&q=85&s=1bb21432e70e52da24773e79142439f8" alt="AWS IAM Management Console - Adding a new user" width="4040" height="792" data-path="images/_snippets/s3/2025/s3-5.webp" />

7. Select `Create access key`

<Image size="lg" img="https://mintcdn.com/private-7c7dfe99-postgresql-tls-support/cTIaEq6k6KYDgBI1/images/_snippets/s3/2025/s3-6.webp?fit=max&auto=format&n=cTIaEq6k6KYDgBI1&q=85&s=23c210fc5aafcd7a1ed4b68ea1157ca1" alt="AWS IAM Management Console - Adding a new user" width="4040" height="1900" data-path="images/_snippets/s3/2025/s3-6.webp" />

8. Select `Application running outside AWS`

<Image size="lg" img="https://mintcdn.com/private-7c7dfe99-postgresql-tls-support/cTIaEq6k6KYDgBI1/images/_snippets/s3/2025/s3-7.webp?fit=max&auto=format&n=cTIaEq6k6KYDgBI1&q=85&s=a7d072ab99a6fce999f16390b59c94e3" alt="AWS IAM Management Console - Adding a new user" width="4040" height="1942" data-path="images/_snippets/s3/2025/s3-7.webp" />

9. Select `Create access key`

<Image size="lg" img="https://mintcdn.com/private-7c7dfe99-postgresql-tls-support/cTIaEq6k6KYDgBI1/images/_snippets/s3/2025/s3-8.webp?fit=max&auto=format&n=cTIaEq6k6KYDgBI1&q=85&s=dddc9a86993812c5c59e3a3d060bbccb" alt="AWS IAM Management Console - Adding a new user" width="4040" height="1080" data-path="images/_snippets/s3/2025/s3-8.webp" />

10. Download your access key and secret as a .csv for use later

<Image size="lg" img="https://mintcdn.com/private-7c7dfe99-postgresql-tls-support/cTIaEq6k6KYDgBI1/images/_snippets/s3/2025/s3-9.webp?fit=max&auto=format&n=cTIaEq6k6KYDgBI1&q=85&s=0f8f70a319ad160d57d94c9ba9f84a7c" alt="AWS IAM Management Console - Adding a new user" width="3912" height="2036" data-path="images/_snippets/s3/2025/s3-9.webp" />

<h2 id="create-an-s3-bucket">
  Create an S3 bucket
</h2>

1. In the S3 bucket section, select **Create bucket**

<Image size="lg" img="https://mintcdn.com/private-7c7dfe99-postgresql-tls-support/cTIaEq6k6KYDgBI1/images/_snippets/s3/2025/s3-10.webp?fit=max&auto=format&n=cTIaEq6k6KYDgBI1&q=85&s=06d54244dcb42a585064b7e4811a9a4d" alt="AWS IAM Management Console - Adding a new user" width="4040" height="2518" data-path="images/_snippets/s3/2025/s3-10.webp" />

2. Enter a bucket name, leave other options default

<Image size="lg" img="https://mintcdn.com/private-7c7dfe99-postgresql-tls-support/cTIaEq6k6KYDgBI1/images/_snippets/s3/2025/s3-11.webp?fit=max&auto=format&n=cTIaEq6k6KYDgBI1&q=85&s=3f33392f9b987bfa55f074ad068177e4" alt="AWS IAM Management Console - Adding a new user" width="4040" height="1118" data-path="images/_snippets/s3/2025/s3-11.webp" />

<Note>
  The bucket name must be unique across AWS, not just the organization, or it will emit an error.
</Note>

3. Leave `Block all Public Access` enabled; public access isn't needed.

<Image size="lg" img="https://mintcdn.com/private-7c7dfe99-postgresql-tls-support/cTIaEq6k6KYDgBI1/images/_snippets/s3/2025/s3-12.webp?fit=max&auto=format&n=cTIaEq6k6KYDgBI1&q=85&s=0aa771e18100a2759da44077396ccf0a" alt="AWS IAM Management Console - Adding a new user" width="4040" height="1106" data-path="images/_snippets/s3/2025/s3-12.webp" />

4. Select **Create Bucket** at the bottom of the page

<Image size="lg" img="https://mintcdn.com/private-7c7dfe99-postgresql-tls-support/cTIaEq6k6KYDgBI1/images/_snippets/s3/2025/s3-13.webp?fit=max&auto=format&n=cTIaEq6k6KYDgBI1&q=85&s=62dd9ebe870d249f7c4a1d1a1b26eaed" alt="AWS IAM Management Console - Adding a new user" width="4040" height="1872" data-path="images/_snippets/s3/2025/s3-13.webp" />

5. Select the link, copy the ARN, and save it for use when configuring the access policy for the bucket

<Image size="lg" img="https://mintcdn.com/private-7c7dfe99-postgresql-tls-support/cTIaEq6k6KYDgBI1/images/_snippets/s3/2025/s3-14.webp?fit=max&auto=format&n=cTIaEq6k6KYDgBI1&q=85&s=f0815ce4ef892d31910f66a63cb014df" alt="AWS IAM Management Console - Adding a new user" width="4040" height="934" data-path="images/_snippets/s3/2025/s3-14.webp" />

6. Once the bucket has been created, find the new S3 bucket in the S3 buckets list and select the bucket name which will take you to the page shown below:

<Image size="lg" img="https://mintcdn.com/private-7c7dfe99-postgresql-tls-support/cTIaEq6k6KYDgBI1/images/_snippets/s3/2025/s3-15.webp?fit=max&auto=format&n=cTIaEq6k6KYDgBI1&q=85&s=722c8ff5485ea64ea74d9c64584830da" alt="AWS IAM Management Console - Adding a new user" width="4040" height="1400" data-path="images/_snippets/s3/2025/s3-15.webp" />

7. Select `Create folder`

8. Enter a folder name that will be the target for the ClickHouse S3 disk or backup and select `Create folder` at the bottom of the page

<Image size="lg" img="https://mintcdn.com/private-7c7dfe99-postgresql-tls-support/cTIaEq6k6KYDgBI1/images/_snippets/s3/2025/s3-16.webp?fit=max&auto=format&n=cTIaEq6k6KYDgBI1&q=85&s=676fa427555bed9aef7ff49abea2fcc2" alt="AWS IAM Management Console - Adding a new user" width="3992" height="1352" data-path="images/_snippets/s3/2025/s3-16.webp" />

9. The folder should now be visible on the bucket list

<Image size="lg" img="https://mintcdn.com/private-7c7dfe99-postgresql-tls-support/cTIaEq6k6KYDgBI1/images/_snippets/s3/2025/s3-17.webp?fit=max&auto=format&n=cTIaEq6k6KYDgBI1&q=85&s=deb7fb166c99ad6728f7c41f4bea3587" alt="AWS IAM Management Console - Adding a new user" width="4040" height="1330" data-path="images/_snippets/s3/2025/s3-17.webp" />

10. Select the checkbox for the new folder and click on `Copy URL`. Save the URL for use in the ClickHouse storage configuration in the next section.

<Image size="lg" img="https://mintcdn.com/private-7c7dfe99-postgresql-tls-support/cTIaEq6k6KYDgBI1/images/_snippets/s3/2025/s3-18.webp?fit=max&auto=format&n=cTIaEq6k6KYDgBI1&q=85&s=4960ebfa983d3122018739dd67e96bf4" alt="AWS IAM Management Console - Adding a new user" width="4040" height="992" data-path="images/_snippets/s3/2025/s3-18.webp" />

11. Select the **Permissions** tab and click on the **Edit** button in the **Bucket Policy** section

<Image size="lg" img="https://mintcdn.com/private-7c7dfe99-postgresql-tls-support/cTIaEq6k6KYDgBI1/images/_snippets/s3/2025/s3-19.webp?fit=max&auto=format&n=cTIaEq6k6KYDgBI1&q=85&s=71e303340ce5a75cfc78692bf717894e" alt="AWS IAM Management Console - Adding a new user" width="4040" height="954" data-path="images/_snippets/s3/2025/s3-19.webp" />

12. Add a bucket policy, example below

```json theme={null}
{
    "Version": "2012-10-17",
    "Id": "Policy123456",
    "Statement": [
        {
            "Sid": "abc123",
            "Effect": "Allow",
            "Principal": {
                "AWS": "arn:aws:iam::782985192762:user/docs-s3-user"
            },
            "Action": "s3:*",
            "Resource": [
                "arn:aws:s3:::ch-docs-s3-bucket",
                "arn:aws:s3:::ch-docs-s3-bucket/*"
            ]
        }
    ]
}
```

<Note>
  The policy above makes it possible to perform all actions on the bucket
</Note>

| Parameter | Description                                                 | Example Value                                                         |
| --------- | ----------------------------------------------------------- | --------------------------------------------------------------------- |
| Version   | Version of the policy interpreter, leave as-is              | 2012-10-17                                                            |
| Sid       | User-defined policy id                                      | abc123                                                                |
| Effect    | Whether user requests will be allowed or denied             | Allow                                                                 |
| Principal | The accounts or user that will be allowed                   | arn:aws:iam::782985192762:user/docs-s3-user                           |
| Action    | What operations are allowed on the bucket                   | s3:\*                                                                 |
| Resource  | Which resources in the bucket will operations be allowed in | "arn:aws:s3:::ch-docs-s3-bucket", "arn:aws:s3:::ch-docs-s3-bucket/\*" |

<Note>
  You should work with your security team to determine the permissions to be used, consider these as a starting point.
  For more information on Policies and settings, refer to AWS documentation:
  [https://docs.aws.amazon.com/AmazonS3/latest/userguide/access-policy-language-overview.html](https://docs.aws.amazon.com/AmazonS3/latest/userguide/access-policy-language-overview.html)
</Note>

13. Save the policy configuration
