Querying document databases

Using Postgres JSON to query document data is similar to querying relational data with Postgres. In this exercise, you'll practice building a query to retrieve document data from the nested_reviews table, with Postgres JSON. Happy querying!

This exercise is part of the course

Introduction to NoSQL

View Course

Exercise instructions

Update the query to return the review column from the nested_reviews table.
Use the appropriate pandas function to create a DataFrame using the logic stored in the query variable.
Output the first record in the DataFrame returned after executing the query.

Hands-on interactive exercise

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

# Update the query to select the review field
query = """
	SELECT 
    	____
    FROM nested_reviews;
"""

# Execute the query
data = ____.____(query, db_engine)

# Print the first element of the DataFrame
____(data.iloc[0, 0])

Edit and Run Code