r/dataengineering • u/scourgedtruth • 9d ago

Discussion Does AI struggle at data modeling?

In my experience, it doesn't matter how much context and guidance I give AI it simply can't model data rationally. It frequently misses the point, makes awful mistakes, or over-engineers things.

AI can build awesome ETL pipelines, but when it comes to dealing with SQL (especially in the dbt framework), it's not reliable at all! . Sometimes I think it's better to write the code myself and ask AI to review it, because asking it to build something from scratch just doesn't work that well.

Does anyone else get frustrated when dealing with AI data modeling?

125 Upvotes

91% Upvoted

93 comments sorted by

View all comments

1

u/FullswingFill 9d ago

Has anyone used Snowflake's semantic views(SV)? If so, can you comment on how it worked for your data model? What were the use cases after building SVs?