Search⌘ K
AI Features

Loading Sample Data

Explore how to load sample data into Azure Data Studio by restoring a SQL Server backup file. Learn step-by-step to handle database restoration safely, work with a car crash dataset, and prepare your data for visualization and export.

We'll cover the following...

Introduction

SQL queries generally return rows and columns, which is often enough, especially with small datasets. However, if you have a larger result set and/or you have the need to share the information, this chapter will illustrate how Azure Data Studio can help. As data professionals, it is often helpful to visualize a set of data and share results and analysis with our co-workers, internal and external clients, or even other workstreams. Instead of relying on external applications, ADS is happily a one-stop-shop to create, run, visualize, and export your database queries.

Getting started

Beginning with this chapter, we are going to use a database named car_crash, which is a small DataMart created from ...