Recently I’ve been working more with AI tools at work, primarly Cursor. It’s been extremely useful in automating the lower value parts of the analytics engineering workflow: writing config for data models (dbt yml files) and writing basic documentation in markdown (drawing from comments and logic in the SQL files). It’s also good enough to suggest adding basic tests, like standard unique and not_null dbt tests.
AI tools have made me more productive. They’ve also raised a question that keeps nagging at me: if I extrapolate this out 5-10 years, what’s left for humans to do? AI will move from the lower value to higher value tasks. Perhaps there’s some ceiling they’ll hit where humans will remain . But there’s concept in economics that offers a more nuanced—and perhaps surprising—perspective: comparative advantage.
[Read More]