Skip to main content

Amazon RDS for PostgreSQL

Ahana Cloud supports several data sources. Amazon RDS for PostgreSQL is a popular service on AWS that that makes it easier to set up, operate, and scale a PostgreSQL database in the AWS Cloud.

This page walks you through adding an Amazon RDS for PostgreSQL Database to Ahana Cloud for Presto.

Step 1: Navigate to the Add data source screen#

Start by clicking the Add a data source button on the Data sources tab.

Ahana Data Sources for Presto

Step 2: Select Amazon RDS for PostgreSQL as the Connector Type#

Configure PostgreSQL for Presto

Step 3: Configure the database general information#

  • Give your Amazon RDS for PostgreSQL database a name - This will be used to derive the catalog name used for Presto. The data sources screen will show you both the name given and the catalog name used. This is done to remove all special characters that may not be Presto-friendly.
  • Give a description about the Amazon RDS for PostgreSQL being added

Configure Amazon RDS for PostgreSQL

Step 4: Configure the database access details#

  • Provide the JDBC URL to your Database endpoint
    • e.g. jdbc:mysql://ahana-demo-db.abcdefghijkl.us-east-1.rds.amazonaws.com

Get the Database endpoint Information from the Amazon RDS Console

  • Provide the Username and Password to your Database
note

This URL needs to be accessible from the VPC where the Presto clusters are running.

Configure AWS PostgreSQL for Presto

Step 5: Add the Data source#

tip

The Catalog Name table on the Data screen gives you the internal name used for Presto.

Ahana Data Sources for Presto