Write to Amazon RDS

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

1. Import the sql package

2. Pipe-forward data into sql.to() and provide the following parameters:

   • driverName: Determined by your Amazon RDS database engine
   • dataSourceName: Determined by your Amazon RDS database engine
   • table: Table to write to
   • batchSize: Number of parameters or columns that can be queued within each call to Exec (default is 10000)

Write to an Amazon RDS PostgreSQL database

import "sql"

data
    |> sql.to(
        driverName: "postgres",
        dataSourceName: "postgresql://my-instance.123456789012.us-east-1.rds.amazonaws.com:5432",
        table: "example_table",
    )

Supported database engines

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

• Write to MariaDB
• Write to MySQL
• Write to PostgreSQL
• Write to 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