Mahira Technology Private Limitedmahiratechnology.hashnode.dev·Nov 15, 2024Snowflake Newbies: How to Easily Create a Reader Account in the Web UIOver View :- Remember your first time seeing snow? The excitement, the curiosity, and maybe a bit of confusion about how to make that perfect snowball? Well, embarking on your Snowflake journey can evoke similar emotions. The goal is to have fun and ...Reader Account
Iman Adekoimanadeko.hashnode.dev·Sep 23, 2024Analyzing Sales Data from a NYC Coffee ShopIn my last post, I expressed my interest in undertaking a data modeling and visualization project in Snowflake. In this post, I will guide you through the entire process, step by step. Before you begin, ensure that you have Snowflake and SnowSQL set ...10 likessnowflake
Iman Adekoimanadeko.hashnode.dev·Sep 15, 2024How to Install and Connect to Snowflake with SnowSQL CLIFor the past few weeks, I’ve been learning about Snowflake and how to use its version of SQL, SnowSQL, to perform data management and manipulation tasks. Now, I want to work on a project where I will: Import and normalize raw data. Develop a compre...10 likes·26 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...1 like·1.7K readssnowflake
John Ryanarticles.analytics.today·Aug 19, 2024The Surprising Benefits of Snowflake TRANSIENT and TEMPORARY TablesHaving worked with over 50 Snowflake customers across Europe and the Middle East, I repeatedly find customers make the same mistakes. In this article, I've covered the surprising benefits of Snowflake TRANSIENT tables, and you, as a Data Engineer or ...1.3K readssnowflake
John Ryanarticles.analytics.today·Jul 28, 2024Mastering Time Travel in Snowflake: Tips and TechniquesFirst Published: 29th July 2024 This article will explain what you need to know about time travel in Snowflake. In addition to explaining what it is and how it works, we'll also discuss some of the best practices. This will include: What is Snowflak...2 likes·830 readssnowflake
John Ryanarticles.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...1.3K readssnowflake
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...683 readssnowflake
John Ryanarticles.analytics.today·Jul 20, 2024How to Cut Snowflake Data Storage Costs with Zero Copy ClonesSnowflake's ability to create a Clone Table and produce a full read/write clone copy of terabytes of data within seconds is remarkable. Still, it can lead to an unexpected explosion of data storage. This article explains why creating Snowflake clone...509 readssnowflake
John Ryanarticles.analytics.today·Jul 20, 2024Securing Data with Row Level Security in SnowflakeThis article explains how Snowflake supports Row-Level Security (fine-grained access control—FGAC). It describes a simple but powerful security architecture successfully deployed by some of the largest enterprises using Snowflake globally. It also ex...380 readssnowflake
