Some of the content described in this article is available in meshIQ Manage versions 12.0 and later.
For a quick overview of what's new or changed, visit the meshIQ Highlights page for a version-by-version breakdown.  

Jump to Section:
Version 11.2 and Earlier
Version 12.x and Later

Version 11.2 and Earlier

The Execute KSQL Query action is available from KSQL object viewlets. KSQL objects can be set up when on the KSQL tab when you create a Remote Kafka Manager Connection.

The example below shows a KSQL query being used to select from the Users table. To learn how to view a list of queries, see Read Queries, Tables, and Streams.  

Execute a KSQL Query

To execute a KSQL query:

1. On a KSQL viewlet, click Execute KSQL Query on a KSQL object's action menu (Selected menu in 11.2). The Kafka KSQL Query dialog opens.
2. Enter the SQL Command in the SQL field.
3. Click OK. The result of the command is displayed in the Response field.

_______________________________________________________________________________________________________________

Version 12.x and Later

The Execute KSQL Query action is available from KSQL object viewlets. KSQL objects can be set up when on the KSQL tab when you create a Remote Kafka Manager Connection.

The example below shows a KSQL query being used to select from the Users table. To learn how to view a list of queries, see Read Queries, Tables, and Streams.  

Execute a KSQL Query

To execute a KSQL query:

1. On a KSQL viewlet, click Execute KSQL Query on a KSQL object's action menu (Selected menu in 11.2). The Kafka KSQL Query dialog opens.
2. Enter the SQL Command in the SQL field.
3. Click Ok. The result of the command is displayed in the Response field.