Visual Studio Code (VSCode from now on) is my go-to tool for code editing. One of my favourite features is the use of Workspaces. A Workspace is a collection of one ore more folders with code. How do you create a Workspace ? The Workspace operations are under the File…

Today I was presenting Snowflake to some smart people, there I got the question: when you run a query twice, and the second run comes from cache, but after that a record is inserted in one of the tables ….. …

TL;DR: paste “#/get-started” after your Snowflake URL to find a new CSV import option When you want to load a csv into Snowflake and you want to do it quick, it might not be that easy. One option is to put the file on some cloud storage (AWS S3 for…

This private preview (PrPr) feature offers a nice Change Data Capture (CDC)-like feature on Snowflake tables, that you would normally solve with Streams&Tasks. To set this up is really easy (for a first demo). First, create a ‘source’ table: create or replace table t1 as select 1 as sleutel Now…

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.

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: AWS Professional Services — AWS Partner Learning Path | Training and Certification | AWS (amazon.com) 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

list all branches by author for a repo — git for-each-ref --format=' %(authorname) %09 %(refname)' --sort=authorname which -a python

Note: while it is highly recommended to run Python in a virtual environment, setting up this venv is not in scope for this post. Perhaps I will adress that in a later stage. For now I am using Anaconda for that purpose, running Python 3.10.4. Note 2: what also is…