> ## Documentation Index
> Fetch the complete documentation index at: https://firebolt-aggregate-helm-docs-pr-38.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-38/7vSNEQr6u5OWakTj/assets/images/accountspage.png?fit=max&auto=format&n=7vSNEQr6u5OWakTj&q=85&s=f72ad16805b1b79e4ecbe0e30b70c0b0" 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-38/7vSNEQr6u5OWakTj/assets/images/accountspage.png?w=280&fit=max&auto=format&n=7vSNEQr6u5OWakTj&q=85&s=bc816bfa4e2da575a332e82c332439c0 280w, https://mintcdn.com/firebolt-aggregate-helm-docs-pr-38/7vSNEQr6u5OWakTj/assets/images/accountspage.png?w=560&fit=max&auto=format&n=7vSNEQr6u5OWakTj&q=85&s=d1637b9100f1839ca7ee5bfc609b7029 560w, https://mintcdn.com/firebolt-aggregate-helm-docs-pr-38/7vSNEQr6u5OWakTj/assets/images/accountspage.png?w=840&fit=max&auto=format&n=7vSNEQr6u5OWakTj&q=85&s=872e64d326d7511ed52bee9196d1406a 840w, https://mintcdn.com/firebolt-aggregate-helm-docs-pr-38/7vSNEQr6u5OWakTj/assets/images/accountspage.png?w=1100&fit=max&auto=format&n=7vSNEQr6u5OWakTj&q=85&s=04735975997e6de6c3bcafa862e44799 1100w, https://mintcdn.com/firebolt-aggregate-helm-docs-pr-38/7vSNEQr6u5OWakTj/assets/images/accountspage.png?w=1650&fit=max&auto=format&n=7vSNEQr6u5OWakTj&q=85&s=67bb12ab271a8717b608ef094300ef8e 1650w, https://mintcdn.com/firebolt-aggregate-helm-docs-pr-38/7vSNEQr6u5OWakTj/assets/images/accountspage.png?w=2500&fit=max&auto=format&n=7vSNEQr6u5OWakTj&q=85&s=c08b9cbb2f50f0c567e5edc0249d33d1 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-38/7vSNEQr6u5OWakTj/assets/images/createaccount.png?fit=max&auto=format&n=7vSNEQr6u5OWakTj&q=85&s=86b1aa441585331a7a315f83b75bc81e" 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-38/7vSNEQr6u5OWakTj/assets/images/editaccount.png?fit=max&auto=format&n=7vSNEQr6u5OWakTj&q=85&s=9e4753c851b5ac533d56ed9678d3306a" 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-38/7vSNEQr6u5OWakTj/assets/images/deleteaccount.png?fit=max&auto=format&n=7vSNEQr6u5OWakTj&q=85&s=d557ec551ade64eb2e0a6a6a5be609c4" 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-38/nZupdONjCOlfABkX/assets/images/switch_account.png?fit=max&auto=format&n=nZupdONjCOlfABkX&q=85&s=d89f3badcea766b57bda06bea537fab1" alt="Switch account" style={{"width": "500px"}} width="1272" height="1154" data-path="assets/images/switch_account.png" />
