This is not a text to semantic layer but it does far more than just inject schema into the prompt:
- the engine keeps an updated catalog of the data (low cardinality columns, their values etc)
- taps into query history and finetunes the model to the schema
- allows uploading context from unstructured sources like docs and data dictionaries
- has an agent which collects all relevant info, generate the SQL, tries to retrieve a few rows to recover from errors and provides an confidence score to the generated SQL
aazo11|1 year ago
- the engine keeps an updated catalog of the data (low cardinality columns, their values etc) - taps into query history and finetunes the model to the schema - allows uploading context from unstructured sources like docs and data dictionaries - has an agent which collects all relevant info, generate the SQL, tries to retrieve a few rows to recover from errors and provides an confidence score to the generated SQL