Which of the following columns contains the Kafka message payload in Snowflake tables loaded by the Kafka connector?

• A. RECORD_CONTENT
• B. RECORD_METADATA
• C. RECORD_SUMMARY
• D. RECORD_ISCORRECT

Answer: (A)

The key idea is understanding where the actual Kafka message data is stored in Snowflake after the load. Snowflake’s Kafka Connector separates each Kafka record into two parts: the payload (the message content) and the metadata about that message. The payload—the real data you produced to the Kafka topic—is stored in the column that holds the message content. That column is RECORD_CONTENT. The other columns hold metadata or a summary and do not contain the actual payload. So RECORD_CONTENT is the column that contains the Kafka message payload.