Experimental feature for Postgres connections
You can connect Metabase and redact sensitive content.
Requirements
- Hoop Command Line
- Local or Remote Postgres Instance
- Java & Metabase Jar
Login at Hoop
shellhoop login
Create a connection pointing to a Postgres instance
shellhoop admin create conn pg-proxy --overwrite \ --agent <agent-name> \ --type postgres \ -e HOST=127.0.0.1 \ -e PORT=5432 \ -e USER=<pguser> \ -e PASS=<pgpass>
Connect to Postgres
shellhoop connect pg-proxy --port 5433
Metabase Configuration
shellcd /path/to/metabase/jar java java -DMB_JETTY_PORT=3005 -jar metabase.jar
- Access the Metabase webapp and perform the signup
- Go to Admin Settings > Databases > Add database
- For user and password, type:
noop
- Add the JDBC option:
preferQueryMode=simple
Demo
- Go to browse data > select
pg-proxy
- Select a table that has sensitive data (e.g., email)
PII fields will show up as redacted.