Getting started with worksheets

View and create worksheets in Snowsight. You can also import existing SQL worksheets from the Classic Console.

SQL worksheets let you write and run SQL statements, explore and filter query results, and visualize the results. See Querying data using worksheets and Visualizing worksheet data. You can also write Snowpark Python in worksheets. See Writing Snowpark Code in Python Worksheets.

Manage your worksheets by organizing them into folders, share worksheets with colleagues that also use Snowflake, and manage the version history for worksheets. For more details, see Managing and using worksheets in Snowsight.

Viewing worksheets in Snowsight

After signing in to Snowsight, you see the worksheets in your account. If you don’t see any worksheets, you might need to import worksheets from the Classic Console. See Import worksheets from the Classic Console.

Using the options, you can view recent worksheets opened by you, worksheets that your colleagues have shared with you, worksheets that you created and own, or folders you created or that your colleagues have shared with you.

For any worksheet or worksheet folder, you can review the title, roughly when the worksheet or folder was last viewed or updated, and the role associated with the worksheet or folder. In each row, you can see the initials of the user that owns the worksheet or folder. You can sort by any column in the table.

Use the Search option to search the titles and contents of worksheets and dashboards that you can access.

Import worksheets from the Classic Console

You can import your SQL worksheets from the Classic Console to Snowsight from within Snowsight.

Import your SQL worksheets to make it easier to refer to queries and SQL statements that you’ve written in the past, without needing to switch to a different web interface and session.

Note

You can import your worksheets to Snowsight even if you can no longer access the Classic Console.

To import your SQL worksheets to Snowsight, do the following:

  1. Sign in to Snowsight.

  2. Select Projects » Worksheets.

  3. Select the … more menu » Import Worksheets.

    Select Options for worksheets, then select Import Worksheets.

  4. In the confirmation dialog, select Import.

Snowflake creates a folder named Import YYYY-MM-DD and places all worksheets from the Classic Console in that folder.

Important

Snowsight has a maximum worksheet size of 1MB. Worksheets larger than 1MB fail to import. See Troubleshoot issues with upgrading to Snowsight.

After importing worksheets

Worksheets are not synced between Snowsight and the Classic Console. If you make updates to a SQL worksheet in Snowsight, the changes are not reflected in the Classic Console, and vice versa.

Create worksheets in Snowsight

To create a worksheet in Snowsight, do the following:

  1. Sign in to Snowsight.

  2. Select Projects » Worksheets to open the list of worksheets.

  3. Select + and select SQL Worksheet or Python Worksheet to create a worksheet.

The worksheet opens in the same window with the date and time of creation as the default title.

You can then start writing in your worksheet. For a SQL worksheet, start writing queries. For a Python worksheet, start writing code.

Create worksheets from a SQL file

To create a SQL worksheet from an existing SQL file, do the following:

  1. Sign in to Snowsight.

  2. Select Projects » Worksheets to open the list of worksheets.

  3. Select the … more menu » Create Worksheet from SQL File.

  4. Browse to the SQL file to upload.

  5. A new worksheet opens with a title that matches the file name.

You can also add a SQL file to an existing SQL worksheet. Refer to Append a SQL script to an existing worksheet.

Opening worksheets in tabs

You can use tabs to refer to multiple active worksheets and explore the databases and schemas in Snowflake while writing SQL statements or Python code in Snowsight. Your scroll position is preserved in each tab, making comparisons across worksheets easier to perform. Worksheet tabs are preserved across sessions, so you can pick up your work where you left off.

To open your Snowsight worksheets in tabs, do the following:

  1. Sign in to Snowsight.

  2. Select Projects » Worksheets.

  3. Select an existing worksheet, or select + Worksheet to open a new worksheet. A worksheet opens in a tab.

  4. Select a role to run the worksheet as, and select a warehouse to allocate the compute resources for your query.

  5. In the Worksheets menu, select an existing worksheet or select + to open a new worksheet tab. By default, the new worksheet uses your default role and warehouse.

  6. (Optional) Make changes to the role or warehouse used to run the new worksheet.

After you open a worksheet, you can update the contents, run SQL statements or write Python code, and manage the worksheet.

Language: English