Querying nested documents with Postgres JSON

With Postgres JSON, querying semi-structured data is a breeze! Postgres provides built-in operators, such as ->. In this example, you'll practice using this operator to query reviews data from a column of type JSON. This table takes the form below:

nested_reviews table, showing sample data.

pandas has been imported as pd, and a sqlalchemy connection object has been configured, and made available for you via the db_engine variable. Best of luck!

This exercise is part of the course

Introduction to NoSQL

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# Build the query to select the statement field
query = """
	SELECT 
    	review -> '___' AS statement
    FROM nested_reviews;
"""

# Execute the query, render results
data = pd.read_sql(query, db_engine)
print(data)

Edit and Run Code