> ## Documentation Index
> Fetch the complete documentation index at: https://firebolt-aggregate-helm-docs-pr-29.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> Learn about how to add and remove accounts in a Firebolt organization.

# Manage accounts

Your organization comes prepared with one account for your convenience. You can add more accounts, edit existing accounts, or delete accounts using SQL or in the UI.

To view all accounts, click **Configure** to open the configure space, then choose **Accounts** from the menu, or query the [information\_schema.accounts](/managed-service/organization/information-schema/accounts) view. For account-level settings and flags, query [information\_schema.account\_info](/reference-sql/information-schema/account_info).

## Create a new account

<Note>
  Creating an account requires the org\_admin role.
</Note>

### SQL

To create an account using SQL, use the [CREATE ACCOUNT](/reference-sql/commands/data-definition/create-account) statement. For example:

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
CREATE ACCOUNT dev WITH REGION = 'us-east-1';
```

### UI

To create an account via the UI:

<img src="https://mintcdn.com/firebolt-aggregate-helm-docs-pr-29/q0fg1CX5YWN85hCl/assets/images/accountspage.png?fit=max&auto=format&n=q0fg1CX5YWN85hCl&q=85&s=78809eb04c13cc57b6b8e6f9058d72de" alt="Configure > Accounts" data-og-width="3004" width="3004" data-og-height="608" height="608" data-path="assets/images/accountspage.png" data-optimize="true" data-opv="3" srcset="https://mintcdn.com/firebolt-aggregate-helm-docs-pr-29/q0fg1CX5YWN85hCl/assets/images/accountspage.png?w=280&fit=max&auto=format&n=q0fg1CX5YWN85hCl&q=85&s=15eca48c1da3ebeab0ed6022eb772c79 280w, https://mintcdn.com/firebolt-aggregate-helm-docs-pr-29/q0fg1CX5YWN85hCl/assets/images/accountspage.png?w=560&fit=max&auto=format&n=q0fg1CX5YWN85hCl&q=85&s=e869327486e788086d593df5c27cc648 560w, https://mintcdn.com/firebolt-aggregate-helm-docs-pr-29/q0fg1CX5YWN85hCl/assets/images/accountspage.png?w=840&fit=max&auto=format&n=q0fg1CX5YWN85hCl&q=85&s=ae508733ed85a4568de60df88d15984c 840w, https://mintcdn.com/firebolt-aggregate-helm-docs-pr-29/q0fg1CX5YWN85hCl/assets/images/accountspage.png?w=1100&fit=max&auto=format&n=q0fg1CX5YWN85hCl&q=85&s=e6ad67c9c51b269cb79708a52f8cc2dd 1100w, https://mintcdn.com/firebolt-aggregate-helm-docs-pr-29/q0fg1CX5YWN85hCl/assets/images/accountspage.png?w=1650&fit=max&auto=format&n=q0fg1CX5YWN85hCl&q=85&s=3ce569a27557f77b138bdd5b87c3495d 1650w, https://mintcdn.com/firebolt-aggregate-helm-docs-pr-29/q0fg1CX5YWN85hCl/assets/images/accountspage.png?w=2500&fit=max&auto=format&n=q0fg1CX5YWN85hCl&q=85&s=f5e5129af37dcb0045e82cc82c5eb8cd 2500w" />

1. Click **Configure** to open the configure space, then choose **Accounts** from the menu.

2. From the Accounts management page, choose **Create Account**.
   Type a name for the account and choose a region. You won't be able to change the region for this account later, so choose carefully.

3. Choose **Create**.

<img src="https://mintcdn.com/firebolt-aggregate-helm-docs-pr-29/q0fg1CX5YWN85hCl/assets/images/createaccount.png?fit=max&auto=format&n=q0fg1CX5YWN85hCl&q=85&s=9ed18181bd149e756e2b9e003c3c00c5" alt="Create account" style={{"width": "500px"}} width="1428" height="560" data-path="assets/images/createaccount.png" />

Then you will see your new account on the **Accounts management** page.

<Note>
  There can be up to 20 accounts per organization and you can use `CREATE ACCOUNT` 25 times. If you have a need for additional account creations beyond this limit, contact [Firebolt Support](/managed-service/support) for assistance. Our team can provide guidance and, if appropriate, adjust your account settings to accommodate your needs.
</Note>

## Edit an existing account

<Note>
  Editing an account requires the account\_admin or org\_admin role.
</Note>

### SQL

To edit an existing account using SQL, use the [ALTER ACCOUNT](/reference-sql/commands/data-definition/alter-account) statement. For example:

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
ALTER ACCOUNT dev RENAME TO staging;
```

### UI

To edit an account via the UI:

1. Click **Configure** to open the configure space, then choose **Accounts** from the menu.

2. Search for the relevant account using the top search filters or by scrolling through the accounts list. Hover over the right-most column to make the account menu appear then choose **Edit account**.
   Edit the name of the account.

3. Choose **Save**.

<img src="https://mintcdn.com/firebolt-aggregate-helm-docs-pr-29/q0fg1CX5YWN85hCl/assets/images/editaccount.png?fit=max&auto=format&n=q0fg1CX5YWN85hCl&q=85&s=39b50f43b875e64ef829c650bce0065b" alt="Edit account" style={{"width": "500px"}} width="1490" height="1126" data-path="assets/images/editaccount.png" />

## Delete an existing account

<Note>
  Deleting an account requires the account\_admin or org\_admin role.
</Note>

### SQL

To delete an existing account using SQL, use the [DROP ACCOUNT](/reference-sql/commands/data-definition/drop-account) statement. For example:

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
DROP ACCOUNT dev;
```

### UI

To delete an account via the UI:

1. Click **Configure** to open the configure space, then choose **Accounts** from the menu.

2. Search for the relevant account using the top search filters or by scrolling through the accounts list. Hover over the right-most column to make the account menu appear then choose **Delete account**.
   If your account is not empty (for example, if it contains other objects such as users/databases/engines/etc.), you will need to confirm that you will also delete the sub-objects by selecting **Delete account sub-objects permanently**.

3. Choose **Confirm**.

<img src="https://mintcdn.com/firebolt-aggregate-helm-docs-pr-29/q0fg1CX5YWN85hCl/assets/images/deleteaccount.png?fit=max&auto=format&n=q0fg1CX5YWN85hCl&q=85&s=70fc9735f18006b3c682046389aad678" alt="Delete account" style={{"width": "500px"}} width="1186" height="592" data-path="assets/images/deleteaccount.png" />

The account will be removed from the **Accounts management** page.

## Switch accounts

To switch the account you are using:

### UI

Click on your login button - the current account will be marked. Choose an account you would like to switch to.

<img src="https://mintcdn.com/firebolt-aggregate-helm-docs-pr-29/3hyWPBjtynNly254/assets/images/switch_account.png?fit=max&auto=format&n=3hyWPBjtynNly254&q=85&s=46ccb7f010a2a417557111c65f497cd6" alt="Switch account" style={{"width": "500px"}} width="1272" height="1154" data-path="assets/images/switch_account.png" />
