AWS Tutorials - 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.

[sabelomuzimsimango]

you are the best Dojo. All thanks from South Africa

[yustiono]

This is very clear and helpful. Good work and tthank you for sharing!

[tarvinder]

very helpful to understand the connections. I wanted to know how to setup them and how that data catalog is created. Got all of it. Thanks!

[varmasagi]

Wow, that's a really nice tutorial. It helped me to exactly what I am looking for. Thank you very much.

[tarap]

Your videos are great and very practical

[sivasai]

Why should we use Athena to connect to Redshift instead of using Redshift query editor? What are the use cases ? Because connecting to Athena would cost more right? Please clarify??

[sajalgour]

This was really helpful, thank you. Can you please do a video on Cost for a federated query ? I am trying to understand if it cost effective to actually copy data across if we have multiple users quering this external data source using federated query?

[nkgamerz]

How do we enable sso users with athena fedrated query ?
Also lambda max timeout limit is 15 mins, if the query is taking longer than 15 mins, should we use athena fedrated querh in those cases?

[hsz]

Thank you so much for the tutorial. It is great. I have a question about where the actual heavy lifting (in terms of the compute) takes place. In the demo, the query in Athena is passed onto the Redshift cluster, therefore the actual query compute will be on Redshift rather than Athena or the Lambda connector. Is my understanding correct?

[puneetm]

how does the federated queries cost us ? does all the services(lambda, athena, redshift) will cost you

[picklu]

I am still getting "Failed to invoke lambda function due to 0: java.sql.SQLException: No suitable driver found for ".