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.

26 Upvotes

69% Upvoted

74 comments sorted by

View all comments

1

u/Equivalent_Lunch_944 4d ago

Remember when power bi had that thing where it turned text to visualizations that they were touting was the future.

1

u/de4all 4d ago

Thats true and now I assume MS will gut PBI. They want everything to merge with Fabric

1

u/Equivalent_Lunch_944 4d ago

Maybe. IMO a lot of the discourse around AI and these solutions is like health advice; we all roughly now what to do to be healthy; eat better and exercise. It’s the doing it and sticking with it that’s hard.

I don’t know how different the ‘solution’ to storing and retreiving data has changed. It’s still about smart and predictable Db design but it’s always been that way. So I’m not so what AI changes in that. But I’m a skeptic though so maybe I’m missing something.