View the latest documentation 5.5
The Lenses SQL Studio provides a familiar query editor that allows:
SQL access is unified over any data format for Apache Kafka and Elasticsearch. Learn more about Lenses SQL for Kafka.
Data returned from the queries can be visualized in Tree and Grid format. The format can be toggled from the top of the result set. The data set can also be Downloaded in a JSON format.
The SQL editor gives a context-aware autocomplete to use specific fields from the topic payload. It supports nested fields and typical SQL projections.
On the right panel, you can see the Datasets list and your Recent queries. To explore the fields in datasets:
More information on how to manage connections.
You can click on the play button to view data from the topic.
Use DESCRIBE TABLE to explore fields, data formats and configurations via SQL.
DESCRIBE TABLE
Recent Queries
Recent queries are displayed, but only for the current session, they are not currently retained.
Click on the play button to run a previous query. If a query is already running, you will be asked if you want to stop it first.
All Running queries
You can see all running queries by Lenses users using SQL:
SHOW QUERIES
You can force stop a query by another user using SQL:
KILL QUERY <id>
Recent queries are displayed, but only for the current session, they are not currently retained. Click on the play button to run a previous query. If a query is already running, you will be asked if you want to stop it first.
Lenses SQL documentation
Snapshot SQL engine
On this page