I have seen in the documentation that object can be used as kind of json-blob is this not a core feature? ingesting jsons?

Is JSON a type?, how do CrateDB and json interop?, how do I ingest json?

miguel.arregui May 28, 2020, 7:01pm 2

Here is a very relevant answer that shows you with examples.

Topic		Replies	Views
Import JSON without schema CrateDB	6	1109	May 26, 2020
INSERT a column as JSON using Kafka JDBC Sink CrateDB	4	1251	June 17, 2021
Insert an nest json objects with Error ERROR: Can't map PGType with oid=-272646673 to Crate type CrateDB	3	93	May 22, 2024
SQLParseException while importing JSON CrateDB	2	53	August 29, 2024
How to import csv file which contains into table which have json columns CrateDB sql , data-storage	0	35	October 1, 2024