Method to pass credentials in catalogs

[hongbo-miao]

Currently https://github.com/trinodb/charts/tree/c1bacab5b15a8ece6186a40ddd676f725b20a93b/charts/trino

does not document how to pass credentials such as

catalogs:
  my_db: |
    connector.name=postgresql
    connection-url=jdbc:postgresql://production-hm-postgres.xxxxxxxxxxxx.us-west-2.rds.amazonaws.com:5432/iot_db
    connection-user=xxx
    connection-password=xxx

It would be great to clarify how to pass credentials, thanks! ☺️

[nineinchnick]

Would you like to give it a shot and open a PR? We should add a comment with an example and reference https://trino.io/docs/current/security/secrets.html

[hongbo-miao]

Thanks for the link, @nineinchnick !

Assume I have HM_POSTGRES_USER and HM_POSTGRES_PASSWORD in a Kubernetes secret called hm-trino-secret.

I succeed by

envFrom:
  - secretRef:
      name: hm-trino-secret
catalogs:
  postgresql: |
    connector.name=postgresql
    connection-url=jdbc:postgresql://production-hm-postgres.xxxxxxxxxxxx.us-west-2.rds.amazonaws.com:5432/iot_db
    connection-user=${ENV:HM_POSTGRES_USER}
    connection-password=${ENV:HM_POSTGRES_PASSWORD}

I posted full deployment code at https://github.com/hongbo-miao/hongbomiao.com/pull/24997/files

Hope it can people save some time in future! ☺️