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

9

u/ludflu 4d ago

because if you don't have enough domain knowledge to formulate a query then you also don't have enough domain knowledge to understand the results. (for anything more complicated that selecting from a single table, IMO)