Amazon Athena Federated Query with Redshift
Amazon Athena is a serverless and interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Amazon Athena Federated Query can be used to run SQL queries across data stored in relational, non-relational, object, and custom data sources. Athena uses data source connectors that run on AWS Lambda to execute federated queries. The data source connectors help connect with data sources like CloudWatch, DocumentDB, DynamoDB, HBase, JDBC data sources (like Redshift, MySql, SQL Server) etc.
The video explains configuration of Redshift as a data source for Amazon Athena.
Watch Video at Youtube