# Schemaless JSON in a single column

**URL:** https://forum.scylladb.com/t/schemaless-json-in-a-single-column/1918
**Category:** ScyllaDB
**Tags:** data-model
**Created:** [April 30, 2024, 10:18pm UTC](https://forum.scylladb.com/t/schemaless-json-in-a-single-column/1918 "2024-04-30T22:18:25Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Hammad\_Ul\_Haq](https://avatars.discourse-cdn.com/v4/letter/h/ed8c4c/32.png) [@Hammad\_Ul\_Haq](https://forum.scylladb.com/u/Hammad_Ul_Haq)
#### Post date: [April 30, 2024, 10:18pm UTC](https://forum.scylladb.com/t/schemaless-json-in-a-single-column/1918/1 "2024-04-30T22:18:25Z")

</div>

I understand that Scylla has support for storing JSON data and getting data in JSON form but from what I can see this is only schemafull. Every field in the JSON object will map to a column. Is it possible to store schemaless JSON in a single columns? for e.g store {a:“B”} in column3

---

<div class="post-metadata">

### Author: ![tzach](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.scylladb.com/tzach/32/172_2.png) [@tzach](https://forum.scylladb.com/u/tzach)
#### Post date: [May 20, 2024, 10:20am UTC](https://forum.scylladb.com/t/schemaless-json-in-a-single-column/1918/2 "2024-05-20T10:20:41Z")

</div>

It is, but then you will not be able to update a subset of the stored JSON document.

---

<div class="post-metadata">

### Author: ![Hammad\_Ul\_Haq](https://avatars.discourse-cdn.com/v4/letter/h/ed8c4c/32.png) [@Hammad\_Ul\_Haq](https://forum.scylladb.com/u/Hammad_Ul_Haq)
#### Post date: [May 22, 2024, 9:32am UTC](https://forum.scylladb.com/t/schemaless-json-in-a-single-column/1918/3 "2024-05-22T09:32:00Z")

</div>

how is it possible? I only need to insert said data

---

<div class="post-metadata">

### Author: ![Botond\_Denes](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.scylladb.com/botond_denes/32/163_2.png) [@Botond\_Denes](https://forum.scylladb.com/u/Botond_Denes)
#### Post date: [May 23, 2024, 9:08am UTC](https://forum.scylladb.com/t/schemaless-json-in-a-single-column/1918/4 "2024-05-23T09:08:36Z")

</div>

Just create a text or blob column in your schema and dump the JSON in it. You will have to serialize/unserialize on the client side.

---

<div class="post-metadata">

### Author: ![Hammad\_Ul\_Haq](https://avatars.discourse-cdn.com/v4/letter/h/ed8c4c/32.png) [@Hammad\_Ul\_Haq](https://forum.scylladb.com/u/Hammad_Ul_Haq)
#### Post date: [May 24, 2024, 6:34am UTC](https://forum.scylladb.com/t/schemaless-json-in-a-single-column/1918/5 "2024-05-24T06:34:29Z")

</div>

That’s what I’ve been doing uptill now. Not exactly the solution I was hoping for. Hope the team adds support for pure schemaless JSON data soon

---

<div class="post-metadata">

### Author: ![Katesmith99](https://avatars.discourse-cdn.com/v4/letter/k/ea5d25/32.png) [@Katesmith99](https://forum.scylladb.com/u/Katesmith99)
#### Post date: [May 27, 2024, 5:52am UTC](https://forum.scylladb.com/t/schemaless-json-in-a-single-column/1918/6 "2024-05-27T05:52:29Z")

</div>

> [@tzach](#):
>
> It is, but then you will not be able to update a subset of the stored JSON document.

That’s true. If you store the entire document as JSON, updating a specific subset can become more challenging.