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.
For the latest information about new functionality in Snowsight, refer to the release notes:
About the Snowsight Upgrade¶
As a Snowflake user, your web interface access might be in one of the following states during the Snowsight upgrade process:
Who are you? |
Web interface access |
See more details |
---|---|---|
User in a Snowflake organization created after May 30, 2023, such as a trial account. |
You only have access to Snowsight. You do not have access to Classic Console. |
Snowsight is the only interface available to all accounts in your organization. |
User in a Snowflake On Demand account, or another account that opted in. |
You see Snowsight when you log in. You can still access Classic Console. |
All users in the account have Snowsight as the default web interface. |
Another Snowflake user. |
You see either Snowsight or Classic Console when you sign in, depending on what you select as your Default Experience for your user profile preferences. . . New users have Snowsight set as the default web interface. . . You can still access Classic Console and can change your default web interface. |
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. Users and accounts in those organizations cannot access Classic Console.
Snowsight is Set as the Default for an Account¶
All customers of Snowflake On Demand, and other accounts that have opted in, have Snowsight set as the default web interface for all users in the account.
Note
After Snowsight is set as the default interface for an account, individual users can no longer set a default experience on their user profile.
You can still access Classic Console after signing in to Snowsight.
This change was made for users in Snowflake On Demand accounts as part of a behavior change included in bundle 2023_04: Snowsight: Default Interface for All Users of Snowflake On Demand™.
You can also contact your Snowflake account representative to set Snowsight as the default experience for all users in your account.
You Can Choose the Default Web Interface 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:
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. See 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.
Note
All new users added to a Snowflake organization have Snowsight set as the default experience for their user profile because of changes introduced in behavior change bundle 2023_04. See Snowsight: Default Interface for New Users.
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.
About Using Both Snowsight and the Classic Console¶
If you choose to use both Snowsight and the Classic Console, keep in mind that 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. See Exploring Overall Cost.
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 Preparing Private Connectivity for Snowsight in Snowflake Community and 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.