Influxdata
/
docs-v2
mirror of https://github.com/influxdata/docs-v2.git
1
0
Fork 0
Code Issues Projects Releases Wiki Activity
docs-v2/content/flux/v0/query-data/sql/amazon-rds.md

2.2 KiB
Raw Permalink Blame History

title list_title description menu weight related list_code_example
Query Amazon RDS Amazon RDS Use [`sql.from()`](/flux/v0/stdlib/sql/from/) to query a relational database hosted on Amazon RDS.
flux_v0
name parent
Amazon RDS SQL databases
101
/flux/v0/stdlib/sql/from/
```js import "sql" sql.from( driverName: "postgres", dataSourceName: "postgresql://my-instance.123456789012.us-east-1.rds.amazonaws.com:5432", query: "SELECT * FROM example_table", ) ```

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:

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:

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: