Get started with InfluxDB 3 Explorer
InfluxDB 3 Explorer is Generally Available
InfluxDB 3 Explorer is generally available and is ready for production use. We welcome and encourage your input about your experience with Explorer and invite you to join our public channels for updates and to share feedback.
The InfluxDB 3 Explorer documentation is a work in progress, and we are actively working to improve it. If you have any questions or suggestions, please submit an issue. We welcome any and all contributions.
Get started with InfluxDB 3 Explorer by connecting it to an InfluxDB 3 instance, writing data to InfluxDB, and then querying that data. This guide walks you through each of those steps.
This guide assumes you have already installed InfluxDB 3 Explorer.
Connect to an InfluxDB 3 server
InfluxDB 3 Explorer supports the following InfluxDB 3 products:
Navigate to Configure > Servers.
Click + Connect Your First Server.
Provide the following InfluxDB 3 server information:
Server name: A name to identify the InfluxDB 3 server you’re connecting to.
Server URL: The URL used to connect to your InfluxDB 3 server.
- Select the protocol to use (http or https).
- Provide the host and, if necessary, the port.
Token: The authorization token to use to connect to your InfluxDB 3 server. We recommend using an InfluxDB 3 admin token.
Token permissions may limit Explorer functionality
The permissions associated with the provided token determine what databases you can access using this server configuration. InfluxDB 3 tokens with limited permissions may not be able to use some Explorer functionality.
Click Add Server.
InfluxDB 3 Explorer attempts to verify the connection. If successful, Explorer saves the server configuration and selects it as the active server.
If you already have data in your InfluxDB 3 instance, skip to Query data from InfluxDB.
Write data to InfluxDB
InfluxDB 3 Explorer lets you write data to InfluxDB 3 and provides multiple options. For this getting started guide, use Explorer to write one of the sample data sets to InfluxDB:
- Navigate to Write Data > Sample/Dev Data.
- Select any of the available sample data sets.
- Click Write Sample Data.
InfluxDB 3 Explorer creates a new database and then writes the sample data to the database.
Other write methods
InfluxDB 3 Explorer provides other ways to write data to InfluxDB, including the following:
- Line protocol
- CSV or JSON
- InfluxDB 3 client libraries
- Telegraf
Query data from InfluxDB
To use InfluxDB 3 Explorer to query data from InfluxDB 3, navigate to Query Data > Data Explorer.
The Data Explorer lets you explore the schema of your database and automatically builds SQL queries by either selecting columns in the Schema Browser or by using Natural Language with the InfluxDB 3 Explorer OpenAI integration.
For this getting started guide, use the Schema Browser to build a SQL query that returns data from the newly written sample data set.
- On the Data Explorer in the Schema column, select the database you want to query from the database dropdown menu. Once selected, all tables in the database appear.
- Click the name of the table you want to query to expand and view all the columns in that table.
- Select each column you want to query. As you select columns in the Schema Browser, Explorer generates and updates an SQL query in the Query pane.
- Use the time range dropdown menu above the Query pane to select a time range to query. You can select one of the predefined relative time ranges, or you can select Custom Range to define an absolute time range to query.
- With columns and a time range selected, click Run Query.
InfluxDB 3 Explorer runs the query and returns the results in the Results pane. The Results pane provides three view options:
- Table (default): Displays raw query results in paginated table format.
- Line: Displays query results in a line graph.
- Bar: Displays query results in a bar graph.
SQL query results may not be ordered by time
and Line and Bar graph
visualizations may behave unexpectedly. To order results by time:
- Ensure that you query the
time
column - Update the query to include an
ORDER BY time
clause.
Congratulations! You have successfully used InfluxDB 3 Explorer to connect to, write data to, and query data from an InfluxDB 3 instance.
Video walkthrough
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 Explorer and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.