Loading a csv into Snowflake
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…
Snowflake Dynamic Tables
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…
Snowflake & VSCode
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.
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