Snowflake Note I - General Introduction

General Introduction Basic ideas about Snowflake Separation of storage and compute Built for Cloud environment built from scratch optimized for cloud storage & compute is decoupled Software as a Service No software, infrastructure or upgrade to manage Pay only for used compute & storage Storage & compute charged independently, only for use Scalable Virtual warehouse enable compute scaling Authentication Configuration Resource Management Data Protection Availability Optimization Unique features in Snowflake Time travel Cloning More details can be found at {% post_link snowflake-online-talk ‘Snowflake Online Talk’ %}...

April 28, 2020 · 1 min · 176 words · Eric

Be Energetic

Energy Energy Types Physical Energy Emotional Energy Mental Energy Spiritual Energy Physical Energy Symptom & Complication I have lots of habits and lots of things I want to do, I am just too tired and out of energy to do it. This energy is probably the simplest one to understand. This is about your Sleeping Eating Exercising If you are not looking after yourself physically, you cannot achieve anything in life....

March 17, 2020 · 1 min · 210 words · Eric

Git - how to move a folder from one repo to another and keep its commits history

I was encountered into this situation that I need to transfer some existing code to another separated GitHub repository. Ideally it would be perfect to keep all historic git commit histories so that we can still be able to revert back if necessary. After digging into Google and Stack Overflow, luckily I found there are others who need to achieve similar things. Here is the solution I used to resolve this problem eventually....

March 15, 2020 · 2 min · 386 words · Eric

AWS Cloud Practitioner Exam Preparation

General Information Introduction to AWS Certified Cloud Practitioner Examination time is around 90 minutes. Examination score is between 100-1000, and the minimum passing score is 700. Exam Content Outline Domain 1 - Cloud Concepts (26%) 1.1 Define the AWS Cloud and it’s value proposition 1.2 Identify aspects of AWS Cloud economics 1.3 List the different cloud architecture design principles Domain 2 - Security and Compliance (25%) 2.1 Define the AWS Cloud shared responsibility model 2....

January 17, 2020 · 1 min · 165 words · Eric

Setup DataGrip Connection to AWS Athena with IAM Role Profile

Instructions Step 0 - Check Local AWS CLI Config Before you start to configure DataGrip, please ensure your AWS CLI config is EXACTLY like following screenshot IAM Role Profile needs to store in the credentials You can refer to this official AWS document: Configuration basics - AWS command-Line Interface Step 1 - Install DataGrip For Mac User Option 1: If you have brew installed on your workstation, you could execute the following command in your favourite terminal 1 brew install --cask datagrip Option 2: Download the executable at https://www....

December 11, 2019 · 2 min · 217 words · Eric