docs-v2/content/influxdb/v2/admin/secrets/use.md

773 B

title description influxdb/v2/tags menu weight aliases
Use secrets Use secrets in a query with Flux.
secrets
security
influxdb_v2
parent
Manage secrets
305
/influxdb/v2/security/secrets/manage-secrets/use/
/influxdb/v2/security/secrets/use/

Use secrets in a query

Import the influxdata/influxd/secrets package and use the secrets.get() function to populate sensitive data in queries with secrets from your secret store.

import "influxdata/influxdb/secrets"
import "sql"

username = secrets.get(key: "POSTGRES_USERNAME")
password = secrets.get(key: "POSTGRES_PASSWORD")

sql.from(
    driverName: "postgres",
    dataSourceName: "postgresql://${username}:${password}@localhost",
    query:"SELECT * FROM example-table",
)