Handling JSON Data

Problem

The frontend team started dumping unstructured application logs directly into a VARCHAR column in your Postgres database. You need to extract specific keys for a dashboard without re-parsing the text in Python. Write a query that outputs concept with the value: "Modern data warehouses support native querying of JSON documents using JSON path expressions."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution