dbt supercharges SQL with Jinja templating, macros, and testing -- all of which can be customized to enforce controlled vocabularies and their implied contracts on a data model
An informal primer to causal analysis designs and data structures
Using the tidyverse's expressive data wrangling vocabulary as a preprocessor for elegant SQL scripts
An R package for maintaining controlled vocabularies to encode contracts between data producers and consumers
Using controlled dictionaries for low-touch documentation, validation, and usability of tabular data