New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Create DAGs for joining TMX and TMIO data from Conform and promoting to Consume #2

Closed

4 tasks done

Tracked by

caseyjohnsonwv opened this issue Mar 1, 2023 · 1 comment

Closed

4 tasks done

Tracked by

Create DAGs for joining TMX and TMIO data from Conform and promoting to Consume #2

caseyjohnsonwv opened this issue Mar 1, 2023 · 1 comment

Assignees

Labels

epic

Owner

caseyjohnsonwv commented Mar 1, 2023 •

edited

Loading

We're going to want a variety of tables in the Consume layer. This is what I've come up with off the top of my head:

TOTD
track name, exchange_id, authors, totd date, upload date, days from upload to totd, medal times
TOTD_Tags
exchange_id, tag name (repeated for multiple tags on one map)
TOTD_WorldRecords
exchange_id, wr_time, wr_player, date driven
TOTD_Authors
exchange_id, author user_id, all tags on all of author's maps

caseyjohnsonwv mentioned this issue

Project Roadmap #1

Open

17 tasks

caseyjohnsonwv added the epic label

caseyjohnsonwv self-assigned this

Owner Author

caseyjohnsonwv commented Mar 3, 2023

Four DAGs here (3 DAGs and a view, actually) are complete. Will open a new issue for new tables.

caseyjohnsonwv closed this as completed

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment