One day with Redshift

on YouTube ↗23m

" summary

Amazon Redshift setup, tuning and a real product demo: data lands on S3 (Athena for ad hoc CSV queries), Kafka handles streams, Power BI visualizes a “smart bookie” that flags losing markets, and Redshift’s compression and advisor trim storage. Claims shown: quick cluster launch (minutes), 1.5 billion rows loaded in 10 minutes on a large cluster, a three-node dc1.large demo inserts 1.1 billion rows in 51 minutes and stores a 1 billion-row table in 43 GB. Backups run three times daily and the advisor recommends compression.

AI-written summary · about

" chapters (9)

1. 0:00Intro
2. 0:32Redshift Cluster
3. 1:35Why cloud
4. 3:44Redshift
5. 4:42Columnar vs transactional
6. 5:48Parallel process
7. 6:25Architecture
8. 7:52Smart Bookie
9. 13:08AWS Console

" related talks

• 01h 02mData warehousing reinvented for today’s needsManan Goel, Ravi Pillala · AWS Summit San Francisco 2022
• 42mHow innovation happens on Amazon RedshiftEric Ferreira · Percona Live Open Source Database Conference 2017
• 26mAmazon Redshift ReinventedIppokratis Pandis · Systems @Scale Fall 2021
• 48mData warehousing reinvented for today’s needsDavid Zhang, Ahmed Shehata · AWS Summit Ottawa 2022
• 28mModernize Your Data WarehouseAneesh Chandra PN · AWS Summit Online EMEA 2020
• 41mOwning Your Own (Data) Lake HouseAntje Barth · Data Con LA 2020
• 42mTransform your data approach: Develop a modern data strategyBlair Layton, Saeed Barghi · AWS Summit Singapore 2022
• 43mData warehousing reinvented for today's needsKonstantina Mavrodimitraki, Konstantinos Papageorgiou · Voxxed Days Ioannina 2024