[Task]: Delivery Dashboard - Metabase - Connect to Postgres ELT data

[coilysiren]

Summary

Assuming that our delivery dashboard ELT data has already been loaded into Postgres. We will now what to load that data so it is viewable inside of Metabase. This task is to create a view in Metabase that displays the Postgres ELT delivery data.

Acceptance criteria

• [ ] There is a view in Metabase that shows the Delivery Dashboard data

[coilysiren]

CREATE USER metabase WITH PASSWORD 'secret';
CREATE DATABASE metabase;
GRANT CONNECT ON DATABASE metabase TO metabase;
GRANT ALL PRIVILEGES ON DATABASE metabase TO metabase;

Change databases to metabase, then

GRANT ALL ON SCHEMA public TO metabase;

^ note: in prod replace literal metabase username with metabase_${random string}