Skip to main content

How to add a JSON column

In this Cockroach University lesson titled “How to add a JSON column”, you will learn to add a JSON column to your table, a method for moving non-JSON data into the JSON column, and some ways of querying on a JSON column. In this lesson, you will learn: •00:00 JSON Portability •0:29 How to add a JSON column •1:21 How to move data from an existing column into the JSON column •2:05 How to query on JSON records * This video is a preview from our course, "CockroachDB for Python Developers".Learn more about CockroachDB by signing up for free training at Cockroach University: https://university.cockroachlabs.com/ ---------- Reference Links •SQL Performance Best Practices: https://www.cockroachlabs.com/docs/v19.2/performance-best-practices-overview.html (CockroachDB Docs) •Indexes: https://www.cockroachlabs.com/docs/v19.2/indexes.html (CockroachDB Docs) ---------- Careers: https://www.cockroachlabs.com/careers CockroachCloud: https://www.cockroachlabs.com/product/cockroachcloud/ Blog: https://www.cockroachlabs.com/blog/ Docs: https://www.cockroachlabs.com/docs/stable/ Community Slack: https://cockroa.ch/Welcome-to-Slack Twitter: https://twitter.com/CockroachDB