工作区

概述

工作区提供了一个统一编辑器，用于创建、整理和管理跨多种文件类型的代码，可用于分析数据、开发模型和构建管道。

工作区 由您专有，它提供了一个开发环境，可供您在其中构建、实验和测试自己的工作。工作区中的所有内容均基于文件，这使您可以处理更复杂的项目，并轻松与 Git 集成，以实现版本控制、开展协作并与现有工作流程保持一致。

When a user accesses Workspaces for the first time, Snowflake automatically creates an internal, user-specific personal database. This database is used to store workspaces and cannot contain standard objects such as tables or views. It does not grant the user any additional capabilities or privileges beyond enabling Workspace functionality. For details on personal databases, see Personal Databases.

管理员可能会注意到，用户似乎拥有该数据库的 OWNERSHIP、USAGE、CREATE 和 SCHEMA 权限。这些是与工作区交互所必需的权限，不会影响对其他资源的访问。

工作区环境

工作区是一种新的编辑器，由六个部分或 窗格 组成：

1. Workspaces: One area for all your files and folders. Drag files to move them between folders. Use nested folders to group related worksheets under logical categories so that you can quickly find specific worksheets without searching through a flat list. Each user has a default workspace named “My Workspace” that is automatically provisioned by Snowflake. You can also create a new workspace by selecting + Add New in the Workspaces menu. The default workspace cannot be deleted or renamed.
2. Worksheets: Open and edit worksheets you own or have any permissions on. Note that edits will not be saved if you only have read permissions on the worksheet. To convert a worksheet into a file in a workspace, drag it to a folder inside the workspace. You can only move worksheets individually; moving multiple worksheets at once is not supported. Workspace queries are run similarly to worksheets with a few small differences, including improved UI performance and the ability to run two queries simultaneously from the same SQL file.
3. Database Explorer: A hierarchical view of all databases in your account, the schemas for each database, and other objects, organized by type. Use the filter to search for objects. You can also filter out unusable objects to simplify your view by selecting Show databases I can query. The options available in the vertical ellipsis (more actions) button vary by object type, but include features such as placing names in the editor, copying names, and viewing definitions. To open or close the Database Explorer or File Explorer, select the File Explorer icon in the bottom toolbar of the Workspaces window.
4. Editor: Edit queries and split them side by side to view multiple files simultaneously. Use inline Copilot to get suggestions and completions directly within the editor workspace.
5. 结果： 将结果置于并排拆分视图中，或者固定结果以便于比较。
6. Query History: View the history of all queries you have run. Current File shows historical queries from the file currently open and selected in the editor. Filter to the current file or across all files. All Files displays all historical queries you have run across all files. To open or close this view, select the Query History icon in the bottom toolbar of the Workspaces window.

Manage access and behavior¶

As an administrator, you can manage the transition to Workspaces through Snowsight or using SQL commands. You can set the default editor for SQL queries, disable the Workspaces feature, and address potential conflicts with existing security policies.

Set or revert the default editor¶

To set Workspaces as the account-wide default editor for all users from Snowsight, follow these steps:

1. Sign in to Snowsight as ACCOUNTADMIN.

2. In the lower-left corner, select your name » Settings.

3. Under Account, choose General.

4. Enable the Set Workspaces as default SQL editor for the account option.

   Administrators can revert to Worksheets as the default editor by disabling this option. If users want to revert to Worksheets, they can also select Go to Worksheets from the Workspaces UI:

   

   Or toggle the user setting in the Workspaces editor:

   

To set the account-wide default editor to be Workspaces for all users using SQL:

Copy codeExpand code block

ALTER ACCOUNT SET USE_WORKSPACES_FOR_SQL = 'always';

Show lessSee more

Scroll to top

To revert this setting and use the previous default editor, but respect any Snowflake-managed BCR that makes Workspaces the default, run this command:

Copy codeExpand code block

ALTER ACCOUNT UNSET USE_WORKSPACES_FOR_SQL;

Show lessSee more

Scroll to top

To revert to the previous editor and temporarily ignore any Snowflake-managed BCR that makes Workspaces the default, run this command:

Copy codeExpand code block

ALTER ACCOUNT SET USE_WORKSPACES_FOR_SQL = 'never';

Show lessSee more

Scroll to top

Disable Workspaces¶

To disable Workspaces, set the ENABLE_PERSONAL_DATABASE account-level parameter to FALSE, run this command:

ALTER ACCOUNT SET ENABLE_PERSONAL_DATABASE = FALSE;

This parameter requires ACCOUNTADMIN privileges. After you set it to FALSE, Workspaces will not be functional; however, Workspaces will still be listed in the Snowsight navigation menu.

限制

• Query filters are not supported. Any queries containing filters will fail.
• 工作区文件不会包含在 Universal Search 结果中。
• 在新工作区 UI 和旧工作表 UI 中同时打开和编辑同一个工作表可能会导致更改丢失。
• 对于工作表，新工作区 UI 和旧工作表 UI 中的执行上下文设置（角色、仓库和命名空间）不同步。