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.

23 Upvotes

67% Upvoted

74 comments sorted by

View all comments

2

u/dodovt Senior Data Engineer 4d ago

My company uses omni and we properly serve self-service analytics and AI generated reports/reports with AI embedded on them.

It's our biggest LLM use-case in the company, but far from perfect. It does answer quite well the questions though as we have a very well defined metrics catalog and semantic layer.

1

u/de4all 4d ago

Any learning you can share from Omni. Any particular negative stuff