John RyanforAltimate Team Blogblog.altimate.ai·Nov 13, 2024Could AI Teammates Be the Secret to Efficient Snowflake Cost Management?In the past five years, Snowflake has disrupted the database, data storage, and analytics industry by massively simplifying the entire data and analytics landscape. However, a new wave of innovation is horizon - Artificial Intelligence and AI Teammat...Discuss·32 readssnowflake administration
John Ryanarticles.analytics.today·Sep 16, 2024Maximize Performance with Snowflake's Advanced FeaturesSnowflake offers advanced features that empower organizations to handle terabytes of data more efficiently and effectively. Query Acceleration Service, Cluster keys and Search Optimization Service stand out for their ability to significantly improve...Discuss·335 readssnowflake
John Ryanarticles.analytics.today·Sep 2, 2024How Snowflake Dynamic Tables Simplify ETL PipelinesSnowflake Dynamic Tables share functionality similar to Snowflake Streams and Materialized Views, yet they have distinct differences and advantages over the alternative solutions. This article will describe Dynamic Tables, their target use cases, and...Discuss·1 like·1.5K readssnowflake
John RyanforAltimate Team Blogblog.altimate.ai·Aug 25, 2024Does Size Matter? What else is important in choosing a Snowflake Warehouse?Having worked with over 50 Snowflake customers globally, I'm frequently asked the question: "What warehouse size do I need?" The answer (familiar to any experienced IT specialist), is..."It depends". In this article, I'll discuss warehouse size and w...Discuss·337 readssnowflake
John RyanforAltimate Team Blogblog.altimate.ai·Aug 13, 2024Introducing Snowflake Dynamic Tables: What you need to knowHaving worked with over 50 Snowflake customers building out complex data transformation pipelines, I understand how complex Extract, Transform, and Load (ETL) systems can get. Spoiler Alert: Damn hard! In this article, I'll explain the benefits of a ...Discuss·1 like·687 readsaltimateAI
John RyanforAltimate Team Blogblog.altimate.ai·Aug 5, 2024Snowflake Data Clustering: Expert advice to tune query performanceSnowflake data clustering is one of the most powerful techniques to maximize query performance, and yet it's by far the most misunderstood Snowflake feature available. In this article, we'll explain: Why does Data Clustering matter? What do we mean...Discuss·10 likes·813 readssnowflake
John Ryanarticles.analytics.today·Jul 21, 2024Improve Snowflake Query Speed by Preventing Spilling to StorageThis article will demonstrate how a simple Snowflake virtual warehouse change can lead to queries running over a hundred times faster and 40% cheaper. Plot spoiler - it involves spilling to storage. We will explain what causes spilling to storage, a...Discuss·958 readssnowflake spilling
John Ryanarticles.analytics.today·Jul 21, 2024Boost Your Snowflake Query Performance with These 10 TipsSnowflake Query Optimization The Snowflake query optimizer implements many advanced query-tuning techniques. However, Snowflake Indexes are not supported on default tables, raising an important question: How on Earth can you tune SQL queries on a da...Discuss·5.3K readsSnowflake performance
John Ryanarticles.analytics.today·Jul 21, 2024Best Practices: Snowflake Search Optimisation ServicesThe fact is that Snowflake Search Optimization Service is a superb way to maximize query performance for point-lookup queries. Yet, it’s one of the most misunderstood and poorly deployed Snowflake performance query tuning tools. It can be a really ef...Discuss·592 readssearch optimisation service
John Ryanarticles.analytics.today·Jul 21, 2024How Snowflake Query Acceleration Service Boosts PerformanceWhat is Snowflake Query Acceleration Service? Snowflake Query Acceleration Service (QAS) is a feature built into all Snowflake Virtual Warehouses which can dramatically improve query performance by automatically adding additional compute resources to...Discuss·644 readssnowflake
