TL;DR: install this VSCode Extension to execute Snowflake queries directly from within Visual Studio Code: Snowflake (Public Preview) — Visual Studio Marketplace

Test 1: does it work with SSO (Single Sign-On):

Single Sign-On

Yes, it does. It even recognizes automatically that the account entered used SSO. In the Username field: enter your IDP user, normally this will be the e-mail adress instead of your “regular” Snowflake account.

Althougth the message that appears in the browser is a bit clunky, it does the job:

--

--

Johan

I am a freelance data engineer. My main focus is Snowflake, but I am always eager to learn new things. Python and AWS are my main side interests