Clark Perucho – Medium

Clark Perucho

Pinned

Clark Perucho
in
Snowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data Science

Snowflake: Minimize Storage Cost

The two main drivers of Snowflake cost are storage and compute; The good thing about Snowflake pricing is that all charges are usage-based…

Jul 1, 2022

Snowflake: Minimize Storage Cost

Jul 1, 2022

Pinned

Clark Perucho
in
Snowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data Science

Snowflake: Accelerate Query Performance

Snowflake by nature is “optimized”, it stores the data granularly via micro-partitions, organized in columnar fashion. This enables…

Mar 29, 2022

Snowflake: Accelerate Query Performance

Mar 29, 2022

Pinned

Clark Perucho
in
Snowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data Science

Snowflake Data Protection: Incorporate Object-Tagging With Data Masking Policy

On large, global enterprises collecting, processing and providing data to and from multiple locations across the world, it is common to…

Oct 19, 2021

Snowflake Data Protection: Incorporate Object-Tagging With Data Masking Policy

Oct 19, 2021

Pinned

Clark Perucho

Snowflake Time Travel: A Window To The Past

Let's face it, we make mistakes. Sometimes, even when we're just trying to fix a minor issue, we end up escalating it to an even greater…

Aug 1, 2021

Snowflake Time Travel: A Window To The Past

Aug 1, 2021

Pinned

Clark Perucho

Snowflake: Query Optimization Using Materialized View

Requirements

Aug 15, 2021

Snowflake: Query Optimization Using Materialized View

Aug 15, 2021

Clark Perucho
in
Snowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data Science

Snowflake: Query Acceleration Service — The Warehouse Booster

The Query Acceleration Service (QAS) is now generally available to all Snowflake Accounts — Enterprise edition and up. It is a feature…

Mar 1, 2023

Snowflake: Query Acceleration Service — The Warehouse Booster

Mar 1, 2023

Clark Perucho
in
Snowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data Science

Snowflake: Query Tuning Guide

Before we dive into the steps of query optimization, it is important to ask ourselves this question: Why do I need to tune queries? What am…

Dec 24, 2022

Snowflake: Query Tuning Guide

Dec 24, 2022

Clark Perucho
in
Snowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data Science

Snowflake: EXPLAIN is more than just explanations

I’m using EXPLAIN in my day to day life as a Snowflake Administrator. It is a simple and straightforward feature which makes it easy to be…

Jun 20, 2022

Snowflake: EXPLAIN is more than just explanations

Jun 20, 2022

Clark Perucho
in
Snowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data Science

SnowPro Advanced: Administrator — Exam Tips

Early this year (2022), Snowflake announced a new addition to the Advanced Series of their Certification, the SnowPro Advanced…

May 23, 2022

SnowPro Advanced: Administrator — Exam Tips

May 23, 2022

Clark Perucho
in
Snowflake Builders Blog: Data Engineers, App Developers, AI/ML, & Data Science

Snowflake SWAP WITH: The Common Misconception

Snowflake supports swapping two tables using the ALTER TABLE … SWAP WITH command. Is it however very easy to make assumptions that are…

Feb 22, 2022

Snowflake SWAP WITH: The Common Misconception

Feb 22, 2022

Clark Perucho

Clark Perucho

Snowflake Data Superhero | Certified SnowPro: Administrator | Teradata 14 Certified Technical Specialist

Following

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams