”When tuning performance it's often relatively easy fix the problem but much harder to identify the right problem to fix.”
— John Ryan
Free Webinar - April 10th 2024
Register at https://lu.ma/7xbm3ilg for a free online webinar on Snowflake Cost Savings & Performance tuning. Hurry - space are filling fast.
Reserve yours today!
What brings you here today?
New to Snowflake?
These articles showcase some of the best Snowflake features.
Do you Really need a Snowflake Database Administrator or DBA?
This article explains the roles and responsibilities of a Snowflake DBA and highlights some of the essential tasks of any Snowflake DBA or Snowflake Admin.
Snowflake Search Optimization Service Best Practices
This article explains how to speed point lookup queries using Search Optimization Service. It explains what it is, and includes best practices.
Snowflake Spilling to Storage in Plain English
This article explains how eliminating spilling to storage can execute queries over 100 times faster and 40% cheaper.
Snowflake Data Loading Best Practices: Bulk COPY operations
This article describes data Ingestion Best Practices for cost-effective bulk loading using the Snowflake COPY into TABLE command
Top 10 Snowflake Query Optimization Tactics
Snowflake supports no indexes on standard tables, so how do you tune SQL queries? This article explains precisely how.
Top 10 Tactics to get Snowflake Certified
Are you preparing for the Snowflake SnowPro certification exam? Get insider tips and tricks for success getting SnowPro Certified with this comprehensive guide.
Top 10 Strategies for Snowflake Cost Optimization
This article provides helpful advice on Snowflake certification. It lists the available certification exams and provides extensive advice on how to successfully pass the SnowPro Core exam.
Snowflake Unistore and Hybrid Tables Explained
This article introduces a seismic shift in database technology. Snowflake announced Unistore, a single unified platform for OLTP and OLAP workloads using Hybrid Tables
What is Snowflake Query Acceleration Service?
This article explains why Snowflake delivers a Cloud Data Platform for a diverse range of workloads including Data Warehousing, Engineering and Data Science.
Snowflake Zero Copy Clones and Data Storage
This article explains how Snowflake Zero Copy Clones work and how this sometimes leads to an explosion of data storage. It then provides a solution to identify and therefore delete redundant clones.
Top Snowflake ETL Best Practices for Data Engineers
What are the Best Practices for Data Engineering including Data Loading and Transformation? This article describes them
Snowflake Row Level Security in Plain English
This article describes how Snowflake supports row level security using policies. It goes on to demonstrate how to integrate fine grained access control (FGAC) into an Role Based Access Control architecture.
Designing Snowflake Role Based Access Solutions
This article presents a design methodology for snowflake role-based access control. It describes an overall architectural framework to ease the burdon of designing an extensible data governance framework.
Snowflake Accounts, Databases and Schemas: Best Practices
This article explains the best practices for Snowflake Account, Database and Schema deployment.
Snowflake System Defined Roles: Best Practices
This article explains the purpose of the Snowflake System Defined Roles and summarises the best practice for deploying these as part of the role-based access solution.
Introducing Snowflake Role Based Access Control
This article introduces the main concepts administrators and users need to understand Role-Based Access Control.
What is the Snowflake Data Warehouse?
This article explains why Snowflake delivers a Cloud Data Platform for a diverse range of workloads including Data Warehousing, Engineering and Data Science.
Snowflake Clustering Keys: Best Practice
This article explains how clustering in Snowflake can massively increase query performance from hours to seconds.
What is a Snowflake Virtual Warehouse?
A Snowflake Virtual Warehouse is a cluster of computer servers deployed within milliseconds and can be scaled up and down. This article explains how they work.