The combined dbt/Evidence project for Sean's coffee ratings log.

• dbt project documentation
• Evidence report

The Full Stack

1. Data is tracked in Collections, a macOS/iOS database app with Shortcuts support.¹
2. A shortcut exports the data to CSV, converts column names from Title Case to snake_case, and saves the files to S3 via S3 Files. This shortcut is run on a schedule with automations.
3. This dbt project transforms the data in MotherDuck.
4. The Evidence site is deployed on Vercel.

Footnotes

1. Until recently, this was done in Airtable and synced via Fivetran. ↩