This is not the latest version. View the latest documentation
Apache Kafka Snapshot SQL | Lenses.io Documentation
Lenses.io Help Center
Lenses.io Help Center
  • Documentation
5.5 (Latest) 5.4 5.3 5.2 5.1 5.0 4.3 4.2 4.1 4.0 3.2 3.1 3.0 2.3 2.2 2.1 2.0 1.1 1.0
  • Installation
    Overview Getting started Configuration Moving to production Configuration reference
  • Guides
    Overview Admin Data observibility Compliance Self service & governance Data applications & integration CLI
  • Lenses SQL
    Overview SQL Studio Streaming SQL SQL tutorials Expressions Functions Custom functions Deserializers Supported data formats
  • Connectors
    Overview Setup Sources Sinks Connect CLI Kafka Connect Secrets Release notes
  • APIs
  • Support
  • Releases
  1. Support
  2. Snapshot SQL
  • Installation
    • Azure
      • Base64 Encoded Keytab
      • Create Keytab: Azure HDInsight ESP Kafka
      • HDInsight ESP: Lenses Deployment Failed
    • Helm
      • Additional configuration options in Helm
      • Kubernetes Secrets for Lenses configuration values
      • Run Lenses with additional mounted volumes
      • Run Lenses with additional plugins in kubernetes
      • Ingress with ALB Ingress Controller
      • Use Role/RoleBinging to deploy Lenses processors
    • Support for Kafka connections and operations
      • Automate Kafka topic creation
      • Kafka Quotas and per tenant cost center charging
      • Kafka Strimzi SASL_SSL with SCRAM-SHA-512.authMech
    • How to backup the internal H2 database
    • AWS EC2 - Spin Lenses Instance
    • Lenses Setup Wizard
    • Rotating Kubernetes credentials
    • Configure Lenses to load info from Connector
    • Secure JMX with Basic Auth
    • Secure JMX with TLS Encryption
    • Default thread pools
    • Creating Kerberos principal
    • Enable JMX on Apache Kafka
    • JNI libs and code execution
    • Open File Descriptors
    • Testing TLS certificates
    • User/Groups with Kerberos
  • Streaming SQL
    • Regex within Lenses.io
    • Time window aggregation over streaming data
  • Snapshot SQL
    • Query performance on Apache Kafka with SQL
    • Publish Data to an Apache Kafka topic
    • Can't see data
  • Connectors
    • Kafka Connect Logging
    • Hive Connector - Kerberos/Jaas & UserPassword
    • Secret provider on Confluent images
    • MQTT Connector with TLS Termination
    • Self Signed Certs for MQTT Connector with TLS
    • Escape special characters in KCQL
    • JDBC Confluent Connector - Microsoft SQL Server
  • Troubleshooting
    • How to reset license after it has expired
    • Cannot delete schema from Lenses UI
    • JMX metrics missing from Lenses UI
    • Webhook message/payload is not received
    • Lenses support portal - connection refused
  • Common errors
    • Liquibase exception lock
    • Unable to login
    • Change admin password
    • Connection failed
    • Connection time out
  • Installation
    • Azure
      • Base64 Encoded Keytab
      • Create Keytab: Azure HDInsight ESP Kafka
      • HDInsight ESP: Lenses Deployment Failed
    • Helm
      • Additional configuration options in Helm
      • Kubernetes Secrets for Lenses configuration values
      • Run Lenses with additional mounted volumes
      • Run Lenses with additional plugins in kubernetes
      • Ingress with ALB Ingress Controller
      • Use Role/RoleBinging to deploy Lenses processors
    • Support for Kafka connections and operations
      • Automate Kafka topic creation
      • Kafka Quotas and per tenant cost center charging
      • Kafka Strimzi SASL_SSL with SCRAM-SHA-512.authMech
    • How to backup the internal H2 database
    • AWS EC2 - Spin Lenses Instance
    • Lenses Setup Wizard
    • Rotating Kubernetes credentials
    • Configure Lenses to load info from Connector
    • Secure JMX with Basic Auth
    • Secure JMX with TLS Encryption
    • Default thread pools
    • Creating Kerberos principal
    • Enable JMX on Apache Kafka
    • JNI libs and code execution
    • Open File Descriptors
    • Testing TLS certificates
    • User/Groups with Kerberos
  • Streaming SQL
    • Regex within Lenses.io
    • Time window aggregation over streaming data
  • Snapshot SQL
    • Query performance on Apache Kafka with SQL
    • Publish Data to an Apache Kafka topic
    • Can't see data
  • Connectors
    • Kafka Connect Logging
    • Hive Connector - Kerberos/Jaas & UserPassword
    • Secret provider on Confluent images
    • MQTT Connector with TLS Termination
    • Self Signed Certs for MQTT Connector with TLS
    • Escape special characters in KCQL
    • JDBC Confluent Connector - Microsoft SQL Server
  • Troubleshooting
    • How to reset license after it has expired
    • Cannot delete schema from Lenses UI
    • JMX metrics missing from Lenses UI
    • Webhook message/payload is not received
    • Lenses support portal - connection refused
  • Common errors
    • Liquibase exception lock
    • Unable to login
    • Change admin password
    • Connection failed
    • Connection time out
  1. Support
  2. Snapshot SQL

Snapshot SQL


Query performance on Apache Kafka with SQL

Query performance using SQL on Apache Kafka to explore and identify Kafka messages by scanning through your topics

Publish Data to an Apache Kafka topic

Easy way to publish data to a Kafka topic

Can't see data

What to do when you can not view Kafka messages when exploring Kafka using Lenses.io. Common issues and solutions

Feedback

Was this page helpful?

Awesome, thank you!

Sorry to hear that. Please tell us how we can improve!

2022 © Lenses.io Ltd. Policy Terms Cookies

Apache, Apache Kafka, Kafka, and associated open source project names are trademarks of the Apache Software Foundation.