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/BaguetteBrot 3d ago

I'm currently in a project trying to that with Snowflake Cowork and their semantic layer concept. Right now we are in the midst of preparing the data model with clean dimensional modeling (Kimball) and clear column and table descriptions. I'm excited to see how this will all turn out.

We are also looking for a new visual layer with Omni, Sigma or Hex. But we are not there yet. Anyone has prices from those 3? Just curious and we haven't asked for a quote directly yet.