Querying nested semi-structured data
Within columns of type VARIANT, data can often be nested, as we see in the city_meta column of the host_cities table below.
A Snowflake connection object to the database olympics has been created, and is available in the variable conn. Happy querying!
Questo esercizio fa parte del corso
Introduction to NoSQL
Istruzioni dell'esercizio
- Using dot notation, complete the query to extract data from the nested
latfield in thecoordinatesobject. - Query the nested
longfield from thecoordinatesobject in thecity_metacolumn. - Execute the query, and print the results.
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
# Build a query to extract nested location coordinates
query = """
SELECT
city_meta:coordinates.____,
city_meta:____.____
FROM host_cities;
"""
# Execute the query and output the results
results = conn.cursor().____(____).fetch_pandas_all()
print(results)