commit 05cd01ea1b13c67ef3cbab75234375618321f66f
author Philipp Schrader <philipp.schrader@gmail.com> Thu Mar 09 20:51:33 2023 -0800
committer Philipp Schrader <philipp.schrader@gmail.com> Thu Mar 09 20:51:33 2023 -0800
tree acb46ceb2046e3dc198ac4e4b59248660edb0df4
parent 7317d8caf0822ddec976bf16b9a333af7b9bf21f

scouting: Make scouted data visible to Tableau

With the `--clear-db` argument, we were deleting the permissions as
well. This command will restore the permissions so that the students
can visualize the data gain.

Signed-off-by: Philipp Schrader <philipp.schrader@gmail.com>
Change-Id: I322f3d0e98b487f8eae13f2f3f9e1e1f3b6d8247

scouting/deploy/deploy.py

diff --git a/scouting/deploy/deploy.py b/scouting/deploy/deploy.py
index f947398..61c0481 100644
--- a/scouting/deploy/deploy.py
+++ b/scouting/deploy/deploy.py
@@ -47,6 +47,8 @@
                 "-c 'create schema public;'",
                 # List all tables as a sanity check.
                 "-c '\dt'",
+                # Make sure we make the visualizations accessible.
+                "-c 'GRANT ALL ON SCHEMA public TO tableau;'",
                 "postgres\"",
             ]),
             shell=True,