Overview

The Gen AI Query Engine is an AI-driven query processing solution designed to simplify database interactions while enforcing data privacy. By leveraging OutSystems for UI, Gemini AI for query generation, and Snowflake for execution, users can access structured data using natural language prompts—without writing SQL queries.

Architecture & Workflow

1. Metadata Retrieval – Snowflake provides schema details for AI processing.

2. User Input Handling – Users enter natural language queries via OutSystems UI.

3. AI-Powered SQL Generation – Gemini AI translates prompts into metadata-based SQL queries.

4. Query Execution in Snowflake – SQL queries run in Snowflake, returning JSON results.

5. Natural Language Response Generation – AI converts query results into human-readable text.

Key Benefits

• No SQL Knowledge Required – Users simply ask questions, and the system retrieves relevant data.
• Enhanced Privacy – AI models never process raw data, ensuring compliance with security standards.
• Business-Friendly AI Integration – Ideal for analysts, executives, and customer support teams.

Use Cases

• Business Intelligence for Non-Technical Users – Get quick insights without SQL expertise.

• Customer Support Query Handling – Agents retrieve customer details instantly.

• Data-Driven Decision Making – Executives access structured reports using simple questions.

For more details, please refer to the Medium post: Gen AI Query Engine Medium Post