Analyze AWS S3 and Redshift via Amazon Redshift Spectrum | Join Redshift and S3 data with Spectrum
In this video we cover AWS Redshift Spectrum. Redshift Spectrum is a part of Amazon Redshift Web Services that offers a common platform to extract and analyze data from databases such as Redshift and as well S3 data lake. We can query data from both services without having to move data between them.
Redshift spectrum helps to economize the storage cost by moving the infrequently accessed data to S3.
AWS Redshift Spectrum: https://docs.aws.amazon.com/redshift/...
Link to article on this topic: https://blog.devgenius.io/aws-redshif...
Link to GitHub repo: https://github.com/hnawaz007/pythonda...
Subscribe to our channel:
/ haqnawaz
---------------------------------------------
Follow me on social media!
GitHub: https://github.com/hnawaz007
Instagram: / bi_insights_inc
LinkedIn: / haq-nawaz
---------------------------------------------
#AWS #awsredshift #redshiftspectrum
Topics covered in this video:
0:00 - Introduction AWS Redshift Spectrum
1:19 - External Tables Overview
1:44 - Create External Schema
2:28 - Create External Table
3:17 - Query External Table
3:32 - Join External Table with Redshift Table
3:48 - View External Table Properties
4:00 - Common Use Case for Redshift Spectrum