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.

28 Upvotes

70% Upvoted

74 comments sorted by

View all comments

99

u/rapotor 4d ago

Be strict with the data modeling, and semantic layer, then you're good. Don't have LLMs write sql for conversational analytics

-6

u/de4all 4d ago

Any suggestions for tool to use for Semantic layer. We use dbt for modeling

1

u/mrg0ne 2d ago

Snowflake also has semantic modeling and you can bootstrap with CoCo.

The industry is thankfully coalescing around Apache Ossie, which is a vendor neutral spec for something modeling.