SQL Studio

A declarative SQL interface, for querying, transforming and manipulating data at rest and data in motion. It works with Apache Kafka topics and other data sources. It helps developers and Kafka users

The Lenses SQL Snapshot engine accesses the data at the point in time the query is executed. This means, that for Apache Kafka, data added just after the query was initiated will not be processed.

Typical use cases are but are not limited to:

• Identifying a specific message.

• Identifying a particular transaction of payment that your system has processed

• Identifying all thermostats readings for a specific customer if you are working for an energy provider

• Counting transactions processed within a given time window.

The Snapshot engine presents a familiar SQL interface, but remember that it queries Kafka with no indexes. Use Kafka's metadata (partition, offset, timestamp) to improve query performance.

Writing queries

Go to Environments->[Your Environment]->Workspace->Sql Studio, enter your query, and click run.