How to How to List Persistent Queries in ksqlDB

To list current queries, u se a LIST statement :

LIST QUERIES;

Those listed with the Query Type column as PERSISTENT are the ones you are looking for.

Query ID                  | Query Type | Status    | Sink Name              | Sink Kafka Topic       | Query String
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
INSERTQUERY_83            | PERSISTENT | RUNNING:1 | FLORIDA_TWEETS_DECODED | FLORIDA_TWEETS_DECODED | INSERT INTO FLORIDA_TWEETS_DECODED SELECT   FROM_BYTES(payloa...
CSAS_FLIGHTSV0_59         | PERSISTENT | RUNNING:1 | FLIGHTSV0              | FLIGHTSV0              | CREATE STREAM FLIGHTSV0 WITH (KAFKA_TOPIC='FLIGHTSV0', PARTIT...
CSAS_LONDON_TWEETS_RAW_65 | PERSISTENT | RUNNING:1 | LONDON_TWEETS_RAW      | LONDON_TWEETS_RAW      | CREATE STREAM LONDON_TWEETS_RAW WITH (KAFKA_TOPIC=LONDON_TWEE...
CSAS_SCORES_93            | PERSISTENT | RUNNING:1 | SCORES                 | SCORES                 | CREATE STREAM SCORES WITH (KAFKA_TOPIC='SCORES', PARTITIONS=1...

Was this article helpful?