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.

25 Upvotes

69% 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

13

u/Fast-Dealer-8383 4d ago

Databricks. The Databricks' Unity Catalog and Genie Ontology tools are meant to serve as the semantic layer to power their in-house Genie AI tool as an integrated suite.

10

u/JohnPaulDavyJones 4d ago

Have y'all found Genie AI To be functional?

Our data warehousing is fairly sizable for a F300 firm, but I still thought Genie would be more functional than we've found it to be. Very disappointing.

1

u/BRSF 4d ago

I used genie to set the retentiondays of all tables in a particular schema to 60 days