41 Data Warehousing using DBSQL | SQL Warehouses on Databricks | SQL Query Performance Tuning

Video explains - How to do Data Warehousing in Databricks? What is DBSQL? What are SQL Warehouses in Databricks? How to tune SQL Queries using Query Profile? How to monitor SQL Query Performance? What is Serverless SQL Warehouse? What are the benefits on Data Warehousing on Databricks? Chapters 00:00 - Introduction 01:08 - DBSQL References 01:22 - Types of SQL Warehouses in Databricks 02:31 - Get Started with SQL Warehouse in Databricks 03:04 - SQL Editor in Databricks 03:28 - Create SQL Warehouse in Databricks 05:26 - Connecting SQL Warehouse to BI tools 06:14 - Monitoring in SQL Warehouse 06:39 - How to write SQL queries in Databricks? 09:43 - SQL Query Profile and Query Monitoring 13:20 - Scheduling SQL Queries 13:66 - Visualization of Query Results Databricks Website: www.databricks.com SQL Warehouse Types - https://docs.databricks.com/aws/en/compute/sql-warehouse/warehouse-types SQL Warehouse Cluster Sizes - https://learn.microsoft.com/en-us/azure/databricks/compute/sql-warehouse/warehouse-behavior The series provides a step-by-step guide to learning Databricks, a popular unified Data Intelligence Platform. New video in every 3 days ❤️ Follow Subham Khandelwal on LinkedIn and Don't forget to Share - https:// www.linkedin.com/in/subhamkharwal/ Disclaimer: This series is meant only to learning and teaching purpose. The host/tutor can not be held responsible for any misuse or any comments. The thoughts and views are of the tutor, it has nothing to do with the employer. #databricks #dataengineering #spark