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):
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:
It is on my agenda: go through all Snowflake Core cerfitication. Here some links as guidance for the study process:
[COF-C02] SnowPro Core Certification Exam Guide | Snowflake University: On-Demand
After a couple of years on-and-off working with AWS (mainly EC2, S3, DMS, …..) I have decided to go through some training and perhaps certification. My first step was to check out the training path:
So, I logged on to my Udemy account and purchased the AWS Cloud Practitioner course by Stephane: https://www.udemy.com/course/aws-certified-cloud-practitioner-new
I’ll keep you posted here on the progress.