Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Common Strategies for Improving Performance on Delta Lakehouse

Databricks via YouTube

Overview

Explore common strategies for enhancing performance in Delta Lakehouses in this 31-minute video from Databricks. Learn techniques to improve query performance for data analysts, including data skipping, index column optimization, string handling, Z-Order optimization, SQL partitioning, and Delta Cache management. Dive into the Delta Architecture pattern and its Silver layer, and understand multidimensional curves. Watch a practical demonstration of these concepts to gain insights on analyzing queries and implementing performance-boosting measures for your Delta tables.

Syllabus

Introduction
Data skipping num index columns
Moving long strings
Optimizing Z Order
SQL Partitions
Delta Cash staleness
Delta Architecture
Silver
Multidimensional curves
Demonstration

Taught by

Databricks

Reviews

Start your review of Common Strategies for Improving Performance on Delta Lakehouse

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.