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

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

https://community.cratedb.com/t/import-json-without-schema