When using the Snowflake Connector for Kafka, what data formats are supported for the messages? (Choose two.)
When using the Snowflake Connector for Kafka, what data formats are supported for the messages? (Choose two.)
The Snowflake Connector for Kafka supports the JSON and Avro data formats for the messages. These formats are well-integrated with Snowflake's data storage and processing capabilities, particularly with its VARIANT data type which is designed to handle semi-structured data like JSON and Avro. CSV, XML, and Parquet are not supported formats in the context of Kafka messages within the Snowflake ecosystem.
The Snowflake Connector for Kafka supports the JSON and Avro data formats for the messages. Therefore, options (C) and (D) are the correct answers. Snowflake does not support CSV, XML, or Parquet data formats for Kafka messages
Ans: C,D Explanation: Each Kafka message is passed to Snowflake in JSON format or Avro format. The Kafka connector stores that formatted information in a single column of type VARIANT. The data is not parsed, and the data is not split into multiple columns in the Snowflake table. Link: https://docs.snowflake.com/en/user-guide/kafka-connector-overview
https://docs.snowflake.com/en/user-guide/kafka-connector-overview#:~:text=Each%20Kafka%20message%20is%20passed%20to%20Snowflake%20in%20JSON%20format%20or%20Avro%20format
correct