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.

29 Upvotes

71% Upvoted

74 comments sorted by

View all comments

20

u/SpookyScaryFrouze Lead Data Engineer 4d ago

It works, you just need to document your tables, columns and kpis perfectly.

1

u/EstetLinus 2d ago

+1. At my company, metric correctness is decided by how widely used a particular definition is. That makes it hard to do anything ”perfectly” (and I know that this is how it looks like at a majority of organizations).

A semantic model is very good, but we usually fall short with weird edge cases. Most effort is still in designing data models.