Azure Databricks SQL Administration

Summary

Learn how to configure and manage Databricks SQL for users.

Description

In this course, you will learn how to set up and configure access to the Databricks SQL user interface. The administrative tasks in this course will be done using the Databricks Workspace and Databricks SQL UI, and will not include instruction for API access. By the end of this course, you will be able to set up computational resources for users, grant and revoke access to specific data, manage users and groups, and set up alert destinations.

Learning objectives

  • Describe how Databricks SQL is used by data practitioners.

  • Manage user and group access to Databricks SQL.

  • Configure and monitor SQL Endpoints to maximize performance, control costs, and track usage on Databricks SQL.

  • Set up access to data storage through SQL endpoints or external data stores in order for users to access data on Databricks SQL.

  • Control user access to data objects (e.g. tables, databases, and views) by programmatically setting privileges for specific users and/or groups on Databricks SQL.

  • Create and configure Databricks SQL alert destinations for users.

Prerequisites

  • Intermediate knowledge of Databricks

  • Databricks account on the Premium plan (with Databricks SQL enabled)

  • Administrator credentials to your organization’s Databricks Workspace

Learning path

  • This course is part of the Platform Administrator learning path.

Proof of completion

  • Upon 80% completion of this course, you will receive a proof of completion.