What do you get with eBook?

Instant access to your Digital eBook purchase

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

AI Assistant (beta) to help accelerate your learning

Key benefits

Learn about business intelligence on the lakehouse with features and functions of Databricks SQL

Make the most of Databricks SQL by getting to grips with the enablers of its data warehousing capabilities

A unique approach to teaching concepts and techniques with follow-along scenarios on real datasets

Description

In this new era of data platform system design, data lakes and data warehouses are giving way to the lakehouse – a new type of data platform system that aims to unify all data analytics into a single platform. Databricks, with its Databricks SQL product suite, is the hottest lakehouse platform out there, harnessing the power of Apache Spark™, Delta Lake, and other innovations to enable data warehousing capabilities on the lakehouse with data lake economics. This book is a comprehensive hands-on guide that helps you explore all the advanced features, use cases, and technology components of Databricks SQL. You’ll start with the lakehouse architecture fundamentals and understand how Databricks SQL fits into it. The book then shows you how to use the platform, from exploring data, executing queries, building reports, and using dashboards through to learning the administrative aspects of the lakehouse – data security, governance, and management of the computational power of the lakehouse. You’ll also delve into the core technology enablers of Databricks SQL – Delta Lake and Photon. Finally, you’ll get hands-on with advanced SQL commands for ingesting data and maintaining the lakehouse. By the end of this book, you’ll have mastered Databricks SQL and be able to deploy and deliver fast, scalable business intelligence on the lakehouse.

Who is this book for?

This book is for business intelligence practitioners, data warehouse administrators, and data engineers who are new to Databrick SQL and want to learn how to deliver high-quality insights unhindered by the scale of data or infrastructure. This book is also for anyone looking to study the advanced technologies that power Databricks SQL. Basic knowledge of data warehouses, SQL-based analytics, and ETL processes is recommended to effectively learn the concepts introduced in this book and appreciate the innovation behind the platform.

What you will learn

Understand how Databricks SQL fits into the Databricks Lakehouse Platform

Perform everyday analytics with Databricks SQL Workbench and business intelligence tools

Organize and catalog your data assets

Program the data security model to protect and govern your data

Tune SQL warehouses (computing clusters) for optimal query experience

Tune the Delta Lake storage format for maximum query performance

Deliver extreme performance with the Photon query execution engine

Implement advanced data ingestion patterns with Databricks SQL

What do you get with eBook?

Instant access to your Digital eBook purchase

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

AI Assistant (beta) to help accelerate your learning

Frequently bought together

Business Intelligence with Databricks SQL

₱2398.99

SQL Server Query Tuning and Optimization

₱2653.99

₱2653.99

Total ₱ 7,706.97

AL Oct 25, 2022

Reading this book is like learning from a private tutor. The book covers the Databricks Lakehouse architecture, data security and governance. The author uses simple, easy to understand diagrams and examples to illustrate how various components such as Delta Lake, Unity Catalog, SQL Warehouse, Photon etc fits within the Lakehouse architecture. Whether you are new or an experienced Databricks users, you will find something useful and refreshing. The lab exercises on Databricks SQL is fun to follow as it uses real world data sets and the benchmarking using TPC-DS dataset is a bonus!

Amazon Verified review

amazonVerifiedBuyer Dec 10, 2022

It is well written, with good explanations, and concrete examples, and it covers a large variety of topics. The author knows what he is talking about.The writing and examples are all very clear, and there are plenty of figures and code snippets to help you follow along, as well as some diagrams to explain certain concepts. What is particularly good about this book, it's that it is written from experience on the fields. It's not academic book describing how things should work. It is actually coming from experience with real projects.I had the opportunity to review the book Business Intelligence with Databricks SQL by Vihag Gupta, a master practitioner of the Databricks platform.This book is great for both newcomers and experienced users of the Databricks platform. It starts with a nice overview that can get anyone up to speed in no time. However, as you progress, Vihag will start to dig deeper into traditional SQL and Databricks SQL (including Photon).If you have been curious about Photon, this book will allow you to better understand the internals and know how to write efficient, optimal queries.

Amazon Verified review

Kieran O'Driscoll Nov 13, 2022

This book walks through each component of the Databricks Lakehouse platform and covers the basics along with more technical aspects. The section on the Photon engine was extremely helpful in understanding how Databricks SQL is so powerful.A great read for anyone getting started on the Lakehouse journey!

Amazon Verified review

vfortier Oct 27, 2022

Great book about Databricks SQL, how to set it up, how to use it and how to make the best of it. Highly recommended

Amazon Verified review

Hales Sep 20, 2022

This book provides both high-level context and detailed examples and explanations, which are useful for novice to experienced BI practitioners and data engineers supporting BI workloads. As the book does not cover set-up, it will be most beneficial for those with access to an existing environment and some experience with SQL. The book is written in simple, easy-to-understand explanations and loaded with screenshots, code snippets, and diagrams to support the concepts covered.The book's first section is helpful if you are new to cloud architecture and jump into the product with a tour. The data and security chapters cover storing and accessing data and the latest Unity catalog components. While the book doesn’t go deep on user provisioning, it has enough detail to understand privileges to secure your tables, views, and dashboards. The SQL warehouse chapter dives into the architecture in the cloud and includes case studies around how to scale your data and manage performance. The BI section has code and screenshots using built-in datasets that you can follow along to build a dashboard or connect to an external tool. The second section goes deep into the nuts and bolts of Databricks SQL, optimizations and performance features, and the underlying engines. It ends with an example implementation of a cloud data warehouse using the lakehouse architecture and is geared towards people familiar with data modeling and warehouse design.The third section has SQL commands with many code examples, including CDC commands, time travel, and dealing with nested data. The last section has exercises around a TPC-DS dataset, using IDEs, more case studies, and FAQs. Note that you will need the jar file from GitHub. The last two sections are dense with information but are still easy to follow.One thing worth mentioning is that the features outlined in this book are not available in the free Databricks Community edition, so you will need a standard or enterprise account to follow along with the examples and create the dashboard, alerts, etc.

Amazon Verified review

Business Intelligence with Databricks SQL: Concepts, tools, and techniques for scaling business intelligence on the data lakehouse

What do you get with eBook?