Latest updates for Amazon Redshift

Fresh curated links around Amazon Redshift are collected here so marketers can spot useful updates and turn timely ideas into posts faster.

Recent items include:

  • Materialize once, query anywhere: Introducing Iceberg materialized views in Amazon Redshift
  • AWS Aurora PostgreSQL adds direct queries for Iceberg and Parquet data lakes
  • dbt and Amazon Redshift Data Sharing: Multi-cluster pipelines without moving a byte

Post angles to try

Share the most useful takeaway for your audience.
Turn one article into a quick practical checklist.
Ask your audience how this shift affects their work.
Turn angles into scheduled posts

Fresh articles and ideas

Recent curated links from global sources. Generate one free draft from any story, then use SocialBu to schedule and refine your content calendar.

aws.amazon.com /2 weeks ago

Materialize once, query anywhere: Introducing Iceberg materialized views in Amazon Redshift

Amazon Redshift now supports Iceberg materialized views. Compute an aggregation once in Amazon Redshift and store the result as a standard Apache Iceberg table in Amazon S3, querya...

Read source
sourcetrail.com /3 weeks ago

AWS Aurora PostgreSQL adds direct queries for Iceberg and Parquet data lakes

AWS Aurora PostgreSQL now queries Iceberg and Parquet data in S3 without ETL, using DuckDB and familiar SQL. See versions, setup, limits, and costs. The post AWS Aurora PostgreSQL...

Read source
aws.amazon.com /1 week ago

dbt and Amazon Redshift Data Sharing: Multi-cluster pipelines without moving a byte

Learn how to set up Amazon Redshift Data Sharing between a producer and consumer cluster and use dbt Cloud to transform the shared data into analytics-ready models, with live, zero...

Read source
aws.amazon.com /1 month ago

Query Amazon S3 Tables from Amazon EMR Trino using the Iceberg REST endpoint

Learn how to query Amazon S3 Tables from Trino on Amazon EMR using the Apache Iceberg REST catalog endpoint. This post shows how to deploy the integration with AWS CloudFormation,...

Read source
aws.amazon.com /1 month ago

Every team is a data team — bring Amazon Redshift analytics to ChatGPT Work

AWS is announcing the AWS Data Analytics plugin for the new Data agent in ChatGPT Work. Teams can ask questions in natural language, analyze governed data across their Amazon Redsh...

Read source
aws.amazon.com /1 month ago

Razor Group’s journey to a modern data lakehouse on AWS

Razor Group, one of Europe's leading ecommerce aggregators managing 250+ brands, migrated from always-on Amazon Redshift clusters to an open lakehouse on Apache Iceberg, Amazon S3...

Read source
aws.amazon.com /1 month ago

Run DuckDB analytics on your Amazon DynamoDB data with zero-ETL

Run ad hoc SQL analytics on your Amazon DynamoDB data with DuckDB. A zero-ETL integration replicates your table into Apache Iceberg tables on Amazon S3 Tables, and an AWS Lambda fu...

Read source
aws.amazon.com /2 weeks ago

Cost-effective ETL with DuckDB and Amazon S3 Tables on AWS Glue

Learn how to pair DuckDB with AWS Glue 6.0 to run SQL-centric ETL on a single worker, reading Parquet from Amazon S3 and writing Apache Iceberg tables to Amazon S3 Tables. This pos...

Read source
aws.amazon.com /1 month ago

How United Airlines uses Amazon Redshift and AWS Glue Data Catalog federation to query Databricks-managed data

Learn how United Airlines uses AWS Glue Data Catalog federation to query Databricks Unity Catalog data directly from Amazon Redshift Serverless without duplicating data, using reso...

Read source
aws.amazon.com /2 weeks ago

Query across accounts and table formats with multi-catalog in Amazon EMR

Amazon EMR 8.1.0 adds multi-catalog support through the RedirectingSessionCatalog, so you can query Iceberg, Delta Lake, Hudi, and Hive tables through a single catalog and join dat...

Read source
aws.amazon.com /3 weeks ago

Aurora PostgreSQL zero-ETL integration with Amazon SageMaker

Amazon Aurora PostgreSQL zero-ETL integration with Amazon SageMaker replicates your operational data to a lakehouse in near real time, without building custom ETL pipelines. Learn...

