使用工作区¶

管理文件¶

您可以重命名、删除、移动和整理工作区、文件和文件夹。

要重命名或删除工作区、文件或文件夹，请执行以下步骤：

1. 将鼠标悬停在目标上并选择垂直省略号 |vertical-ellipsis|（更多操作）。

2. 选择 Rename 或 Delete。如果您选择删除，系统会提示您确认。

• 要在工作区中创建文件夹，请选择工作区或现有文件夹旁边的 +。

• 要整理文件和文件夹，请将任何文件或文件夹拖动到同一工作区中的其他位置。您也可以将工作表拖放到工作区中。

Format SQL code¶

Workspaces include a built-in functionality to format and standardize SQL code for improved readability and maintenance.

1. In the Workspaces editor, select the horizontal ellipsis.

   

2. Select Format SQL or use the keyboard shortcut command + shift + O (Windows: CTRL + Alt + O).

Organize sections of code¶

Use code folding to collapse and expand large blocks of code, allowing you to focus on specific sections and improve overall code navigation.

1. In the Workspaces editor, locate the code section to collapse.

2. Hover the mouse to the right of the line numbers. A code folding icon () appears at the fold line.

3. Toggle the icon to fold or unfold the section of code.

在一个布局中查看多个文件或结果¶

使用选项卡和拆分窗格管理多个文件有多方面的优势：

• 并排比较代码或结果：在处理另一个工作表查询时，快速参考一个工作表查询。

• 更高效地处理多项任务：只需较少的切换次数，即可同时查看不同的单元格、输出或文件。

To adjust your Workspaces layout, select the vertical ellipsis () in the Workspaces pane and choose the appropriate option:

1. Split right

2. Split down

3. Close others

Use interactive column statistics¶

Each column in your query results includes interactive visual statistics (mini graphs or histograms) that help you understand data distribution and quality. You can click these statistics to open a detailed panel and create filters.

To view column statistics:

1. Run a query in a Workspaces SQL file.

2. In the results table, show the column statistics by doing one of the following:

   • Click Show column stats in the top-left corner of the table (next to the column headers).

   • Click the ellipsis button in any column header and select Show column stats.

   Mini graphs (histograms or distribution charts) appear in each column header showing the data distribution.

3. Click a histogram to view sum and average values for that entire column in the bottom-right of the table.

   Alternatively, you can select a range of cells in the results table to view statistics in the bottom-right of the table. For numeric columns, sum and average values are displayed. For non-numeric columns, the count is displayed.

To filter using column statistics:

1. Click Show column stats in the top-left corner of the results table, or click the ellipsis button in any column header and select Show column stats.

2. Click the histogram for the column you want to filter by. A popover displays detailed statistics for that column, including:

   • Sum and average values for numeric columns

   • Distribution charts showing value frequency

   • Data quality metrics such as null and filled percentages

3. In the popover, select the values or ranges you want to filter by.

4. Select Apply to apply the filter to your results.

This interactive filtering helps you explore your data visually without writing WHERE clauses or other SQL filter logic.

Inspect cell values¶

The cell inspector provides detailed information about individual cells or selections in your query results.

To inspect a single cell:

1. In the results table, double-click any cell to open the Inspector Panel.

2. Review the detailed value, including formatting and data type information.

To view aggregate statistics for multiple cells:

• In the results table, select multiple cells by clicking and dragging across rows and columns.

  A statistics bar appears at the bottom showing:

  • Sum of numeric values

  • Average of numeric values

  • Count of selected cells

  • Min and max values in the selection

This feature is useful for quick calculations and data exploration without creating new queries.

从已删除的用户恢复工作区¶

即使用户被删除，其个人数据库 (PDB) 及工作空间中的所有文件仍会被保留。然后，PDB 被重命名为 DROPPED_USER$<dropped_user_name>_<timestamp>。

要从已删除用户的 PDB 恢复工作区，请按照以下步骤操作：

1. 查找已删除用户的 PDB。使用 SHOW DATABASES 命令和 LIKE 函数查找特定数据库：

   CopyExpand

   SHOW DATABASES LIKE 'dropped_user%';
   

   Show lessSee more

   Scroll to top

2. 查看 PDB 中的工作区。使用 SHOW WORKSPACES IN DATABASE 命令列出可用工作区：

   CopyExpand

   SHOW WORKSPACES IN DATABASE DROPPED_USER$dropped_user_1754344912;
   

   Show lessSee more

   Scroll to top

3. 从恢复的工作区创建一个新工作区。使用 CREATE WORKSPACE ... FROM 命令，从恢复的工作区创建新工作区。

   这会将内容复制到新位置，使其可被访问。

   备注

   您必须使用 USER$ 限定符，将工作区放入您自己的个人数据库中。否则，会发生错误。数据库名称末尾的时间戳各不相同。

   CopyExpand

   FROM 'snow://workspace/DROPPED_USER$dropped_user_1754344912.PUBLIC."to_be_recovered"/versions/head';
   

   Show lessSee more

   Scroll to top