concept KSQL table in category kafka
appears as: KSQL table

This is an excerpt from Manning's book Kafka Streams in Action: Real-time apps and microservices with the Kafka Streams API.
So far, we’ve demonstrated creating a KSQL stream. Now, let’s see how to create a KSQL table, using the stock-transactions topic as the source, for familiarity (found in src/main/resources/ksql/create_table.txt).
Listing 9.13. Creating a KSQL table
CREATE TABLE stock_txn_table (symbol VARCHAR, sector VARCHAR, \ industry VARCHAR, shares BIGINT, \ sharePrice DOUBLE, \ customerId VARCHAR, transactionTimestamp \ STRING, purchase BOOLEAN) \ WITH (KEY='symbol', VALUE_FORMAT = 'JSON', \ KAFKA_TOPIC = 'stock-transactions');