The Knowledge Graph

Build your data model with context—define relationships, meanings, and business rules to enable natural language querying.

What It Is

The Athenic Knowledge Graph is a visual semantic layer that connects your live SQL schema with your unique business logic—enabling Athenic to interpret your questions accurately and generate precise SQL queries.

  • Reflects your live schema: tables, columns, and joins from your connected data source.

  • Embeds business context: field descriptions, KPIs, filters, and definitions mapped onto your schema.

  • Built with a drag-and-drop interface for defining joins, annotating fields, and linking shared concepts like “customer” or “active user.”

The more context you provide, the more precise Athenic becomes

Knowledge Graph

How It’s Built

During project setup, you will:

  1. Connect a SQL data source

  2. Create datasets (via table selection or custom SQL)

  3. Use the Knowledge Graph editor to:

    • Define joins and relationships

    • Add context to fields and tables

    • Map KPIs, filters, and shared business logic

Datasets help reorganize and prepare your raw data, while the Knowledge Graph adds semantic meaning and business logic for accurate querying

For detailed setup instructions, see New Project and Project Settings.

Context in the Knowledge Graph

How It Powers Athenic

When a user asks a question:

  1. Athenic interprets the intent by referencing the Knowledge Graph, which contains your data schema, business definitions, KPIs, and context.

  2. If the intent is unclear or ambiguous, the AI may ask clarifying questions to better understand what you mean.

  3. It matches phrases to the right fields, filters, and metrics.

  4. Generates and runs SQL on your live database.

  5. Returns both a data table and editable chart, plus automated insights.


What You Get

  • Live data tables Data tables generated by querying your connected database

  • Auto-generated, customizable charts

  • Summarized insights and trends based on your business definitions

Athenic queries your connected data sources when you ask a question, returning results based on the latest data available at query time


Quick Setup Summary

  1. Connect your data

  2. Create datasets

  3. Build your Knowledge Graph

  4. Refine and evolve over time

Last updated