Store and use secrets

There are two options for storing secrets with InfluxDB:

  • By default, secrets are Base64-encoded and stored in the InfluxDB embedded key value store, BoltDB.
  • You can also set up Vault to store secrets. For details, see Store secrets in Vault.

By default, all secrets added to InfluxDB Cloud are stored in the InfluxDB Cloud Vault cluster.

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.

  1. import "influxdata/influxdb/secrets"
  2. import "sql"
  3. username = secrets.get(key: "POSTGRES_USERNAME")
  4. password = secrets.get(key: "POSTGRES_PASSWORD")
  5. sql.from(
  6. driverName: "postgres",
  7. dataSourceName: "postgresql://${username}:${password}@localhost",
  8. query:"SELECT * FROM example-table"
  9. )

Add, list, and delete secrets

See Manage secrets.

secrets security