Sonalika Patelsonablogs.hashnode.dev·Sep 12, 2024Migrating from Amazon Redshift to Snowflake: A Comprehensive GuideMigrating from Amazon Redshift to Snowflake: A Comprehensive Guide As organizations continue to scale and deal with increasing amounts of data, the need for more powerful, flexible, and cost-efficient data warehousing solutions becomes critical. Two ...Discuss#redshift to snowflake
Sion Kimsionkim.hashnode.dev·Sep 12, 2024Snowflake Architecture at High LevelSnowflake Managed OLAP DBMS written in C++ from scratch Shared disk architecture with compute side local caching (save money to retrieve objects from S3) Three Distinct Layers Database storage Snowflake has cloud hosted object store on AWS S3, Azu...Discusssnowflake
Nathan Rawlingblog.sorrowmonkey.com·Sep 9, 2024Snowflake: AWS Secret Manager Password RotationYou can use AWS Secrets Manager to automatically rotate of passwords using a custom lambda function. AWS provides lambda function templates for many AWS services (RDS, DocumentDB, etc.) and a template you can use to develop your own functions. Secret...Discusssnowflake
John RyanProarticles.analytics.today·Sep 9, 2024Snowflake Data Lake: A Comprehensive IntroductionThis is the first in a series of articles about Snowflake Data Lake Architecture. In this article, I'll describe some background including: What is a Data Lake and why the architecture was developed. How Snowflake supports Data Lake (or raw history...Discuss·607 readssnowflake
Nathan Rawlingblog.sorrowmonkey.com·Sep 7, 2024Snowflake: Network PoliciesA slightly more in-depth and guided approach to setting up Snowflake network rules and network policies... Basically, the stuff I wish I'd known when I started trying to secure my Snowflake account. Avoid Footguns: a Backdoor User Snowflake lets you ...Discusssnowflake
John RyanforAltimate Team Blogblog.altimate.ai·Sep 7, 2024How Much Do Dynamic Tables Cost? The answer will surprise you!In my previous article on Dynamic Tables, I explained their purpose, to help simplify building transformation pipelines for either batch or real time data feeds in Snowflake. In this article, I'll explain what they cost. Bored already? Read on to see...Discuss·173 readsSnowflake Costs
Nathan Rawlingblog.sorrowmonkey.com·Sep 3, 2024Snowflake: Security HardeningIn the wake of the 2024 data breaches related to the Snowflake platform (TicketMaster) (Santander) (165 Affected Customers), I thought it would make sense to talk a little bit about Snowflake Security best practices. Snowflake recommends all of these...Discusssnowflake
Mahira Technology Private LimitedPromahiratechnology.hashnode.dev·Sep 3, 2024Snowflake Secrets: Mastering Role Creation and User Grants via TerraformOverview :- Snowflake, a cloud-based data warehousing platform, has become increasingly popular for its scalability and flexibility. One of the key aspects of managing a Snowflake environment is setting up proper access controls through roles and use...Discusssnowflake
John RyanforAltimate Team Blogblog.altimate.ai·Sep 2, 2024Integrating Snowflake with a Data Lake - What you Need to KnowThis is the first in a series of articles about Snowflake Data Lake Architecture. In this article, I'll describe some background including: What is a Data Lake and why the architecture was invented. How Snowflake supports Data Lake (or raw history)...Discusssnowflake
John RyanProarticles.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·721 readssnowflake
