Skip to main content

​
A

​
Analytics Chat

The natural language interface for querying your data. Ask questions in plain English and get answers with full SQL transparency.

​
D

​
Data Hub

The central location for managing all data connections. Upload files, connect external tools, and explore your data.

​
Data Layer

A semantic model that maps business concepts to raw data. Consists of entities, properties, and relationships. Previously called “Ontology” in some contexts.

​
Data Source

A connection to external data—either an uploaded file or a connected service like Salesforce or Google Sheets.

​
Dimension

A property used for grouping or filtering data. Examples: customer_id, category, status.

​
E

​
Entity

A business concept in your data layer. Examples: Customer, Product, Order. Entities have properties and relationships.

​
Entity Resolution

The process of matching records that refer to the same real-world entity across different data sources, even when identifiers differ.

​
F

​
Fact

An entity type representing measurable events or transactions. Examples: Order, PageView, Payment.

​
Fivetran

AstroBee’s partner for external data connections. A SOC 2 certified data integration platform.

​
L

​
Linkage

A discovered relationship between tables, typically a foreign key reference like orders.customer_id → customers.customer_id.

​
M

​
MCP (Model Context Protocol)

An open standard that lets AI assistants connect to external tools. AstroBee’s MCP server enables querying data layers from Claude Code, Claude Desktop, or VS Code.

​
Measure

A property that contains numeric values for aggregation. Examples: price, quantity, total_amount.

​
N

​
Normalization

The process of standardizing data formats (like email case normalization) to enable accurate matching across sources.

​
O

​
OAuth

The authorization standard used for connecting external data sources. Credentials are never stored by AstroBee.

​
P

​
Pattern Analysis

Automatic discovery of data patterns in columns, such as ID formats, email structures, or date formats.

​
Property

An attribute of an entity. Examples: Customer.email, Product.price. Properties are classified as Dimensions or Measures.

​
R

​
Relationship

A connection between entities in your data layer. Defined by cardinality (one-to-many, many-to-many) and join conditions.

​
S

​
Scratchpad

A working area for data layer changes before they’re published. Review and publish changes to create a new version.

​
SQL Transparency

AstroBee shows the exact SQL query generated for every answer, so you can verify and understand the logic.

​
V

​
Version History

The record of all published versions of a data layer, including conversation history and changes made.