Skip to main content

Metabase

You could connect Metabase and redact sensitive content.

This is only supported for postgres type connections and it's available in version 1.14.3+

Requirements

Hoop Command Line
Local or Remote Postgres Instance
Java & Metabase Jar

Setup

Login at Hoop

hoop login

Create a local connection pointing to your Postgres local instance

hoop admin create conn pg --overwrite \
  --agent <agent-name> \
  --type postgres \
  -e HOST=127.0.0.1 \
  -e PORT=5432 \
  -e USER=<pguser> \
  -e PASS=<pgpass>

info

If you already have a connection with postgres, skip this phase.

Connect to Postgres

hoop connect pg --port 5433

Metabase Configuration

Run metabase

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

Demo

Go to browse data > select pg-proxy

http://127.0.0.1:3005/browse

Select a table that have sensitive data (e.g.: e-mail)

The fields are going to show up redacted

Requirements