Josh Zamor

TZUP-345, restructure to star schema

  1. … 8 more files in changeset.
TZUP-345, restructure to star schema

  1. … 8 more files in changeset.
TZUP-345, renable cron to refresh mview

TZUP-345, renable cron to refresh mview

TZUP-345, update refresh of mviews, move to daily

TZUP-345, update refresh of mviews, move to daily

TZUP-345, fix plural naming

TZUP-345, fix plural naming

TZUP-345, refactor dim reporting dates into view

TZUP-345, refactor dim reporting dates into view

TZUP-345, reorder dimensions and facts

  1. … 3 more files in changeset.
TZUP-345, reorder dimensions and facts

  1. … 3 more files in changeset.
TZUP-345, remove pre-star data models

TZUP-345, remove pre-star data models

TZUP-345, rename match convention of views

TZUP-345, rename match convention of views

TZUP-345, reorient toward dimensional model

still a mess as we have the older structure in here as well, that doesn't work,

for comparison

  1. … 3 more files in changeset.
TZUP-345, reorient toward dimensional model

still a mess as we have the older structure in here as well, that doesn't work,

for comparison

  1. … 3 more files in changeset.
TZUP-345, name the db volume

This helps prevent the volume from being orphaned in a docker compose

down.

TZUP-345, name the db volume

This helps prevent the volume from being orphaned in a docker compose

down.

TZUP-345, add index on country for better plan

Otherwise the query planner is off many orders of magnitude.

TZUP-345, add index on country for better plan

Otherwise the query planner is off many orders of magnitude.

TZUP-345, remove unneeded chain call

TZUP-345, remove unneeded chain call

TZUP-345, re-order for clean sequence for postgres

  1. … 7 more files in changeset.
TZUP-345, re-order for clean sequence for postgres

  1. … 7 more files in changeset.
TZUP-345, move into postgres' order

TZUP-345, move into postgres' order

TZUP-345, format for postgres container sql

TZUP-345, format for postgres container sql