Get Started Free
‹ Back to courses
course: ksqlDB 101

Interacting with ksqlDB

2 min
Allison

Allison Walther

Integration Architect (Presenter)

Robin Moffatt

Robin Moffatt

Principal Developer Advocate (Author)

Interacting with ksqlDB

There are several ways to interact with ksqlDB, including a command line interface, a web UI, a REST API, and client libraries for Java and other languages.

Command Line Interface (CLI)

The ksqlDB CLI is very similar in look and feel to command line tools for relational databases that you may be familiar with, such as Postgres’s psql or Oracle’s SQL*Plus:

database-purpose

Web UI

One of the simplest ways to interact with ksqlDB is via the web UI in Confluent Cloud. You can develop queries in an interactive editor, view flow diagrams of streams and tables, and manage persistent queries.

diagrams-of-streams

diagrams-of-streams-and-tables

You can also monitor ksqlDB and its processing in the web UI:

web-ui-three

REST API

The ksqlDB REST API provides programmatic access to ksqlDB for managing objects and querying them:

web-ui-four

Client Libraries

ksqlDB’s client libraries wrap the REST API. An official Java client is provided, and there are community projects that provide similar functionality in other languages, including Python and Go.

client-libraries

Use the promo code KSQLDB101 to get $25 of free Confluent Cloud usage

Get Started

Get started with Confluent Cloud

Try free

Total 28

  1. Introduction to ksqlDB
    2 min
  2. Interacting with ksqlDB
    2 min
  3. Hands On: Interacting with ksqlDB
    5 min
  4. Creating, Exporting, and Importing Data
    2 min
  5. Filtering with ksqlDB
    1 min
  6. Hands On: Filtering with ksqlDB
    1 min
  7. Lookups and Joins with ksqlDB
    2 min
  8. Hands On: Lookups and Joins with ksqlDB
    2 min
  9. Transforming Data with ksqlDB
    2 min
  10. Hands On: Transforming Data with ksqlDB
    2 min
  11. Flatten Nested Records with ksqlDB
    1 min
  12. Hands On: Flatten Nested Records with ksqlDB
    2 min
  13. Converting Data Formats with ksqlDB
    2 min
  14. Hands On: Converting Data Formats with ksqlDB
    2 min
  15. Merging Two Streams with ksqlDB
    1 min
  16. Hands On: Merging Two Streams with ksqlDB
    2 min
  17. Splitting Two Streams with ksqlDB
    2 min
  18. Hands On: Splitting Two Streams with ksqlDB
    2 min
  19. Streams and Tables
    2 min
  20. Stateful Aggregations (Materialized Views)
    2 min
  21. Hands On: Stateful Aggregations (Materialized Views)
    2 min
  22. Push Queries and Pull Queries
    2 min
  23. Hands On: Push Queries and Pull Queries
    2 min
  24. Under the Covers of ksqlDB
    2 min
  25. ksqlDB Code Lifecycle
    2 min
  26. Apply Lambda Functions to Arrays and Maps
    2 min
  27. Hands On: Apply Lambda Functions to Arrays and Maps
    2 min
  28. Monitoring ksqlDB
    1 min

Related Resources

Presentation

Inside ksqlDB

Docs

Configure ksqlDB CLI

Docs

REST API Index

Be the first to get updates and new content

We will only share developer content and updates, including notifications when new content is added. We will never send you sales emails. 🙂 By subscribing, you understand we will process your personal information in accordance with our Privacy Statement.

Interacting with ksqlDB

Hi, I'm Allison Walther with Confluent. KsqlDB has several ways that you can interact with it, including a command-line interface. If you're using CLIs from relational databases like Oracle SQL Plus or Postgres' PSQL, you'll feel at home with this. Confluent Cloud UI The simplest way to interact with ksqlDB is via the Confluent Cloud UI. Here we can experiment with queries in an interactive editor, view any streams and tables, and also manage our persistent queries. ksqlDB CLI We can also use the ksqlDB CLI, which is especially useful for automation. The ksqlDB CLI will work with ksqlDB on Confluent Cloud or self-managed ksqlDB. ksqlDB REST The REST API is useful for programmatic access to ksqlDB and for scripted deployments of applications. Outro You can call the REST API directly or take advantage of client libraries that wrap it. There's a native client for Java as part of ksqlDB, and community projects providing libraries in Python and Go. That's it for this short lesson, let's jump into an exercise to get our hands dirty with the material.