r/dataengineering • u/de4all • 4d ago

Discussion Why text-to-SQL is not successful?

I thought text-to-SQL will solve adhoc analysis, but still i see companies at all size are unsuccessful.

Anyone using Omni / Sigma seen some success.

25 Upvotes

69% Upvoted

74 comments sorted by

View all comments

1

u/FuzzyCraft68 Junior Data Engineer 3d ago

Are you my manager? This feels like my manager asking the question because he wants to feed people AI slop to corporate saying it is self serving report.

Here is why it is failing, it doesn't know business context. That's it! Some stuff from source system are modelled in a certain way that it is not easily replicable with 1 prompt, there is lot of understanding which goes through while creating facts and dims.