Querying JSON and JSONB data from Postgres

With Postgres' built-in JSON and JSONB data types, it's easy to store and interact with semi-structured data in a Postgres table. In this exercise, you'll observe some of the tooling that Postgres offers to query data of type JSON from the nested_reviews table. Best of luck!

This exercise is part of the course

Introduction to NoSQL

View Course

Exercise instructions

Create a connection to the disneyland database with user repl, using sqlalchemy.
Execute the query stored in the query variable, using the previously-defined db_engine.
Output the review column of the results DataFrame, and observe the data that was returned.

Hands-on interactive exercise

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

import pandas as pd
import sqlalchemy

# Create a connection to the reviews database
db_engine = sqlalchemy.create_engine("postgresql+psycopg2://____:password@localhost:5432/____")

query = """SELECT * FROM nested_reviews;"""

# Execute the query, check out the results
results = pd.____(____, ____)

# Print the review column from the results DataFrame
____(results["review"])

Edit and Run Code