Access and manage saved queries
This article outlines how to use the Azure Databricks UI to access and manage queries.
View queries
You can view queries using the following methods:
- Click Workspace in the sidebar. Queries are viewable, by default, in the Home folder. Users can organize queries into folders in the workspace browser along with other Databricks objects.
- Click Queries in the sidebar. Objects in the Queries windows are sorted in reverse chronological order by default. You can reorder the list by clicking the Created at column heading. Type into the Filter queries text box to filter by Name, Tag, or Owner.
Organize queries into folders in the workspace browser
You can organize queries into folders in the workspace browser and other Databricks objects. See Workspace browser.
Transfer ownership of a query
A workspace administrator can transfer ownership of a query. See Transfer ownership of a query.
Configure query permissions
Workspace admins and the query creator are automatically granted permissions to control which users can manage and run queries. see Share queries.
Admin access to all queries
An Azure Databricks workspace admin user has view access to all queries in the workspace. When the All Queries tab is selected, a workspace admin can view and delete any queries. However, a workspace admin can’t edit a query when sharing setting credentials are set to Run as owner.
To view all queries:
- Click Queries in the sidebar.
- Click the All queries tab near the top of the screen.
Creating queries in other environments
You can create queries without using the Azure Databricks UI using the Rest API, a JDBC/ODBC connector, or a partner tool.
See Use a SQL database tool to run SQL commands and browse database objects in Azure Databricks.
You can also create a query with the Databricks Terraform provider and databricks_sql_query.
See Technology partners to learn about partner tools you can use through Partner Connect.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for