In this recipe, we explore how to use JSON with Dataset. The JSON format has rapidly become the de-facto standard for data interoperability in the last 5 years.
We explore how Dataset uses JSON and executes API commands like select(). We then progress by creating a view (that is, createOrReplaceTempView()) and then execute a SQL query to demonstrate how to query against a JSON file using API and SQL with ease.