/

Metabase

🧪

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

shell
hoop login

Create a connection pointing to a Postgres instance

shell
hoop 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

shell
hoop connect pg-proxy --port 5433

Metabase Configuration

shell
cd /path/to/metabase/jar
java java -DMB_JETTY_PORT=3005 -jar metabase.jar

Access the Metabase webapp and perform the signup

http://127.0.0.1:3005

Go to Admin Settings > Databases > Add database

For user and password, type: noop

Add the JDBC option: preferQueryMode=simple

Image without caption

Demo

Go to browse data > select pg-proxy

http://127.0.0.1:3005/browse

Select a table that has sensitive data (e.g., email)

PII fields will show up as redacted.

Image without caption

Powered by Notaku

Helpful?

Content

Create a connection pointing to a Postgres instance

Connect to Postgres

Metabase Configuration