3 ms·
> Text to SQL that actually works. Ask questions in natural language across multiple tables and our engine knows where to join. Can you share any information a
by philipodonnell 3y ago
> Text to SQL that actually works. Ask questions in natural language across multiple tables and our engine knows where to join.
Can you share any information about how it knows where to join?
- mritchie712 3y agoWe do a couple things here: 1. When you bring your own data warehouse, we parse the query history, convert it so an AST and learn JOIN's from there 2. When you're using our managed data warehouse and ETL, we already know most of the JOIN's (e.g. we know how to join the Hubspot data we ingress to Stripe) 3. For anything not covered by #1 or #2, we have a modeling layer where you can specify how to join tables.