Query Amazon RDS

To query a relational database hosted on Amazon Relational Database Service (RDS) with Flux:

1. Import the sql package

2. Use the sql.from() function and provide the following parameters:

   • driverName: Determined by your Amazon RDS database engine
   • dataSourceName: Determined by your Amazon RDS database engine
   • query: SQL query to execute

Query Amazon RDS PostgreSQL database

import "sql"

sql.from(
    driverName: "postgres",
    dataSourceName: "postgresql://my-instance.123456789012.us-east-1.rds.amazonaws.com:5432",
    query: "SELECT * FROM example_table",
)

Supported database engines

Use the following guides to query supported Amazon RDS database engines:

• Query MariaDB
• Query MySQL
• Query PostgreSQL
• Query SQL Server

Amazon RDS connection credentials

Amazon RDS provides connection credentials required to connect to your database instance. The following links provide more information for each database engine:

• Connect to MariaDB
• Connect to MySQL
• Connect to PostgreSQL
• Connect to SQL Server