Arcane Insight

Arcane Insight is a data analytics project designed to harness the power of SQLMesh & DuckDB to collect, transform, and analyze data from Blizzard's Hearthstone API.

Focused on card statistics and attributes, this project reveals detailed insights into card mechanics, strengths, and trends to support BI and strategic analysis.

ERDs

Bronze

bronze.raw.*

erDiagram
    raw__hearthstone__bg_game_modes
    raw__hearthstone__cardback_categories
    
    raw__hearthstone__cards }|--|| raw__hearthstone__cards: "parentId > id"
    raw__hearthstone__cards }|--|| raw__hearthstone__cards: "childIds > id"
    raw__hearthstone__cards||--|| raw__hearthstone__cards: "copyOfCardId > id"
    
    raw__hearthstone__cards||--|{ raw__hearthstone__cardbacks: "id > id"
    raw__hearthstone__cards||--|{ raw__hearthstone__classes: "classId > id"
    raw__hearthstone__cards }|--|{ raw__hearthstone__classes: "multiClassIds > id"
    raw__hearthstone__cards }|--|{ raw__hearthstone__keywords: "keywordIds > id"
    raw__hearthstone__cards||--|{ raw__hearthstone__minion_types: "minionTypeId > id"
    raw__hearthstone__cards||--|{ raw__hearthstone__rarities: "rarityId > id"
    raw__hearthstone__cards||--|{ raw__hearthstone__sets: "cardSetId > id"
    raw__hearthstone__cards||--|{ raw__hearthstone__types: "cardTypeId > id"
    raw__hearthstone__cards }|--|{ raw__hearthstone__types: "multiTypeIds > id"
    raw__hearthstone__cards ||--|{ raw__hearthstone__spell_schools: "multiTypeIds > id"
    
    raw__hearthstone__classes }|--|| raw__hearthstone__cards: "cardId > id"
    raw__hearthstone__classes }|--|| raw__hearthstone__cards: "heroPowerCardId > id"
    raw__hearthstone__classes }|--|{ raw__hearthstone__cards: "alternateHeroCardIds > id"
    
    raw__hearthstone__keywords ||--|{ raw__hearthstone__game_modes: "gameModes > id"
    raw__hearthstone__mercenary_factions
    raw__hearthstone__mercenary_roles
    raw__hearthstone__minion_types ||--|{ raw__hearthstone__game_modes: "gameModes > id"
    raw__hearthstone__sets }|--|{ raw__hearthstone__set_groups: "id > cardSets"
    raw__hearthstone__spell_schools ||--|{ raw__hearthstone__game_modes: "gameModes > id"
    raw__hearthstone__types ||--|{ raw__hearthstone__game_modes: "gameModes > id"

Loading

Silver

silver.raw_vault.*

erDiagram
    raw__hub__card ||--|{ raw__sat__card: ""
    raw__hub__card_set ||--|{ raw__sat__card_set: ""
    raw__hub__card_type ||--|{ raw__sat__card_type: ""
    raw__hub__class ||--|{ raw__sat__class: ""
    raw__hub__rarity ||--|{ raw__sat__rarity: ""
    raw__hub__spell_school ||--|{ raw__sat__spell_school: ""
    
    raw__link__card__card_set }|--|| raw__hub__card: ""
    raw__link__card__card_set }|--|| raw__hub__card_set: ""
    raw__link__card__card_set ||--|{ raw__sat_eff__card__card_set: ""
    
    raw__link__card__card_type }|--|| raw__hub__card: ""
    raw__link__card__card_type }|--|| raw__hub__card_type: ""
    raw__link__card__card_type ||--|{ raw__sat_eff__card__card_type: ""
    
    raw__link__card__class }|--|| raw__hub__card: ""
    raw__link__card__class }|--|| raw__hub__class: ""
    raw__link__card__class ||--|{ raw__sat_eff__card__class: ""
    
    raw__link__card__rarity }|--|| raw__hub__card: ""
    raw__link__card__rarity }|--|| raw__hub__rarity: ""
    raw__link__card__rarity ||--|{ raw__sat_eff__card__rarity: ""
    
    raw__link__card__spell_school }|--|| raw__hub__card: ""
    raw__link__card__spell_school }|--|| raw__hub__spell_school: ""
    raw__link__card__spell_school ||--|{ raw__sat_eff__card__spell_school: ""

Loading

Gold

gold.mart__cards.*

erDiagram
    fact__cards }|--|| dim__cardbacks: "cardback_pit_hk"
    fact__cards }|--|| dim__cards: "card_pit_hk"
    fact__cards }|--|| dim__classes: "class_pit_hk"
    fact__cards }|--|| dim__minion_types: "minion_type_pit_hk"
    fact__cards }|--|| dim__rarities: "rarity_pit_hk"
    fact__cards }|--|| dim__tourist_classes: "tourist_class_pit_hk"
    fact__cards }|--|| dim__types: "type_pit_hk"
    fact__cards }|--|| dim__sets: "set_pit_hk"
    
    fact__cards ||--|{ link__related_cards: "fact_record_hk"
    link__related_cards }|--|| dim__related_cards: "related_card_pit_hk"
    
    fact__cards ||--|{ link__related_classes: "fact_record_hk"
    link__related_classes }|--|| dim__related_classes: "related_class_pit_hk"
    
    fact__cards ||--|{ link__related_types: "fact_record_hk"
    link__related_types }|--|| dim__related_types: "related_type_pit_hk"
    
    fact__cards ||--|{ link__keywords: "fact_record_hk"
    link__keywords }|--|| dim__keywords: "keyword_pit_hk"

Loading