CODEWITHSUNDEEP
amazon-web-servicesamazon-s3aws-glueamazon-athena
rey don sancho
rey don sancho

Reputation: 493

Can I use Athena to make queries in an RDS database?

Is it possible to query things in an RDS database using Athena? Or do I somehow have to get my data out of RDS and copy it into an s3 bucket so that Athena can query it from there? If that is the case how can I know the tables that are in my RDS? Is there a way to explore all the schemas of a database with Glue?

Upvotes: 6

Views: 14051

Answers (1)

Chris Williams
Chris Williams

Reputation: 35188

A feature was created exactly for this reason last year, Federated Queries.

By using this you can query across a large number of data sources other than just across S3.

If you're using either MySQL or Postgres in RDS then you can make use of the JDBC connector, with additional instructions here.

Upvotes: 10

Related Questions