---
title: "#redshift articles | Hashnode"
description: "Explore 47 articles tagged #redshift on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/redshift"
---

Tag

# #redshift

47 posts · 9 followers

[Shubham Baldava](https://hashnode.com/@shubham-olake) · [4d ago](https://hashnode.com/posts/postgres-to-redshift-cdc-on-aws-glue-a-setup-log-with-five-fixes/6af8b4497b3654402ab665a3)

### [Postgres to Redshift CDC on AWS Glue: A Setup Log With Five Fixes](https://olake-blog.hashnode.dev/postgres-to-redshift-cdc-on-aws-glue-a-setup-log-with-five-fixes?utm_source=hashnode&utm_medium=feed)

Slot, policy, destination test, external schema and change sync in order, with the exact message where one is printed.

10 min read · [olake-blog.hashnode.dev](https://olake-blog.hashnode.dev/postgres-to-redshift-cdc-on-aws-glue-a-setup-log-with-five-fixes?utm_source=hashnode&utm_medium=feed)

[Hammad Tariq](https://hashnode.com/@hamad-tariq) · [Jun 20](https://hashnode.com/posts/data-warehouse-migration-guide-2026-snowflake-vs-redshift-vs-big-query-vs-databricks/6a36ce611b65ca376673d61b)

### [Data Warehouse Migration Guide 2026: Snowflake vs Redshift vs Big Query vs Databricks](https://thehammadtariq.hashnode.dev/data-warehouse-migration-guide-2026-snowflake-vs-redshift-vs-big-query-vs-databricks?utm_source=hashnode&utm_medium=feed)

The strategic way to choose between Snowflake, Redshift, Big Query and Databricks and what the move actually costs.

3 min read · [thehammadtariq.hashnode.dev](https://thehammadtariq.hashnode.dev/data-warehouse-migration-guide-2026-snowflake-vs-redshift-vs-big-query-vs-databricks?utm_source=hashnode&utm_medium=feed)

[Sammed Chougule](https://hashnode.com/@SammedC) · [May 30](https://hashnode.com/posts/choosing-the-right-aws-database-rds-aurora-dynamodb-and-redshift/6a1aab34811cb50b9d880dd0)

### [Choosing the Right AWS Database: RDS, Aurora, DynamoDB, and Redshift](https://aws-saa-journey.hashnode.dev/choosing-the-right-aws-database-rds-aurora-dynamodb-and-redshift?utm_source=hashnode&utm_medium=feed)

SAA-C03 Series — Week 6

17 min read · [aws-saa-journey.hashnode.dev](https://aws-saa-journey.hashnode.dev/choosing-the-right-aws-database-rds-aurora-dynamodb-and-redshift?utm_source=hashnode&utm_medium=feed)

[Pratiksha kadam](https://hashnode.com/@pinacolada) · [Feb 18](https://hashnode.com/posts/data-pipeline-with-s3-emr-and-redshift/69954e840618bee10e4d7280)

### [Data Pipeline with S3, EMR, and Redshift](https://cloudops-solutions.hashnode.dev/data-pipeline-with-s3-emr-and-redshift?utm_source=hashnode&utm_medium=feed)

Thhe Architecture That Scales Intelligently

4 min read · [cloudops-solutions.hashnode.dev](https://cloudops-solutions.hashnode.dev/data-pipeline-with-s3-emr-and-redshift?utm_source=hashnode&utm_medium=feed)

[Tech Insights Hub](https://hashnode.com/@JohnMikes) · [Feb 12](https://hashnode.com/posts/redshift-aws-petabyte-scale-data-warehouse/698dd451d25b7b245f797534)

### [Redshift AWS: Petabyte-Scale Data Warehouse](https://topperblog.hashnode.dev/redshift-aws-petabyte-scale-data-warehouse?utm_source=hashnode&utm_medium=feed)

Redshift AWS: Petabyte-Scale Data Warehouse Modern tool for developers. Overview Key features. Setup const use = () => true; Patterns Best practices. FAQ Q: Ready? Yes. Conclusion Start today.

1 min read · [topperblog.hashnode.dev](https://topperblog.hashnode.dev/redshift-aws-petabyte-scale-data-warehouse?utm_source=hashnode&utm_medium=feed)

[Ghanshyam Digital](https://hashnode.com/@ghanshyamdigital) · [Nov 13, 2025](https://hashnode.com/posts/how-i-saved-800-daily-using-duckdb-and-apache-superset-instead-of-aws-redshift-for-analytics/6915d9ff6ec8f369a1c03491)

### [How I Saved $800+ Daily Using DuckDB & Apache Superset Instead of AWS Redshift for Analytics](https://blog.ghanshyamdigital.com/how-i-saved-800-daily-using-duckdb-and-apache-superset-instead-of-aws-redshift-for-analytics?utm_source=hashnode&utm_medium=feed)

Learn how we replaced AWS Redshift with DuckDB and Apache Superset for loan analytics, cutting costs from $800/day to pennies.

5 min read · [blog.ghanshyamdigital.com](https://blog.ghanshyamdigital.com/how-i-saved-800-daily-using-duckdb-and-apache-superset-instead-of-aws-redshift-for-analytics?utm_source=hashnode&utm_medium=feed)

[Aaron Rose](https://hashnode.com/@aaronrose) · [Aug 15, 2025](https://hashnode.com/posts/how-to-get-total-data-scanned-for-a-redshift-query-via-the-data-api/689f008d870031202771f231)

### [How to Get "Total Data Scanned" for a Redshift Query via the Data API](https://aaron-rose.hashnode.dev/how-to-get-total-data-scanned-for-a-redshift-query-via-the-data-api?utm_source=hashnode&utm_medium=feed)

Problem You can see "data scanned" metrics for queries in the Redshift console, but you need to access these numbers programmatically from Lambda functions, ETL jobs, or CI/CD pipelines that use the Redshift Data API. Without programmatic access to s...

5 min read · [aaron-rose.hashnode.dev](https://aaron-rose.hashnode.dev/how-to-get-total-data-scanned-for-a-redshift-query-via-the-data-api?utm_source=hashnode&utm_medium=feed)

[1](https://hashnode.com/posts/how-to-get-total-data-scanned-for-a-redshift-query-via-the-data-api/689f008d870031202771f231)

[Aaron Rose](https://hashnode.com/@aaronrose) · [Aug 15, 2025](https://hashnode.com/posts/how-to-always-write-optimized-queries-in-amazon-redshift-complete-guide/689efd2452c48045e33ff711)

### [How to Always Write Optimized Queries in Amazon Redshift - Complete Guide](https://aaron-rose.hashnode.dev/how-to-always-write-optimized-queries-in-amazon-redshift-complete-guide?utm_source=hashnode&utm_medium=feed)

Problem Developers frequently ask "How do I write optimized Redshift queries from the start?" after experiencing slow performance, unexpectedly high costs, and frustrated business users waiting for critical reports. Clarifying the Issue This isn't ab...

8 min read · [aaron-rose.hashnode.dev](https://aaron-rose.hashnode.dev/how-to-always-write-optimized-queries-in-amazon-redshift-complete-guide?utm_source=hashnode&utm_medium=feed)

[Aaron Rose](https://hashnode.com/@aaronrose) · [Aug 3, 2025](https://hashnode.com/posts/building-a-data-mart-in-amazon-redshift-a-practical-guide/688ed72cef063d84afd33f43)

### [Building a Data Mart in Amazon Redshift: A Practical Guide](https://aaron-rose.hashnode.dev/building-a-data-mart-in-amazon-redshift-a-practical-guide?utm_source=hashnode&utm_medium=feed)

Problem Teams using Amazon Redshift often struggle with a paradox: they know Redshift excels at analytical workloads and can support focused data marts, but when it's time to build one, they face decision paralysis. Should they create a full enterpri...

7 min read · [aaron-rose.hashnode.dev](https://aaron-rose.hashnode.dev/building-a-data-mart-in-amazon-redshift-a-practical-guide?utm_source=hashnode&utm_medium=feed)

[Pablo Takara](https://hashnode.com/@ptakara) · [Jul 29, 2025](https://hashnode.com/posts/incremental-extraction-improves-metadata-ingestion-in-collate/68892fc5384803eab6712cf2)

### [Incremental Extraction Improves Metadata Ingestion in Collate](https://blog.getcollate.io/incremental-extraction-improves-metadata-ingestion-in-collate?utm_source=hashnode&utm_medium=feed)

New feature uses smart change detection to trim ingestion time , cut costs, and scale more efficiently

5 min read · [blog.getcollate.io](https://blog.getcollate.io/incremental-extraction-improves-metadata-ingestion-in-collate?utm_source=hashnode&utm_medium=feed)
