An example presto postgresql connector for Dataproc

README.md

See this stack overflow question.

presto-postgresql-connector.sh

#!/bin/bash

set -euxo pipefail

YOUR_CATALOG_NAME="YOUR_CATALOG_NAME"
YOUR_POSTGRESQL_ENDPOINT="YOUR_HOST:5432"
YOUR_POSTGRESQL_DB="YOUR_DB"
YOUR_POSTGRESQL_USER_NAME="YOUR_USER"
YOUR_POSTGRESQL_PASSWORD="YOUR_PASSWORD"

cat >"/opt/presto-server/etc/catalog/${YOUR_CATALOG_NAME}.properties" <<EOF
connector.name=postgresql
connection-url=jdbc:postgresql://${YOUR_POSTGRESQL_ENDPOINT}/${YOUR_POSTGRESQL_DB}
connection-user=${YOUR_POSTGRESQL_USER_NAME}
connection-password=${YOUR_POSTGRESQL_PASSWORD}
EOF

systemctl restart presto
systemctl status presto