KAFKA.QUERY

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	INBOX(), OUTBOX("MsgID") or a cell range where the result will be placed. Make sure the cell range is big enough or not everything is displayed.
Timeout (optional)	The time to wait for an answer. When left empty a 20 second timeout is being used.

Return

TRUE, if no error.

Examples

Formula	Result	Comment
=KAFKA.Query(|Kafka Producer, "select * from ksqltable200", INBOX())	TRUE	The complete data from ksqltable200 will be shown in the inbox.