A primer on analyzing semi-structured data will focus on its handling and management in the context of databases. In this blog post, we will explore some of the key functions available in SQL, including Lambda functions. We will use the New York Philharmonic's first concert at the Apollo Rooms venue on the left.
Table of contents
A primer on analyzing semi-structured data | Firebolt (part 1)PartsOvertureThe datasetSetupLoading data into FireboltSonata: Analyzing the raw dataMinuetArray manipulations in SQL, including Lambda functionsFlattening dataSort: