Monitor and Optimize Queries in Databricks SQL
You must decide where to position yourself on this curve for each type of load.
Sign in to read this course
A free account unlocks all 514 courses. 20 are readable without one.
What's inside
8 sections- 1 Table of Contents
- 2 Understanding query execution in Databricks SQL
- 3 Monitor Queries with Query History and Query Profile
- 4 Diagnose and Fix Bottlenecks
- 5 Optimizing Delta Tables for Performance
- 6 Scaling and Planning for Profitability
- 7 Summary of best practices
- 8 Quick reference of essential SQL commands
More Azure Databricks & Spark courses
View all 14Administering Clusters and Configuring Policies with Databricks
Databricks architecture, cluster types and runtimes, autoscaling, cluster policies, pools and init scripts.
ETL Pipelines with Azure Databricks and Data Factory
Build ETL with Spark and PySpark, Unity Catalog governance, Delta Lake and Databricks vs Data Factory.
Manage Data with Azure Databricks and Azure Data Lake
Connect Databricks to ADLS Gen2 securely, ingest with Auto Loader and govern with Unity Catalog.
Optimize Storage and Performance with Delta Lake
Delta Lake internals, ACID, OPTIMIZE, Z-Order, liquid clustering, caching and Photon acceleration.
Real-Time Data Processing with Azure Databricks
Spark Structured Streaming with Event Hubs — windowing, stateful processing and real-time anomaly detection.
Machine Learning with Azure Databricks
The Databricks ML lifecycle: MLflow tracking, tuning with Ray, the model registry, serving and AutoML.
Interested in this course?
Contact us to book it or get a custom training plan for your team.