Sometimes, we get data in its natural, normalized form. More frequently, however, we get denormalized data, where some attribute or identity that exists in its own right has been embedded in related data. When modeling for enterprise concepts (nouns, not verbs) we will often want to renormalize. In our case, the Scryfall data has been denormalized, and we need to renormalize it. That’s what we’re going to do today, now that we have more or less finished modeling our card data. Welcome! In this series on exploring data, we use dbt to plumb the...