Simple play icon Course
Skills

Performing Administrative Tasks in Databricks SQL

by Kishan Iyer

This course covers the administration of various resources on Databricks SQL to ensure its users have clearly-defined roles and permissions. This will enable them to make the most of this big data platform while regulating resource expenses.

What you'll learn

Effective administration of any service ensures that users are able to perform their roles effectively, and without interfering with the work of others on the same platform. In this course, Performing Administrative Tasks in Databricks SQL, you will learn about assigning roles and entitlements to resources such as endpoints, queries, and dashboards to help users get the best out of this platform, all while keeping costs under control. First, you will discover how to access the Databricks SQL platform itself and how it can be regulated and have roles assigned by an administrator of a workspace, Next, you'll explore how SQL endpoints can be regulated by ensuring that only the right users have the ability to provision, configure, and use them for query executions. Finally, you'll learn how queries and dashboards can be shared with other users for both collaboration during development and for use by analysts to execute and examine query results. Once you have completed this course, you will have an all-round view of administration on the Databricks SQL platform including the types of permissions associated with different resources, and how these map to users and roles on this service.

About the author

I have a Masters in Computer Science from Columbia University and have worked previously as a developer and DevOps engineer. I now work at Loonycorn which is a studio for high-quality video content. My interests lie in the broad categories of Big Data, ML and Cloud.

Ready to upskill? Get started