CREATE ACCOUNT

Creates a new account. For more information, see Managing accounts.

Organizations can have 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 for assistance. Our team can provide guidance and, if appropriate, adjust your account settings to accommodate your needs.

Syntax

CREATE ACCOUNT [IF NOT EXISTS] <account_name>
[ WITH REGION = <region> ]

Parameters

Parameter	Description
`<account_name>`	The name of the account, must start and end with an alphabetic character and cannot contain spaces or special characters except for hyphens (-).
`<region>`	The region in which the account is configured. Choose the same region as the Amazon S3 bucket that contains data you ingest. See Available AWS Regions If not specified, `us-east-1` US East (N. Virginia) is the default.

Example

The following command will create an account in the US East (N. Virginia) region.

CREATE ACCOUNT dev WITH REGION = “us-east-1”

COMMENT ON

CREATE AGGREGATING INDEX

⌘I

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

Syntax

Parameters

Example

​Syntax

​Parameters

​Example

Syntax

Parameters

Example