ContextQMD
Back to Influxdb

Table

content/shared/influxdb3-cli/show/system/table.md

latest2.8 KB
Original Source

The influxdb3 show system table command queries data from a system table.

Usage

<!--pytest.mark.skip-->
bash
influxdb3 show system --database <DATABASE_NAME> table [OPTIONS]

Arguments

  • SYSTEM_TABLE: the system table to query

Options

OptionDescription
-l--limitMaximum number of tables entries to display (default is 10, 0 indicates no limit)
-o--order-byOrder by the specified columns
-s--selectSelect specific columns from the system table
--formatOutput format (pretty (default), json, jsonl, csv, or parquet)
--tls-caPath to a custom TLS certificate authority (for testing or self-signed certificates)
--tls-no-verifyDisable TLS certificate verification. (Not recommended in production, useful for self-signed certificates)
-h--helpPrint help information
--help-allPrint detailed help information

Examples

In the examples below, replace {{% code-placeholder-key %}}DATABASE_NAME{{% /code-placeholder-key %}} with the name of the database to operate on.

{{% code-placeholders "DATABASE_NAME" %}}

Query a system table

<!--pytest.mark.skip-->
bash
# Query the parquet_files system table
influxdb3 show system --database DATABASE_NAME table parquet_files

Query specific columns from a system table

<!--pytest.mark.skip-->
bash
# Select specific columns from the parquet_files system table
influxdb3 show system \
  --database DATABASE_NAME \
  table \
  --select table_name,size_bytes,row_count \
  parquet_files

Query a system table and order by a specific column

<!--pytest.mark.skip-->
bash
influxdb3 show system \
  --database DATABASE_NAME \
  table \
  --order-by size_bytes,row_count \
  parquet_files

Query a system table and return JSON-formatted output

<!--pytest.mark.skip-->
bash
influxdb3 show system \
  --database DATABASE_NAME \
  table \
  --format json \
  parquet_files

{{% /code-placeholders %}}