Skip to main content
The Chat page in Edit Data Layer mode shows how AstroBee understands your business data model. Here you can explore entities, view their properties and relationships, and make changes using natural language to improve how AstroBee interprets your data.

Interface overview

This page has three main areas:
Data Layer interface showing entity list and properties
  • Chat - The current active section (highlighted with pencil icon) where you can edit your data layer
  • Sources - View raw data connections
  • MCP - Connect to external tools via Model Context Protocol
  • Conversations - See your past questions and AstroBee’s responses

Center panel

The center panel helps you explore your data layer through three tabs:
View all entities in your data layer. Click any entity to see its details in the entity browser. The right side shows Business Value (what insights this data layer enables) and Model Details (version, database, patterns persisted, unmapped fields).
Tables tab showing entity list

Entity browser

Click any entity in the Tables list to open its details. The entity browser has four tabs:
Preview actual data records from the selected entity. Shows sample values and data types with a 200-row preview. You can download the full data as CSV.
Data tab showing actual records from the selected entity

Understanding your data layer

Your data layer is a map of how your business concepts connect to your raw data and to each other. Here’s what makes it up:

Entities

Each entity represents a core business concept that AstroBee has identified from your data:
EntityDescription
CompanyOrganization associated to contacts, product users, and billing based on website/domain
ContactA person engaged via marketing/sales (lead, MQL, SQL, customer) from CRM
Product UserAn application user with account activity and engagement metrics
Billing AccountThe paying account profile used for invoicing and payments
SubscriptionA recurring billing plan agreement status with MRR, currency, and start dates
PlanThe commercial tier (e.g., Starter, Growth, Enterprise) associated with users and subscriptions

Properties

Properties describe each entity and come in different types:
Property TypeDescription
IdentifiersUnique keys that identify each instance (e.g., customer_id, email)
Descriptive fieldsAttributes and values (e.g., name, total_spend, created_date)
Calculated metricsDerived values like averages or totals
Data typesString, Integer, Timestamp, etc.

Relationships

Relationships show how entities connect to each other:
Relationship TypeDescription
One to ManyOne company has many billing accounts
Many to ManyMultiple relationships between entities

Editing your data layer

To edit your data layer, type your requests in natural language in the chat input. AstroBee handles both simple and complex edits automatically. Simple changes like renaming a property complete in seconds, while complex changes like creating new entities with multi-table joins take longer as AstroBee reasons through the requirements.
Data Layer editing interface with chat

Simple edits

Simple edits are fast, focused changes to individual properties or relationships. These complete quickly without requiring deep analysis.

Making requests

Describe what you want to change in plain English:
  • “Rename Total Shipments to Shipments”
  • “Add customer satisfaction metrics”
  • “Normalize email addresses to lowercase for better matching”
  • “Fix the join between Contacts and Users - emails don’t match”
You can also ask AstroBee to apply entity resolution or normalization when automatic matching didn’t connect all your records. AstroBee processes your request and shows its reasoning. You’ll see each step as it executes queries, validates changes, and updates the model. “Thought for X seconds” indicates processing time.
AstroBee reasoning through an edit request

Reviewing changes

After processing, you’ll see a Proposed Changes panel showing what will be modified. Click into an edited entity to see detailed changes with properties marked as Added, Modified, or Removed:
Proposed Changes panel showing edited and unchanged entities
Detailed view of property changes

Saving your changes

Click Accept Changes to save. You’ll be prompted to enter a commit message describing your changes. After saving, you’ll see a success notification and the new version appears in your version history:
Commit message dialog
Data Layer saved successfully notification
Click Discard Changes to cancel and return to the previous version without saving.

Complex edits

Complex edits involve creating new business entities, restructuring relationships, or synthesizing data across multiple sources. These take longer as AstroBee researches your data and reasons through the requirements. For example, you might request:
Create a CustomerUnified entity: A single, analytics-ready view per company across
marketing (contacts), product (users), and billing (subscriptions/MRR).
This will give me account-level health and revenue in one place
Complex edits can accomplish:
  1. Complex entity creation - AstroBee creates new entities that consolidate data across multiple business domains
  2. Multi-table aggregation - Generates key measures like contact counts, user engagement metrics, billing account counts, and MRR calculations
  3. Intelligent relationships - Establishes proper connections between the new entity and existing entities
  4. SQL view generation - Creates sophisticated SQL that aggregates data from multiple systems
  5. Business logic integration - Applies normalization rules and assumptions for data consistency

Rename data layer

You can rename your entire data layer to better reflect your business or project. Click the ellipsis () next to your data layer name, select ” Rename” and enter a new name. The change applies immediately and creates a new version, updating both the display name and system identifier to keep your data layers organized as projects evolve.

Delete data layer

To permanently delete a data layer, click the ellipsis () next to the data layer name and select ” Delete.” You’ll see a confirmation dialog warning that this action cannot be undone. Once deleted, the data layer is completely removed and you’ll be redirected to the model selection screen to choose or create a different data layer.

Version management

Your data layer is versioned automatically:
  • Timestamps show when each version was created
  • Version numbers increment with each change (v1, v2, v3, etc.)
  • Commit messages describe what changed in each version
  • Rollback capability lets you return to previous versions if needed
Data Layer version management interface

Best practices

Be specific in your requests - Instead of “improve the model,” say “add customer retention metrics” Review changes carefully - Check that modifications match your business understanding before saving Use business terminology - Describe changes using language your team understands Test after changes - Ask questions in Ask mode to verify improvements work as expected

Next steps