Create a database

1. Open the InfluxDB Cloud Dedicated Admin UI at

   https://console.influxdata.com
   

2. Use the credentials provided by InfluxData to log into the Admin UI. If you don’t have login credentials, contact InfluxData support.

3. In the cluster list, find and click the cluster you want to create a database in. You can sort on column headers or use the Search field to find a specific cluster.

4. Click the New Database button above the database list. The Create Database dialog displays.

   

5. In the Create Database dialog, provide the following information:

   • Database name: The name of the database to create. See Database naming restrictions.
   • Retention period: The retention period for the database. See Retention period syntax.
   • Max tables: The maximum number of tables (measurements) allowed in the database. Default is 500.
   • Max columns per table: The maximum number of columns allowed in each table (measurement). Default is 250.

6. Click the Create Database button to create the database. The new database displays in the list of databases for the cluster.

1. If you haven’t already, download and install the influxctl CLI, and then configure an influxctl connection profile for your cluster.

2. Run the influxctl database create command:

influxctl database create \
  --retention-period 
30d
 \
  
DATABASE_NAME

Replace DATABASE_NAME with your desired database name.

This example uses cURL to send a Management HTTP API request, but you can use any HTTP client.

1. If you haven’t already, follow the instructions to install cURL for your system.
2. In your terminal, use cURL to send a request to the following InfluxDB Cloud Dedicated endpoint:

POST https://console.influxdata.com/api/v0/accounts/ACCOUNT_ID/clusters/CLUSTER_ID/databases

curl \
  --location "https://console.influxdata.com/api/v0/accounts/
ACCOUNT_ID
/clusters/
CLUSTER_ID
/databases" \
  --header "Authorization: Bearer 
MANAGEMENT_TOKEN
" \
  --json '{
    "name": "
DATABASE_NAME
"
  }'

Replace the following:

• ACCOUNT_ID: the account ID for the cluster (list details via the Admin UI or CLI)
• CLUSTER_ID: the cluster ID (list details via the Admin UI or CLI).
• MANAGEMENT_TOKEN: a valid management token for your InfluxDB Cloud Dedicated cluster
• DATABASE_NAME: name for the new database

1. If you haven’t already, download and install the influxctl CLI.

2. Use the following influxctl database create command flags to specify the partition template parts:

   • --template-timeformat: A Rust strftime date and time string that specifies the time part in the partition template and determines the time interval to partition by. Use one of the following:

     • %Y-%m-%d (daily)
     • %Y-%m (monthly)
     • %Y (annually)

   • --template-tag: An [InfluxDB tag] to use in the partition template.

   • --template-tag-bucket: An InfluxDB tag and number of “buckets” to group tag values into. Provide the tag key and the number of buckets to bucket tag values into separated by a comma: tagKey,N.

influxctl database create \
  --retention-period 
30d
 \
  --template-tag 
TAG_KEY_1
 \
  --template-tag 
TAG_KEY_2
 \
  --template-tag-bucket 
TAG_KEY_3
,
100
 \
  --template-tag-bucket 
TAG_KEY_4
,
300
 \
  --template-timeformat '%Y-%m-%d' \
  
DATABASE_NAME

Replace the following:

• DATABASE_NAME: the name of the database to create
• TAG_KEY_1, TAG_KEY_2: tag keys to partition by
• TAG_KEY_3, TAG_KEY_4: tag keys for bucketed partitioning
• 100, 300: number of buckets to group tag values into
• ’%Y-%m-%d’: Rust strftime date and time string that specifies the time part in the partition template

This example uses cURL to send a Management HTTP API request, but you can use any HTTP client.

1. If you haven’t already, follow the instructions to install cURL for your system.
2. In your terminal, use cURL to send a request to the following InfluxDB Cloud Dedicated endpoint:

POST https://console.influxdata.com/api/v0/accounts/ACCOUNT_ID/clusters/CLUSTER_ID/databases

In the request body, include the partitionTemplate property and specify the partition template parts as an array of objects–for example:

curl \
  --location "https://console.influxdata.com/api/v0/accounts/
ACCOUNT_ID
/clusters/
CLUSTER_ID
/databases" \
  --header "Authorization: Bearer 
MANAGEMENT_TOKEN
" \
  --json '{
    "name": "
DATABASE_NAME
",
    "maxTables": 500,
    "maxColumnsPerTable": 250,
    "retentionPeriod": 2592000000000,
    "partitionTemplate": [
      { "type": "tag", "value": "
TAG_KEY_1
" },
      { "type": "tag", "value": "
TAG_KEY_2
" },
      { "type": "bucket", "value": { "tagName": "
TAG_KEY_3
", "numberOfBuckets": 
100
 } },
      { "type": "bucket", "value": { "tagName": "
TAG_KEY_4
", "numberOfBuckets": 
300
 } },
      { "type": "time", "value": "
%Y-%m-%d
" }
    ]
  }'

Replace the following:

• ACCOUNT_ID: the account ID for the cluster (list details via the Admin UI or CLI)
• CLUSTER_ID: the cluster ID (list details via the Admin UI or CLI).
• MANAGEMENT_TOKEN: a valid management token for your InfluxDB Cloud Dedicated cluster
• DATABASE_NAME: name for the new database
• TAG_KEY_1, TAG_KEY_2: tag keys to partition by
• TAG_KEY_3, TAG_KEY_4: tag keys for bucketed partitioning
• 100, 300: number of buckets to group tag values into
• ’%Y-%m-%d’: Rust strftime date and time string that specifies the time part in the partition template

Use the --retention-period flag to define the retention period as a duration. For example, 30d means 30 days. A zero duration (0d) keeps data indefinitely.

Use the retentionPeriod property to specify the retention period as nanoseconds. For example, 2592000000000 means 30 days. A value of 0 keeps data indefinitely.

Example values

• 0: infinite/none
• 259200000000000: 3 days
• 2592000000000000: 30 days
• 31536000000000000: 1 standard year (365 days)