What column type does a Kafka connector store formatted information in a single column?

The correct answer is D. VARIANT. The Snowflake Kafka Connector ingests messages from Kafka topics and loads them into Snowflake tables. Because Kafka messages can carry semi-structured payloads in formats such as JSON, Avro, or Protobuf, the connector stores the entire message content in a single VARIANT…

Data Loading and Unloading

Question

Options

AARRAY
BOBJECT
CVARCHAR
DVARIANT

How the community answered

(37 responses)

B
3% (1)
C
3% (1)
D
95% (35)

Explanation

The Snowflake Kafka Connector ingests messages from Kafka topics and loads them into Snowflake tables. Because Kafka messages can carry semi-structured payloads in formats such as JSON, Avro, or Protobuf, the connector stores the entire message content in a single VARIANT column. VARIANT is Snowflake's native semi-structured data type capable of holding JSON, XML, Avro, or any nested structure, making it the ideal container for variable-schema Kafka payloads. ARRAY and OBJECT are sub-types of VARIANT, and VARCHAR is a flat string type not suited for structured ingestion.

Topics

#Kafka Connector#Semi-structured data#VARIANT data type#Data Ingestion

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice