Mahira Technology Private LimitedPromahiratechnology.hashnode.dev·Jul 22, 2024Snowflake Security Made Easy: Terraform Code for SSO SAML IntegrationOverview :- Snowflake, a cloud-based data warehousing platform, has become increasingly popular for its scalability and performance. However, ensuring proper security measures is crucial when dealing with sensitive data. One effective way to enhance ...Discusssnowflake
John RyanProarticles.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·38 readssnowflake spilling
John RyanProarticles.analytics.today·Jul 21, 2024Best Practices for Reducing Snowflake Costs: Top 10 StrategiesHaving worked at Snowflake for nearly five years, I’ve seen a lot of customers make avoidable but understandable mistakes and waste huge amounts of money. In this article I’ll explain my top 10 tips to optimize snowflake costs and ensure you get the...Discuss·34 readssnowflake
John RyanProarticles.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·263 readssnowflake
John RyanProarticles.analytics.today·Jul 21, 2024Best Strategies for Optimizing Snowflake Search 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·55 readssearch optimisation service
John RyanProarticles.analytics.today·Jul 21, 2024How to Decide if Data Vault is the Best Fit for Your Snowflake Data WarehouseData Vault is an innovative data modelling methodology for large scale Data Warehouse platforms. Invented by Dan Linstedt, Data Vault is designed to deliver an Enterprise Data Warehouse while addressing the drawbacks of the normalized (3rd normal for...Discuss·58 readsData Vault
John RyanProarticles.analytics.today·Jul 21, 2024Best Practices for Using Bulk COPY to Load Data into SnowflakeThis article summarizes the Snowflake best practices for bulk loading using the COPY INTO TABLE command. After reading this article, you'll understand precisely how the COPY command works and be able to deploy a simple but cost-efficient data-loadin...Discuss·62 readssnowflake
John RyanProarticles.analytics.today·Jul 21, 2024Mastering Snowflake SnowPro Certification: 10 Proven MethodsSnowflake Certification Guide This article outlines my top 10 tactics to prepare for the Snowflake Certification Exam. We'll review the available certification options and explain what to expect from the exam and how to prepare. Finally, I'll provid...Discuss·112 readssnowflake
John RyanProarticles.analytics.today·Jul 21, 2024Snowflake Unistore and Hybrid Tables: What You Need to KnowSnowflake’s new Unistore workload and Hybrid Tables represent a seismic shift in database technology. For the past 40 years, data has been stored in independent data silos with transactional data (also known as Online Transaction Processing systems ...Discusssnowflake
John RyanProarticles.analytics.today·Jul 21, 2024Do You Need a Snowflake Database Administrator (DBA)?In a previous article, I questioned whether the Snowflake Database Administration (DBA) role was becoming extinct, only to conclude that on Snowflake, the role was evolving to achieve more work with less effort. In this article, I’ll explain how the ...Discuss·61 readssnowflake