Suvendu MohantyEssential Amazon Redshift Maintenance Queries for Performance OptimizationManaging and optimizing Amazon Redshift clusters is crucial for maintaining performance, minimizing costs, and ensuring that queries run…Dec 6
InThe CraftbyRafay AleemThe great migration from Redshift to SnowflakeFaire was founded in 2017 and has since then, grown rapidly from a handful of people to over 1000+ team members, supporting over 600K…Feb 28, 20238
InAWS in Plain EnglishbyJosé David ArévaloFrom Redshift to Athena: A Data Engineering Team’s Journey to 90% Cost Reduction and Performance…As a data engineer, I’ve worked on numerous projects where balancing performance with cost has been a critical challenge. Today, I’m…Sep 245Sep 245
Lexi BaseA Practical Example of Using SQL in Redshift to Replace Null Groups with Lag and LeadThis technique can be used to replace nulls within groups, transforming a table full of nulls, to one where all the nulls have been…Dec 4Dec 4
InData Engineer ThingsbyLorena GongangHow I Built an Effective Data Warehouse for SMEsA Step-by-Step GuideNov 51Nov 51
Suvendu MohantyEssential Amazon Redshift Maintenance Queries for Performance OptimizationManaging and optimizing Amazon Redshift clusters is crucial for maintaining performance, minimizing costs, and ensuring that queries run…Dec 6
InThe CraftbyRafay AleemThe great migration from Redshift to SnowflakeFaire was founded in 2017 and has since then, grown rapidly from a handful of people to over 1000+ team members, supporting over 600K…Feb 28, 20238
InAWS in Plain EnglishbyJosé David ArévaloFrom Redshift to Athena: A Data Engineering Team’s Journey to 90% Cost Reduction and Performance…As a data engineer, I’ve worked on numerous projects where balancing performance with cost has been a critical challenge. Today, I’m…Sep 245
Lexi BaseA Practical Example of Using SQL in Redshift to Replace Null Groups with Lag and LeadThis technique can be used to replace nulls within groups, transforming a table full of nulls, to one where all the nulls have been…Dec 4
InData Engineer ThingsbyLorena GongangHow I Built an Effective Data Warehouse for SMEsA Step-by-Step GuideNov 51
Lexi BaseA Practical Example of Using SQL and Recursive in RedshiftI find that Recursive SQL queries are powerful, but an often overlooked tool. This technique is a SQL query that calls itself over and over…Dec 3
InAWS in Plain EnglishbyShanojSystem Design: Automating Banking Reconciliation with AWSThis article outlines the system design for automating the banking reconciliation process by migrating existing manual tasks to AWS. The…Sep 31
Prof. Frenzel#KB Amazon Redshift — Analytics at ScaleExplore Amazon Redshift’s ability to handle massive datasets using parallel processing, columnar storage, and flexible distribution styles.Nov 30
