Snowflake Pro  [draft]

Reference Snowflake: SnowPro Certifications

August 24, 2020 · 1 min · 4 words · Eric

Snowflake Concepts

Basic Concept Snowflake is a new model cloud-based enterprise-level data warehouse. Architecture Snowflake’s architecture is a hybrid of traditional shared-disk database architectures and shared-nothing databases architectures. Similar to shared-disk architectures, Snowflake uses a central data repository for persisted data that is accessible from all compute nodes in the data warehouse. But similar to shared-nothing architectures, Snowflake processes queries using MPP (massively parallel processing) compute clusters where each node in the cluster stores a portion of the entire dataset locally....

May 13, 2020 · 3 min · 625 words · Eric

Snowflake Common Command Reference

DML Show warehouse with filters 1 SHOW WAREHOUSES like '%testing%'; Show most recent query ID 1 SELECT last_query_id() If you want to retrieve the second most recent query ID, you can also provide -2 argument and do something like 1 SELECT last_query_id(-2) Reference Snowflake: General Reference

May 12, 2020 · 1 min · 46 words · Eric

Snowflake Note IV - Data Ingestion  [draft]


May 10, 2020 · 1 min · word · Eric

7 Best Practices for Snowflake

General Introduction Key customers 7 Best Practices for Building Data Applications Isolation workloads with Snowflake Key features Zero-Copy Clone Time Travel AS OF feature Semi-structured Support add timestamp column Materialized Views Snowflake materialized views is different with other platforms Code in your Language snowflake connection diagnose system SnowPipe Use the Ecosystem Manage Cost Manage compute configure with Auto Suspend configure with Auto Resume configure suspend window after idle time window Monitoring resources all data app utilise resource monitoring FAQ Q: Does Snowflake a transactional database?...

May 5, 2020 · 5 min · 991 words · Eric