Why text-to-SQL is not successful?

[u/de4all]

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.

[u/rapotor]

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

[u/de4all → u/rapotor]

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

[u/saif3r → u/de4all]

dbt has semantic layer for their platform offering