Upgrading to Snowsight¶
About Snowsight¶
Snowsight includes updated and extended functionality in the user interface, such as the following:
Granular usage views to help you govern costs.
The ability to enable database replication to other regions with one click.
User, account, and privilege management.
Organization for worksheets using folders.
Autocomplete for database objects and SQL functions in worksheets.
Dashboards with built-in visualizations.
Collaboration and sharing of worksheets and dashboards.
Enhanced data sharing with other accounts or publicly on the Snowflake Marketplace using listings.
No major new features have been released for Classic Console since April, 2022.
Differences Between Snowsight and Classic Console¶
The following functionality in Classic Console is coming soon to Snowsight:
View query results greater than 10,000 rows or 16MB in size.
View query history inside a worksheet.
Run worksheets in folders as any role, or use multiple roles within one worksheet. This change is available as part of bundle 2023_03. Refer to Snowsight: Roles Removed from Worksheet Folders (Pending) in the Snowflake Community.
For the latest information about new functionality in Snowsight, refer to the release notes:
About the Snowsight Upgrade¶
Your account might be in one of the following states during the Snowsight upgrade process:
All users in the account have Snowsight as the default web interface.
Snowsight is the only interface available to all accounts in your organization.
As of May 30, 2023, accounts in new organizations, such as most trial accounts and other new accounts, only have access to Snowsight.
Set Snowsight as the Default for Your User Profile¶
If Snowsight is not the default web interface for all users in your account, you can choose to set Snowsight as the default for your user profile.
To set Snowsight as your default web interface, do the following:
Sign in to Snowsight.
Select your username and select Profile.
For Default Experience, select Snowsight.
If you don’t see the option to select a default experience, your default web interface might be set at the account level. Refer to Snowsight is Set as the Default for an Account.
Select Save.
After you set Snowsight as the default for your user profile, you can access the Classic Console if needed using the Classic Console option in the menu.
Snowsight is Set as the Default for an Account¶
Important
In a future behavior change bundle, customers of Snowflake On Demand have Snowsight set as the web interface for their account.
For more details about the change, refer to the Pending Behavior Change Log in Snowflake Community.
For more details about Snowflake On Demand, refer to Snowflake Editions.
If you want everyone in your account to use Snowsight, you can work with your Snowflake Account Representative to set your entire account to use Snowsight as the default web interface. After Snowsight is set as the default interface for an account, individual users can no longer set a default interface for their user profile.
Snowsight is the Only Interface Available¶
Starting May 30, 2023, Snowsight is the only interface available to newly created organizations, such as for most trial accounts.
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:
Sign in to Snowsight.
Select Worksheets.
Select the … more menu » Import Worksheets.
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. Refer to 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.
Worksheets in a folder can only run with the role assigned to the folder.
To run a worksheet with a different role:
Move the worksheet to a folder with the required role.
Change the role for the folder. This change affects all worksheets in the folder.
To run a worksheet that uses multiple roles, move the worksheet out of a folder.
About Using Both Snowsight and the Classic Console¶
If you choose to use both Snowsight and the Classic Console, keep the following in mind:
Worksheets are not synced between Snowsight and the Classic Console. If you make updates to a worksheet in Snowsight, the changes are not reflected in the Classic Console, and vice versa.
Usage information might be different in Snowsight compared with the Classic Console because the Classic Console has a 2 million row limitation in the query used to calculate usage. Use Snowsight for accurate usage information.
Troubleshoot Issues with Upgrading to Snowsight¶
The following scenarios can help you troubleshoot common issues that can occur when upgrading your workflow to Snowsight.
I can’t access Snowsight¶
You might need to update network policies and firewall rules to allow Snowflake URLs access to Snowsight.
Refer to Signing in to Snowsight.
Some of my worksheets failed to import¶
Possible causes and resolutions:
- Cause
The worksheet is too large. Snowsight has a maximum worksheet size of 1MB and worksheets larger than 1MB fail to import.
- Solution
If you still have access to the Classic Console, consider whether you can split large worksheets into smaller worksheets that you can organize semantically in one folder, or do something similar.
- Cause
The worksheet uses an unsupported file version.
- Solution
If you still have access to the Classic Console, manually copy the contents of each worksheet that failed to import to a new worksheet in Snowsight.
- Cause
The worksheet failed to import and can’t be opened or run.
- Solution
If you still have access to the Classic Console, try to open the worksheet in Classic Console and copy the contents into a worksheet in Snowsight. If you cannot open the worksheet, contact Snowflake Support.
I don’t want my imported worksheets to be in a folder¶
To remove a worksheet from a folder, do the following:
In Snowsight, open the worksheet.
Select the worksheet name, and in the drop-down menu that appears, select Move to and choose the relevant option:
Select the name of an existing folder. The current parent folder for the worksheet is not an option to select.
Select + New Folder to create a folder and move the worksheet to that folder.
Select Remove from Folder to remove the worksheet from the folder.
The menu closes and the worksheet moves to the new location.
Note
You can’t move multiple worksheets at the same time. A worksheet can only be in one folder.