RDS Connector

RDS Connector

With Athena Jdbc Connector, the following databases are supported:

  • MySQL
  • PostgreSQL
  • Redshift

For detailed information about Amazon Athena Jdbc Connector, refer here .

Athena PostgreSQL Connector can be installed as outlined below.

  1. Create data source:

    • Access the Athena Data sources.
    • Choose Create data source
    • If you need create Lambda look at 2.

    Image

    Image

  2. Create Lambda function:

    Image

    Image

    • Update permission of IAM role for Lambda

    Image

    • Update connection string

    Image

    • Create VPC endpoint( 1 gateway endpoint for S3, 1 interface endpoint for Secret Manager)

    Image

  3. Query

    • Check connection of data source

    Image

    • Query RDS in Athena

    Image