This feature is in Public Preview. Contact your Azure Databricks representative to request access.
This article introduces the set of fundamental concepts you need to understand in order to use Azure Databricks SQL Analytics effectively.
This section describes the interfaces that Azure Databricks supports for accessing your Azure Databricks SQL Analytics assets: UI and API.
UI: A graphical interface to dashboards and queries, SQL endpoints, query history, and alerts.
REST API An interface that allows you to automate tasks on SQL endpoints and query history.
SQL endpoint: A connection to a set of internal data objects on which you run SQL queries.
External data source: A connection to a set of external data objects on which you run SQL queries.
Visualization: A graphical presentation of the result of running a query.
Dashboard: A presentation of query visualizations and commentary.
Alert: A notification that a field returned by a query has reached a threshold.
This section describes concepts that you need to know to run SQL queries in Azure Databricks SQL Analytics.
Query: A valid SQL statement that can be run on a connection.
Query history: A list of executed queries and their performance characteristics.
Authentication and authorization
This section describes concepts that you need to know when you manage Azure Databricks
User and group: A user is a unique individual who has access to the system. A group is a collection of users.
Access control list: A set of permissions attached to a principal that requires access to an object. An ACL entry specifies the object and the actions allowed on the object. Each entry in an ACL specifies a principal, action type, and object.