Book Image

Learn Azure Synapse Data Explorer

By : Pericles (Peri) Rocha
Book Image

Learn Azure Synapse Data Explorer

By: Pericles (Peri) Rocha

Overview of this book

Large volumes of data are generated daily from applications, websites, IoT devices, and other free-text, semi-structured data sources. Azure Synapse Data Explorer helps you collect, store, and analyze such data, and work with other analytical engines, such as Apache Spark, to develop advanced data science projects and maximize the value you extract from data. This book offers a comprehensive view of Azure Synapse Data Explorer, exploring not only the core scenarios of Data Explorer but also how it integrates within Azure Synapse. From data ingestion to data visualization and advanced analytics, you’ll learn to take an end-to-end approach to maximize the value of unstructured data and drive powerful insights using data science capabilities. With real-world usage scenarios, you’ll discover how to identify key projects where Azure Synapse Data Explorer can help you achieve your business goals. Throughout the chapters, you'll also find out how to manage big data as part of a software as a service (SaaS) platform, as well as tune, secure, and serve data to end users. By the end of this book, you’ll have mastered the big data life cycle and you'll be able to implement advanced analytical scenarios from raw telemetry and log data.
Table of Contents (19 chapters)
1
Part 1 Introduction to Azure Synapse Data Explorer
6
Part 2 Working with Data
12
Part 3 Managing Azure Synapse Data Explorer

Running your first query

There is no better way to familiarize yourself with Azure Synapse Studio other than to get your hands dirty – and to get our hands dirty, we need to create a database first.

Creating a database

To create a new database in your Azure Data Explorer pool, proceed with the following steps:

  1. In the hubs region, click on the Data hub.
  2. The working pane region will display the resource explorer area, which shows all your workspaces and linked databases. Click the + sign, and then Data Explorer database (preview) as illustrated in Figure 3.2.
Figure 3.2 – Creating a new Data Explorer database

Figure 3.2 – Creating a new Data Explorer database

  1. On the right-hand side of the screen, you will be presented with the Data Explorer database (preview) pane, which allows you to create a new Data Explorer database. This pane is shown in Figure 3.3.
Figure 3.3 – Providing the required parameters

Figure 3.3 – Providing the required parameters

New Data Explorer databases...