> ## Documentation Index
> Fetch the complete documentation index at: https://firebolt-aggregate-helm-docs-pr-57.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-57/YROBHKEafxeq4ji2/assets/images/accountspage.png?fit=max&auto=format&n=YROBHKEafxeq4ji2&q=85&s=d4bb8cbd6a62d520828c78d2e4b57e9b" 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-57/YROBHKEafxeq4ji2/assets/images/accountspage.png?w=280&fit=max&auto=format&n=YROBHKEafxeq4ji2&q=85&s=7c39cc2db52e082a8a6bf9c400bac09e 280w, https://mintcdn.com/firebolt-aggregate-helm-docs-pr-57/YROBHKEafxeq4ji2/assets/images/accountspage.png?w=560&fit=max&auto=format&n=YROBHKEafxeq4ji2&q=85&s=962b9987f7899c2c63cc077409ac9407 560w, https://mintcdn.com/firebolt-aggregate-helm-docs-pr-57/YROBHKEafxeq4ji2/assets/images/accountspage.png?w=840&fit=max&auto=format&n=YROBHKEafxeq4ji2&q=85&s=1e3ddcfaf28f7b03ce474ba2b8e363fd 840w, https://mintcdn.com/firebolt-aggregate-helm-docs-pr-57/YROBHKEafxeq4ji2/assets/images/accountspage.png?w=1100&fit=max&auto=format&n=YROBHKEafxeq4ji2&q=85&s=088fcb6076c6fcb72cdccc5735cbf1d6 1100w, https://mintcdn.com/firebolt-aggregate-helm-docs-pr-57/YROBHKEafxeq4ji2/assets/images/accountspage.png?w=1650&fit=max&auto=format&n=YROBHKEafxeq4ji2&q=85&s=e3168841ec2674a4826a2b6907fa999c 1650w, https://mintcdn.com/firebolt-aggregate-helm-docs-pr-57/YROBHKEafxeq4ji2/assets/images/accountspage.png?w=2500&fit=max&auto=format&n=YROBHKEafxeq4ji2&q=85&s=b601408d4ae627ddfc78f25055448ad5 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-57/YROBHKEafxeq4ji2/assets/images/createaccount.png?fit=max&auto=format&n=YROBHKEafxeq4ji2&q=85&s=be6a53633887b0f046e218c13d7679b3" 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-57/YROBHKEafxeq4ji2/assets/images/editaccount.png?fit=max&auto=format&n=YROBHKEafxeq4ji2&q=85&s=f5c52a9eb0c27d0424f83b7b5361729a" 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-57/YROBHKEafxeq4ji2/assets/images/deleteaccount.png?fit=max&auto=format&n=YROBHKEafxeq4ji2&q=85&s=3531b242c7b6cb1a29d4c80c96fbe9f1" 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-57/Imv98m9UF7XmsMVQ/assets/images/switch_account.png?fit=max&auto=format&n=Imv98m9UF7XmsMVQ&q=85&s=9fe71948be69c09bedf6e4923a030e20" alt="Switch account" style={{"width": "500px"}} width="1272" height="1154" data-path="assets/images/switch_account.png" />
