I login via SSO and it loads up the classic UI. After SSO login I'm sent to specific url like https://company.us-east.snowflakecomputing.com/console#/internal/worksheet.
Is it possible for me in Snowflake to change my default editor from classic to Snowsight so it automatically loads after the SSO login? I'm not an Admin.
Yes, this feature is available where the default landing UI would be Snowsight instead of the current Classic UI. Please reach out to Support team to get more details on this.
Assuming there's nothing in your SSO setup to prevent this, if you log in using the following URL pattern, it should take you to Snowsight instead of getting there from the classic UI:
https://app.snowflake.com/<REGION>/<ACCOUNT>
Your sample URL will take you to the classic UI. To change it, go from this:
https://company.us-east.snowflakecomputing.com/console#/internal/worksheet.
To this:
https://app.snowflake.com/us-east/company
You just need to start with the correct URL for Snowsight on your account, rather than the URL for the classic UI, which us what you are showing in your question
Unless your set-up is unusual (and not pure SSO) then SSO doesn’t change URLs - it just returns you to your original URL once you have logged in.