appspace / appspace/kwwhat

bridges for attempts and visits

Aberta
#150 2 comentários 0 reações 0 responsáveis Ver no GitHub
Linguagem predominante
Sem dados de linguagem
Estrelas
14
Forks
3
Métricas de merge de PRs
Nenhum PR com merge em 30d

Descrição

`fact_attempts` and `fact_visits` have arrays in their output. Looks like the better way is to use bridge tables.

---
Bridge Tables
A helper table that resolves many-to-many relationships between a fact table and a dimension.
Why it exists:

Dimensions should be one-to-many with facts (one product per sale)
But sometimes facts have many dimensions of the same type (e.g., one order has many products, or one product has multiple colors)
Bridge tables enable many-to-many relationships while maintaining the star schema

Example - Orders with Multiple Products:
Without bridge table (denormalized fact):
OrderKey | ProductKey | Quantity | Amount
1 | 100 | 2 | 49.98
1 | 101 | 1 | 29.99 ← Same order, multiple rows (violates grain)
With bridge table:
Order_Product Bridge
├── OrderKey | ProductKey | Quantity | Amount | Weight
│ 1 | 100 | 2 | 49.98 | 0.5
│ 1 | 101 | 1 | 29.99 | 0.5

Orders Fact (grain: one row per order)
├── OrderKey | CustomerKey | DateKey | TotalAmount
│ 1 | 5 | 120 | 79.97
Common use cases:

Multiple products per order
Multiple colors/sizes per product variant
Multiple physicians per patient visit
Multiple technicians per service call

Guia de contribuição

Nenhum guia de contribuição indexado para este repositório

Direção de pesquisa

Start by locating the fact_attempts and fact_visits model definitions and inspecting how their arrays are produced. Review the existing fact-table grain and determine the bridge-table structure needed for each relationship; done means the arrays are replaced by appropriate bridges without breaking the fact outputs or their relationships.

Escrita pelo modelo de indexação a partir do texto da issue.

Avaliação

Domínio
data-engineering, databases
Tipo de issue
Refatoração
Dificuldade
4/5
Tempo estimado
3-5 dias
Status de atividade
Pouca atividade
Clareza
Precisa de esclarecimento
Facilidade para iniciantes
45/100

Receba novas issues na sua caixa de entrada

Um resumo curto de issues do GitHub para quem está começando.