In Snowflake's Kafka connector, how many pipes are created relative to topic partitions?

• A. One pipe per topic
• B. One pipe per partition
• C. One pipe per broker
• D. One pipe per consumer group

Answer: (B)

Kafka partitions are independent, ordered streams. The Snowflake Kafka Connector creates a dedicated Snowpipe for each partition, so the total number of pipes matches the total number of partitions. This setup lets multiple partitions load in parallel while preserving the message order within each partition. If there were fewer pipes, data from different partitions would contend for a single pipe, reducing throughput and weakening per-partition ordering guarantees.