Exercise

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!

Instructions

100 XP

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.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions

Exercise