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
Amazon Athena: Querying S3 with SQL
An explanation of Amazon Athena for people new to it: what the service is, how a table is only metadata pointing at files in S3, what happens when a query runs, where results go, how billing by bytes scanned works, how workgroups cap spending, and where Athena fits beside Redshift and EMR.
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.