amazon redshift

S3 Table Buckets vs Redshift

AWS released S3 Table Buckets at re:Invent 2024, and at release they were pretty much only usable with Elastic Map Reduce. However, over the past year, the S3 Tables team has been making improvements. And while there are still some limitations, S3 Tables with Athena gives a user experience similar to traditional data warehouses such as Redshift.

Which leads to the question: can Athena and S3 Tables be a cost-effective replacement for Redshift? In this post I show how to use S3 Tables, and run some performance comparisons to answer that question.

TechChat Tuesdays #65: Redshift Execution Plans with Keith Gregory

Podcast: Play in new window | Download (Duration: 59:00 — 54.0MB) | Embed

In this week’s TechChat, we welcome Keith Gregory, our Cloud & Data Engineering Practice Lead here at Chariot. Keith is a prolific writer both on the Chariot blog as well as on his own, and is a wealth of knowledge on all things AWS. We touch on Redshift execution plans, how to appropriately size Redshift … Read More

TechChat Tuesdays #57: AWS Re:Invent Announcements with Keith Gregory, AWS Practice Lead

Podcast: Play in new window | Download (49.1MB) | Embed

Today we welcome Keith Gregory to the show! Keith is our AWS Practice Lead here at Chariot. We cover some announcements from AWS re:Invent, and do a deep dive into CodeCatalyst, OpenSearch Serverless, Lambda Snapstart, Redshift streaming ingestion from Kafka/Kinesis, and EventBridge Pipes.

First Look at Amazon Redshift Serverless

Amazon Redshift’s launch in 2012 was one of the “wow!” moments in my experience with AWS. Here was a massively parallel database system that could be rented for 25 cents per node-hour. Here we are in 2021, and AWS has just announced Redshift Serverless, in which you pay for the compute and storage that you use, rather than a fixed monthly cost for a fixed number of nodes with a fixed amount of storage. And for a lot of use cases, I think that’s a great idea. So I spent some time kicking the tires, and this is what I learned.

Data I/O 2013 – Amazon Redshift – Game Changer? – Eric Snyder

ARVE Error:
ARVE Error: loop not valid
loop not valid
autoplay not valid

Podcast: Play in new window | Download (Duration: 53:02 — 142.2MB) | Embed

Is Amazon’s new managed, lower cost, petabyte scale warehousing solution a game changer? We’ll review the costs and discuss what does (or does not) make Amazon Redshift reliable, scalable and effective. We’ll dive into the technical details behind the query and storage engines and we’ll expose what works well and what does not. This talk should benefit both those that are and are not already part of the Amazon Web Services ecosystem.