Skip to main content

View and manage queries

This page describes how you can use the SAP Databricks UI to access and manage your queries.

View and organize queries

You can view queries using the following methods:

  • Click Workspace Icon 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 Icon 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.

You can organize queries into folders in the workspace browser.

Configure query permissions

Workspace admins and the query creator are automatically granted permissions to control which users can manage and run queries. You must have at least CAN MANAGE permission on a query to share queries.

Queries support two types of sharing settings:

  • Run as viewer: The viewer's credential is used to run the query. The viewer must also have at least CAN USE permissions on the warehouse. Users can only be granted the CAN EDIT permission when the sharing setting is set to Run as viewer.
  • Run as owner: The owner's credential is used to run the query.
  1. In the sidebar, click Queries.
  2. Click a query.
  3. Click the Share button at the top right to open the Sharing dialog.
  4. Follow the steps based on the permission type you want to grant:
  5. Search for and select the groups and users, and assign the permission level.
  6. Click Add.
  7. In the Sharing settings > Credentials field at the bottom, select either Run as viewer or Run as owner.

You can also copy the link to the query in the Sharing dialog.