IT Career Guides & Free Resources
Expert roadmaps, tutorials, salary guides and interview prep across Data Science, Generative AI, Python, Cloud & Analytics — written by GloryTecks trainers in Hyderabad.
All articles
Redshift Spectrum: Querying S3 from Redshift
Redshift Spectrum lets Amazon Redshift query files in S3 through external tables and join them with tables stored in the warehouse. This guide covers external schemas and the shared catalog, which operations are pushed down, partitions and file formats, cost, and a hot and cold data pattern.
Data Modeling in Redshift: A Practical Guide
How to model data in Amazon Redshift: a star schema written as Redshift DDL, why primary and foreign keys are declared but not enforced, how to choose column types, where distribution and sort keys fit, what to do with semi-structured data, and when a materialized view or a wide table is the better answer.
Streaming Data with Kinesis to S3 and Redshift
A practical guide to landing streaming data on AWS: Kinesis Data Streams into S3 with Firehose, how size-or-time buffering decides file counts, shown on a real day of 77,033 events, converting to Parquet and partitioning on the way, the two routes into Redshift, duplicates, and the compaction most streams still need.
Redshift Interview Questions and Answers
Redshift interviews keep returning to two design choices: how rows are distributed across slices, and how they are sorted. Both are modelled here on three million real taxi trips, showing a distribution key that leaves five of eight slices idle, a join that moves 87.5% of rows, and a sort key that skips most blocks.