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.
Start by clicking the Add a data source button on the Data sources tab.
- 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
- Provide the JDBC URL to your Database endpoint
- Provide the Username and Password to your Database
This URL needs to be accessible from the VPC where the Presto clusters are running.
The Catalog Name table on the Data screen gives you the internal name used for Presto.