Skip to main content

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

NameDescription
ProducerProducer to use.
QueryAny query allowed on a KSQL table.
TargetINBOX(), 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.
TimeoutOptional. The time to wait for an answer. When left empty a 20 second timeout is being used.

Return Value

TRUE, if no error.

Examples

FunctionResultComment
=KAFKA.Query(|Kafka Producer, "select * from ksqltable200", INBOX())TRUEThe complete data from ksqltable200 will be shown in the inbox.