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): (Required) Your admin token. You can also use theINFLUXDB3_AUTH_TOKENenvironment variable to specify the token. - Database (
-d,--database): (Required) The name of the database to apply the index to. You can also use theINFLUXDB3_DATABASE_NAMEenvironment 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: (Required) A comma-separated list of string columns to index on. These are typically tag columns but can also be string fields.
influxdb3 create file_index \
--token AUTH_TOKEN \
--database DATABASE_NAME \
--table TABLE_NAME \
COLUMNSReplace the following placeholders with your values:
AUTH_TOKEN: your admin tokenDATABASE_NAME: the name of the database to create the file index inTABLE_NAME: the name of the table to create the file index inCOLUMNS: a comma-separated list of columns to index on–for example:host,application
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB 3 Enterprise and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support. Customers using a trial license can email trial@influxdata.com for assistance.