AWS Databricks SQL Administration

Summary

This course provides an introduction to the Databricks SQL user interface.

Description

Databricks SQL offers SQL users a platform for querying, analyzing, and visualizing data in their organizations Lakehouse. This course explains how Databricks SQL processes queries and guides users through how to use the interface. Then, this course will explain how you can connect to Databricks SQL to your favorite business intelligence tool, so that you can query your Lakehouse without making changes to your analytical and dashboarding workflows.

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.