Create a custom file index

Use the influxdb3 create file_index command to create a custom file indexing strategy for a database or table.

Provide the following:

• Token (--token): ({{< req >}}) Your {{% token-link "admin" %}}. You can also use the INFLUXDB3_AUTH_TOKEN environment variable to specify the token.
• Database (-d, --database): ({{< req >}}) The name of the database to apply the index to. You can also use the INFLUXDB3_DATABASE_NAME environment variable to specify the database.
• Table (-t, --table): The name of the table to apply the index to. If no table is specified, the indexing strategy applies to all tables in the specified database.
• Columns: ({{< req >}}) A comma-separated list of string columns to index on. These are typically tag columns but can also be string fields.

{{% code-placeholders "AUTH_TOKEN|DATABASE|TABLE|COLUMNS" %}}

influxdb3 create file_index \
  --token AUTH_TOKEN \
  --database DATABASE_NAME \
  --table TABLE_NAME \
  COLUMNS

{{% /code-placeholders %}}

Replace the following placeholders with your values:

• {{% code-placeholder-key %}}AUTH_TOKEN{{% /code-placeholder-key %}}: your {{% token-link "admin" %}}
• {{% code-placeholder-key %}}DATABASE_NAME{{% /code-placeholder-key %}}: the name of the database to create the file index in
• {{% code-placeholder-key %}}TABLE_NAME{{% /code-placeholder-key %}}: the name of the table to create the file index in
• {{% code-placeholder-key %}}COLUMNS{{% /code-placeholder-key %}}: a comma-separated list of columns to index on--for example: host,application