Rockset SQL syntax help

Open Q & A
1

Hi, how can I extract the city?

{“username”: “garfield007”,“verified”: true,“firstName”: “garfield”,"_meta": {“dynamodb”: {“table”: “cats”}},"_event_time": “2020-02-04T23:42:36.397000Z”,“password”: “cats4life”,“status”: “INACTIVE”,“lastAccess”: {“date”: “2020-12-67T03:02:59.596Z”,“location”: {“city”: “Los Angeles”,“postalCode”: “90210”,“country”: “USA”,}}

2

Hi. We index all nested data, so you can extract the city by:

SELECT lastAccess.location.city FROM collection_name;