KAFKA.QUERY

star This is a Streamsheets Professional feature.

Allows KSQL queries to be used. You can use the Function Wizard for this function.

Syntax

=KAFKA.QUERY(Producer, Query, Target [, Timeout])

Arguments

Name Description
Producer Producer to use.
Query Any query allowed on a KSQL table.
Target Target to show the result of the query operation. Can be either INBOX(), OUTBOX() or a cell range.
Timeout Optional. The time to wait for an answer. When left empty a 20 second timeout is being used.

Return Value

TRUE, if successful.

Examples

Function Result Comment
=KAFKA.Query(“Kafka Producer”, “select * from ksqltable200”, INBOX()) TRUE The complete data from ksqltable200 will be shown in the Inbox.