Read source
aws.amazon.com /2 weeks ago

Run an automated operational review with the Amazon Redshift MCP server

Amazon Redshift automates much of its own tuning, but periodic operational reviews still pay off. Learn how the review_cluster tool in the open-source Amazon Redshift MCP server ru...

Read source
aws.amazon.com /3 weeks ago

Getting started with Apache Iceberg write support in Amazon Redshift – Part 3

Amazon Redshift now supports evolving Apache Iceberg table schemas and partition layouts through ALTER statements, with no data rewrites or pipeline rebuilds. In this final post of...

Read source
aws.amazon.com /1 month ago

CORTO’s billion-scale legal semantic search with Aurora PostgreSQL pgvector

How CORTO scaled Amazon Aurora PostgreSQL with pgvector to 7.6 billion vectors and 2.5 billion documents in production, delivering sub-second legal search for 10,000+ law firms at...

Read source
sqlservercentral.com /1 month ago

Keeping Redshift System Table History Past 7 Days with S3 Tables

Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine until an auditor or an incident review asks for something older. Until now the usual... The post...

Read source
aws.amazon.com /1 month ago

Monitor self-managed databases with Amazon CloudWatch Database Insights

Amazon CloudWatch Database Insights now extends to self-managed databases. Monitor self-managed PostgreSQL on Amazon EC2 alongside your Amazon Aurora and Amazon RDS fleet from a si...

Read source
aws.amazon.com /1 week ago

Monitor Amazon Aurora DSQL costs with the Aurora DSQL console and CloudWatch alarms

As your Amazon Aurora DSQL workload scales, DPU consumption and storage costs can grow without a fixed instance ceiling. This post shows how to monitor Aurora DSQL usage and cost w...

Read source
aws.amazon.com /1 month ago

Integrate Amazon Redshift and IAM Identity Center with enhanced VPC routing

Amazon Redshift now supports AWS IAM Identity Center authentication on clusters and workgroups that use enhanced VPC routing. Create two interface VPC endpoints to give your users...

Read source
aws.amazon.com /1 month ago

How Moovit achieved 33% cost optimization through architectural modernization

Learn how Moovit modernized its data platform with a multi-engine lakehouse architecture: offloading heavy aggregation workloads from Amazon Redshift to Amazon EMR with Spark SQL,...

Read source
aws.amazon.com /1 week ago

Reducing storage initialization impact in Amazon RDS for PostgreSQL after snapshot restore

When you restore an Amazon RDS for PostgreSQL instance from a snapshot, the Amazon EBS volume hydrates lazily, so early queries can run 10x to 15x slower. This post walks through P...

Read source
aws.amazon.com /1 month ago

Selecting a vector store for Amazon Bedrock Knowledge Bases

Choosing the right vector store for your Amazon Bedrock Knowledge Bases RAG application affects performance and cost. This post compares Amazon OpenSearch Service, Amazon Aurora Po...

Read source
aws.amazon.com /1 month ago

Deliver real-time data to streaming tables for Apache Iceberg with Amazon Kinesis Data Streams

Amazon Kinesis Data Streams now supports streaming tables, a fully managed capability that continuously delivers your streaming data as queryable Apache Iceberg tables on Amazon S3...

Read source
aws.amazon.com /1 month ago

AWS and DuckLabs: Building the future of analytics together

Today we are announcing that Amazon has signed a definitive agreement to acquire DuckLabs, the Amsterdam-based company behind the open-source analytical database DuckDB. We expect...

Read source
aws.amazon.com /3 weeks ago

Migrate Db2 z/OS to Amazon Aurora PostgreSQL using AWS DMS and gateway server

Learn how to use AWS DMS and a Db2 gateway server on Amazon EC2 to migrate and replicate data from an on-premises IBM Db2 database on z/OS to Amazon Aurora PostgreSQL. This post co...

Read source

Turn fresh research into a full content calendar

Use SocialBu to discover ideas, generate post drafts, and schedule them across your social channels.

Sources covering Amazon Redshift

aws.amazon.com

Recent coverage from public sources
Public source

aws.amazon.com

Recent coverage from public sources
Public source

aws.amazon.com

Recent coverage from public sources
Public source

sourcetrail.com

Recent coverage from public sources
Public source

sqlservercentral.com

Recent coverage from public sources
Public source