Kafka Conect JDBC Postgres - Can i write entire json to one column without parsing values to columns?

Question

Can i write entire json to one column using Confluent Kafka JDBC connector in format?

---

 Key|Value
  1 | {....}
  2 | {....}
  3 | {....}

Answer 1

Only with Postgres, and only if you predefine the table

https://github.com/confluentinc/kafka-connect-jdbc/issues/46#issuecomment-1135209669

Otherwise, Mongo/DocumentDB might be better for JSON data than a relational database