> ## Documentation Index
> Fetch the complete documentation index at: https://clickhouse.com/docs/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/CFFsa2agBPbviR4r/images/_snippets/s3/2025/s3-1.webp?fit=max&auto=format&n=CFFsa2agBPbviR4r&q=85&s=5981591d51b6f0e75ccabfbf2c2592dd" 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/CFFsa2agBPbviR4r/images/_snippets/s3/2025/s3-2.webp?fit=max&auto=format&n=CFFsa2agBPbviR4r&q=85&s=826ae6a942c88af0a5189d5aba0577bd" 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/CFFsa2agBPbviR4r/images/_snippets/s3/2025/s3-3.webp?fit=max&auto=format&n=CFFsa2agBPbviR4r&q=85&s=8e70cf0524585ef59b3efddb9da1495a" 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/CFFsa2agBPbviR4r/images/_snippets/s3/2025/s3-4.webp?fit=max&auto=format&n=CFFsa2agBPbviR4r&q=85&s=90c3b7dcf79ad5cf235aac92472312a1" 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/CFFsa2agBPbviR4r/images/_snippets/s3/2025/s3-5.webp?fit=max&auto=format&n=CFFsa2agBPbviR4r&q=85&s=d92969676845ca4fc60d6190b3723e76" 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/CFFsa2agBPbviR4r/images/_snippets/s3/2025/s3-6.webp?fit=max&auto=format&n=CFFsa2agBPbviR4r&q=85&s=fbe63ebdc53c0bcc1ccf38d6e2389161" 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/CFFsa2agBPbviR4r/images/_snippets/s3/2025/s3-7.webp?fit=max&auto=format&n=CFFsa2agBPbviR4r&q=85&s=bb7786aaef483965ac41a2bb85b29c1a" 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/CFFsa2agBPbviR4r/images/_snippets/s3/2025/s3-8.webp?fit=max&auto=format&n=CFFsa2agBPbviR4r&q=85&s=c4c941586095414726fa125cf356bfac" 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/CFFsa2agBPbviR4r/images/_snippets/s3/2025/s3-9.webp?fit=max&auto=format&n=CFFsa2agBPbviR4r&q=85&s=50b6dc25424210feb1dac03736193154" 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/CFFsa2agBPbviR4r/images/_snippets/s3/2025/s3-10.webp?fit=max&auto=format&n=CFFsa2agBPbviR4r&q=85&s=accd3f7aa98107f682fcf2167de9db13" 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/CFFsa2agBPbviR4r/images/_snippets/s3/2025/s3-11.webp?fit=max&auto=format&n=CFFsa2agBPbviR4r&q=85&s=4821eb695c3e1c3f767b4685bb6fee7d" 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/CFFsa2agBPbviR4r/images/_snippets/s3/2025/s3-12.webp?fit=max&auto=format&n=CFFsa2agBPbviR4r&q=85&s=44e7deaf9c8a8350d840442a1c9647b0" 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/CFFsa2agBPbviR4r/images/_snippets/s3/2025/s3-13.webp?fit=max&auto=format&n=CFFsa2agBPbviR4r&q=85&s=4bfdd4c922499417efe6a687e15c67d7" 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/CFFsa2agBPbviR4r/images/_snippets/s3/2025/s3-14.webp?fit=max&auto=format&n=CFFsa2agBPbviR4r&q=85&s=42e220c6554e9d0164fb1095ec375098" 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/CFFsa2agBPbviR4r/images/_snippets/s3/2025/s3-15.webp?fit=max&auto=format&n=CFFsa2agBPbviR4r&q=85&s=509cf27e3844b9bd331f0fc546f2335b" 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/CFFsa2agBPbviR4r/images/_snippets/s3/2025/s3-16.webp?fit=max&auto=format&n=CFFsa2agBPbviR4r&q=85&s=36935c5e148e7710698a969ed7fc37a3" 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/CFFsa2agBPbviR4r/images/_snippets/s3/2025/s3-17.webp?fit=max&auto=format&n=CFFsa2agBPbviR4r&q=85&s=77d3fd57f04a29ede83d51615a2244c1" 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/CFFsa2agBPbviR4r/images/_snippets/s3/2025/s3-18.webp?fit=max&auto=format&n=CFFsa2agBPbviR4r&q=85&s=b84c63145363d5b3ebdc18002b3ac0fa" 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/CFFsa2agBPbviR4r/images/_snippets/s3/2025/s3-19.webp?fit=max&auto=format&n=CFFsa2agBPbviR4r&q=85&s=c3fb7bf2d59bce914850d64a71125854" 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
