Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Conferences

Free Learning

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):

Christian Cote

Giuseppe Ciaburro

Michelle Gutzait

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...

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (3)

Cote

Christian Cote is an IT professional with more than 15 years of experience working in a data warehouse, Big Data, and business intelligence projects. Christian developed expertise in data warehousing and data lakes over the years and designed many ETL/BI processes using a range of tools on multiple platforms. He's been presenting at several conferences and code camps. He currently co-leads the SQL Server PASS chapter. He is also a Microsoft Data Platform Most Valuable Professional (MVP).

See other products by Cote

Michelle Gutzait

Michelle Gutzait has been in IT for 30 years as a developer, business analyst, and database

See other products by Michelle Gutzait

Giuseppe Ciaburro

Giuseppe Ciaburro holds a PhD and two master's degrees. He works at the Built Environment Control Laboratory - Università degli Studi della Campania "Luigi Vanvitelli". He has over 25 years of work experience in programming, first in the field of combustion and then in acoustics and noise control. His core programming knowledge is in MATLAB, Python and R. As an expert in AI applications to acoustics and noise control problems, Giuseppe has wide experience in researching and teaching. He has several publications to his credit: monographs, scientific journals, and thematic conferences. He was recently included in the world's top 2% scientists list by Stanford University (2022).

See other products by Giuseppe Ciaburro