Make the most of your JSON data in Toad Edge

Hello, my name is Robert Pound, and I am a Quest technologist. This video will discuss working with JSON data in Toad Edge. So if you have tables that have JSON columns in them, you can expand out the column in the Object Explorer. And underneath it you can see the JSON elements for that given column. If we open up the details of this table by double clicking, we can see the breakdown of columns. And if we move to the Data Tab in the Object Details, we can see the individual data that's already been entered into the table. If we hover over the column that has JSON data in it, we can see a preview for that data. And if we double click on this row and then click the Edit Icon, we are presented with an editor that we can start manipulating our JSON data.
There is a color code that can be added for ease of use when reading the JSON data, and there's two different types. You can color code just the brackets, or you can color code the entire area that compose the brackets. This makes it easier to align your brackets, and if there is a mistake in your JSON data, the editor will point you to the error. And if you double click on the error, it will suggest fixes for your JSON data, in this case, adding the bracket back. So if I double click, it adds the bracket back in and the JSON data is now whole again. And you also have the ability to move the editor. I can put it horizontally or vertically. And we can apply changes or cancel changes. I'm going to go ahead and cancel changes.
And finally, when working with JSON in the worksheet itself, you have access to all the JSON functionality through the intellisense. So if I use select, then I'll type in JSON, now we have a wide range of on functions we have access to for extracting data, extracting keys, inserting data, etc. Hopefully this video shed some light on how you can work with JSON data in Toad Edge. For more information on this product preview, visit www.ToadWorld.com/Products/ToadEdge. For more information on the full release of the product, coming later this year, you can visit www.Quest.com. Thank you and have a great day.

Toad Edge is a flexible database development toolset that works with both Windows and Mac operating systems and is built on Java for easy extensibility. It's designed and built to deliver proven commercial tooling in the open source dbms space.