Working with workspaces¶

Manage files¶

You can rename, delete, move, and organize your workspaces, files, and folders.

To rename or delete a workspace, file, or folder, follow these steps:

1. Hover over the target and select the vertical ellipsis (more actions).

2. Select Rename or Delete. If you choose to delete, you are prompted to confirm.

• To create a folder in a workspace, select the + next to the workspace or an existing folder.

• To organize files and folders, drag any file or folder into a different location in the same workspace. You can also drag a worksheet into a workspace.

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.

View multiple files or results in one layout¶

Managing multiple files with tabs and split panes offers several advantages:

• Compare code or results side by side: Quickly reference one worksheet query while working on another.

• Multitask more efficiently: View different cells, outputs, or files at once with less switching.

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.

Recover a workspace from a dropped user¶

Even when a user is dropped, their personal database (PDB) and all files within their workspaces are retained. The PDB is then renamed to DROPPED_USER$<dropped_user_name>_<timestamp>.

To recover a workspace from a dropped user’s PDB, follow these steps:

1. Find the dropped user’s PDB. Use the SHOW DATABASES command with a LIKE function to locate the specific database:

   SHOW DATABASES LIKE 'dropped_user%';
   

   Copy

2. View the workspaces in the PDB. Use the SHOW WORKSPACES IN DATABASE command to list the available workspaces:

   SHOW WORKSPACES IN DATABASE DROPPED_USER$dropped_user_1754344912;
   

   Copy

3. Create a new workspace from the recovered one. Use the CREATE WORKSPACE … FROM command to create a new workspace from the recovered one.

   This copies the content to a new location, making it accessible.

   Note

   You must use the USER$ qualifier to put the workspace in your own personal database. Otherwise, an error occurs. The timestamp at the end of the database name varies.

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

   Copy