Technical requirements
To reproduce the examples and content in this chapter, you will need an Azure subscription and an Azure Synapse workspace. If you choose to load the data we offer as an example in this chapter, you will need to download the drone telemetry dataset from GitHub (approximately 123 MB) on your local machine. This dataset is stored as a comma-separated values (CSV) file and contains fictional data that was created specifically for this book. It can be found at https://github.com/PacktPublishing/Learn-Azure-Synapse-Data-Explorer/blob/main/Chapter%2003/drone-telemetry.zip. Make sure you extract the drone-telemetry.csv
file from the compressed folder before using it.
The queries demonstrated in this chapter use Kusto Query Language (KQL). In addition to KQL, we will explore data in Synapse notebooks using Python. While these queries and notebooks are simple and we will describe what they do, teaching KQL or Python is not in the scope of this book. You should have...