using Snowflake ………… Sure, we need to do some infrastructure setup, for that, use the links below. And I had to use the Guy in a Cube blog to figure out how to use PowerBI with JSON. …

Building a Streamlit app that displays data from a Snowflake table on screen. My starting point with an example: this Medium post. The post dives extensively into the Snowflake setup, feel free to read the original post to set this up. Same goes for the setup of the Python venv…

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