Packt+ | Advance your knowledge in tech

You're reading from Hands-On Data Warehousing with Azure Data Factory ETL techniques to load and transform data from various sources, both on-premises and on cloud

Product type Paperback

Published in May 2018

Publisher Packt

ISBN-13 9781789137620

Length 284 pages

Edition 1st Edition

Languages

SQL

Tools

Azure

Concepts

Big Data

Authors (3):

Cote

Michelle Gutzait

Giuseppe Ciaburro

View More author details

Table of Contents (8) Chapters

Preface

1. The Modern Data Warehouse FREE CHAPTER

2. Getting Started with Our First Data Factory

3. SSIS Lift and Shift

4. Azure Data Lake

5. Machine Learning on the Cloud

6. Introduction to Azure Databricks

7. Reporting on the Modern Data Warehouse

Azure Databricks setup

This section describes how to set up Databricks in Azure. Once logged in to the Azure portal, click on Create a resource in the top-left corner and select the Analytics category. As shown in the following screenshot, click on Azure Databricks:

We're now redirected to the Azure Databricks Service blade. We first need to set up a workspace, as shown in the following screenshot:

The parameters are explained here:

Workspace name: ADFV2DataBricks
Subscription: The subscription in use when you logged in to Azure
Resource group: The same as we have used since the beginning—ADFV2Book
Location: The same location of all our resources used so far
Pricing Tier: Premium. This is mandatory to be able to connect Power BI to Databricks

Once done, check the Pin to dashboard option and click on Create at the bottom-left of the blade to create the workspace. After a few minutes, the workspace is ready to use, as shown in this screenshot: