docs-v2/content/shared/influxdb3-cli/create/file_index.md

The influxdb3 create file_index command creates a new file index for a database or table.

Usage

influxdb3 create file_index [OPTIONS] --database <DATABASE_NAME> <COLUMNS>...

Arguments

• COLUMNS: The columns to use for the file index.

Options

Option		Description
-H	--host	Host URL of the running {{< product-name >}} server (default is http://127.0.0.1:8181)
-d	--database	({{< req >}}) Name of the database to operate on
	--token	Authentication token
-t	--table	Table to apply the file index too
-h	--help	Print help information

Option environment variables

You can use the following environment variables to set command options:

Environment Variable	Option
INFLUXDB3_HOST_URL	--host
INFLUXDB3_DATABASE_NAME	--database
INFLUXDB3_AUTH_TOKEN	--token

Examples

• Create a new file index for a database
• Create a new file index for a specific table

In the examples below, replace the following:

• {{% code-placeholder-key %}}DATABASE_NAME{{% /code-placeholder-key %}}: Database name
• {{% code-placeholder-key %}}TABLE_NAME{{% /code-placeholder-key %}}: Table name

{{% code-placeholders "(DATABASE|TABLE)_NAME" %}}

Create a new file index for a database

influxdb3 create file_index \
  --database DATABASE_NAME \
  column1 column2 column3

Create a new file index for a specific table

influxdb3 create file_index \
  --database DATABASE_NAME \
  --table TABLE_NAME \
  column1 column2 column3

{{% /code-placeholders %}}