Posts

Features and Architecture Snowflake Architecture Snowflake Editions Standard Edition Enterprise Edition Business Critical Edition Virtual Private Snowflake (VPS) Table Types Temporary Table Transient Table Permanent Table External Table Virtual Warehouse Data Spilling Caching Layers Query Result Cache Metadata Cache Warehouse Data Cache Clustering Cache (aka Partition Pruning Efficiency) Key Takeaways Time Travel Fail-safe Important Notes Summary Task Stored Procedure System Tables and Views Resource Monitors Account Access and Security Snowflake Account Roles Privileges Ownership Monitor Privilege Requirements for Common Use Cases Authentication Methods Multi-Factor Authentication (MFA) Federated Authentication (SSO) Network Policy Key Rotation Performance Concepts Scaling Policy Search Optimisation Service (SOS) Table Clustering Depth Materialised View Data Loading and Unloading Upload into Stage Snowflake Stage Internal Stage External Stage Temporary Stage Directory Table in Snowflake Stage COPY INTO Load data into Table Unload data from Table to Stage ON_ERROR Truncating column values PURGE=TRUE INSERT OVERWRITE Snowpipe Data Transformation VARIANT Data Type Clustering Key Automatic Clustering Flatten() Table Clone Privilege APPROX_COUNT_DISTINCT Sampling Data Protection and Data Sharing Data Sharing Row Access Policy External Functions Reference Features and Architecture Snowflake Architecture Snowflake uses a multi-cluster shared data architecture, means...

https://cloud.google.com/certification/guides/machine-learning-engineer Round out your skills with training

Billing and Cost Management User-Defined Cost Allocation Tags User-defined tags are tags that you define, create and apply to resources.After you have create and applied them, you can activate them on the Billing and Cost Management console for cost allocation tracking. The detailed steps are: Log in to the AWS Management Console of the new account Use the Tag Editor to create the new user-defined tags Use the Cost Allocation Tag manager in the payer account to mark the tags as cost allocation tags Certificate Manager (ACM) When you request a public certificate, AWS Certificate Manager (ACM) generates a public/private key pair...

General Idea The fundamental reason why other people wants to listen to you, and follow you is not because you know more than him/her, it’s because you care him/her. The more you care about your audience, the easier they can follow you. Keep telling the facts and figures won’t help you to influent other people. Instead, try to ask questions to your audience and keep them involved into the conversation is a better approach....

General Steps to Navigate Through Ambiguity Step 1 - Understand the Expectation What is your goal? What will success look like? Is this goal measurable? Step 2 - Describe & Evaluate Current Situation Step 3 - Categorise Goals with Cynefin Framework Simple Complex Complicated Chaos Step 4 - Work backward Apply the MECE Framework Mutually Exclusive Collectively Exhaustive In general, the starting point for MECE is hard to determine. What you can do is to use following methods and try to find the starting point, e....