Ask AI doesn't know how to use SQL or API to identify Core and Enterprise

[jstirnaman]

How do I use query or API features to determine the InfluxDB product and version?

To determine the InfluxDB product and version using query or API features, you can use the following methods based on the knowledge sources:

---

1. Use the /ping API Endpoint

For InfluxDB 3 Cloud Dedicated and Clustered, you can send a request to the /ping endpoint. The response will include the InfluxDB version in the headers. This endpoint does not require authentication.

Example:

curl -I https://<your-influxdb-endpoint>/ping

Check the response headers for version information.
This method is supported in both Cloud Dedicated and Clustered environments [Cloud Dedicated API](https://docs.influxdata.com/influxdb3/cloud-dedicated/api/v2/), [Clustered API](https://docs.influxdata.com/influxdb3/clustered/api/v2/).

---

2. Use SQL Query

For InfluxDB 3 products, you can run the following SQL query to get the DataFusion version (which is used internally by InfluxDB 3):

SELECT version()

This will return the version of the DataFusion engine, which can help identify the underlying InfluxDB 3 environment [Cloud Dedicated SQL functions](https://docs.influxdata.com/influxdb3/cloud-dedicated/reference/sql/functions/misc/).

---

3. Use the CLI

For InfluxDB Cloud Serverless, you can use the CLI to check the version:

[influx version](https://docs.influxdata.com/influxdb3/cloud-serverless/reference/cli/influx/version/)

This outputs the current version of the influx CLI, which often matches the server version influx version.

---

4. Use the InfluxDB Cloud UI

If you are using InfluxDB Cloud, log in to your organization homepage and look for the "InfluxDB Cloud powered by" link. This will indicate the product and version you are using [Cloud Serverless documentation](https://docs.influxdata.com/influxdb3/cloud-serverless/).

---

5. Use the Interactive Version Detector

InfluxData provides an interactive tool to help you identify your InfluxDB product and version:
[Detect my InfluxDB version](https://docs.influxdata.com/influxdb3/cloud-serverless/process-data/visualize/grafana/).

---

If you need more specific details, please provide your deployment method (cloud, on-premises, Docker, etc.). If these methods do not provide enough information, the knowledge sources do not contain additional API or query features for product and version detection.

Why did you omit Core and Enterprise?

Thank you for your feedback. Here’s a direct answer based strictly on the knowledge sources:

The /ping API endpoint and the SELECT version() SQL query are documented for InfluxDB 3 Cloud Dedicated and Clustered, but the knowledge sources do not explicitly state that these methods are available or will return product/version information for InfluxDB 3 Core or InfluxDB 3 Enterprise. The documentation for Core and Enterprise focuses on their features, deployment, and use cases, but does not provide specific instructions or guarantees about using API or query features to determine the product and version for these editions [InfluxDB 3 Core documentation](https://docs.influxdata.com/influxdb3/core/), [InfluxDB 3 Enterprise documentation](https://docs.influxdata.com/influxdb3/enterprise/).

Therefore, I omitted Core and Enterprise in my previous answer because the knowledge sources do not contain enough information to confidently state that these query or API methods will work for those products. If you need to determine the version for Core or Enterprise, the knowledge sources recommend using the command line (influxdb3 --version) or Docker image tags, but do not document an API or SQL query method for this purpose.