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

829 B

title description influxdb/cloud/tags menu weight aliases
Use secrets Use secrets in queries with Flux.
secrets
security
influxdb_cloud
parent
Manage secrets
305
/influxdb/cloud/security/secrets/manage-secrets/use/
/influxdb/cloud/security/secrets/use/

Use secrets in a Flux query to pass sensitive data like credentials.

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",
)