Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.databricks.com/aws/en/sql/user/queries/ below:

Access and manage saved queries

This article outlines how to use the Databricks UI to access and manage queries.

You can view queries using the following methods:

You can organize queries into folders in the workspace browser and other Databricks objects. See Workspace browser.

You must be a workspace admin to transfer ownership of a query. Service principals and groups cannot be assigned ownership of a query. You can also transfer ownership using the Permissions API.

1. As a workspace admin, log in to your Databricks workspace.

2. In the sidebar, click Queries.

3. Click a query.

4. Click the Share button at the top right to open the Sharing dialog.

5. Click on the gear icon at the top right and click Assign new owner.

6. Select the user to assign ownership to.

7. Click Confirm.

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. In the legacy SQL editor, users can only be granted the CAN EDIT permission when the sharing setting is set to Run as viewer.
• Run as owner: In the new SQL editor, the owner's credential is used for legacy alerts, Lakeflow Jobs, and legacy dashboards. The viewer's credential is always used to run the query. In the legacy SQL editor, the owner's credential is used to run the query.

For more information on query permission levels, see Query ACLs.

1. In the sidebar, click Queries.

2. Click a query.

3. Click the 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.

A 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:

1. Click Queries in the sidebar.
2. Click the All queries tab near the top of the screen.

You can create queries without using the Databricks UI using the Rest API, a JDBC/ODBC connector, or a partner tool.

See SQL connectors, libraries, drivers, APIs, and tools to run SQL commands and browse database objects in 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.

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4