#redshift

A practical analysis of Amazon Redshift support for Apache Iceberg v3 tables, focused on CDC, deletes, governance, and cost.

Technical analysis of Redshift support for IAM Identity Center with enhanced VPC routing, PrivateLink, governance, and real failures.

Most people think SQL is fast because "the database is optimized." That's true, but it's such a...

A subquery that looked perfectly fine on its own was quietly running dozens of times a day across our...

On Snowflake or modern Postgres, CTE vs subquery barely matters for performance. On Redshift, it can...

Solving the S3 Small-File Problem with Apache Iceberg, Compaction, and Amazon Redshift...

If you're building a SaaS product or internal tool that needs to take your users' Excel data and push...

Every few months someone shows me a cloud bill that tripled and asks whether they should switch...

TL;DR In Part 1, Athena provided serverless SQL. In Part 2, Databricks hit boundaries. In...

Introduction to the topic Amazon Redshift is a popular cloud-based data warehouse that...

Organizations build data warehouses as cathedrals. These structures house curated data to power...

An analysis of parallel deployment strategies for large-scale Redshift DDL operations using Azure DevOps