> ## Documentation Index
> Fetch the complete documentation index at: https://docs.astrobee.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Data Hub

> Connect, preview, and analyze your data sources

The Data Hub is your central location for managing all data connections in AstroBee. Upload files, connect external tools, and explore your data before building a data layer.

<Frame caption="Data Hub showing connected data sources">
  <img src="https://mintcdn.com/astrobee-f4b330e6/ppM7q3dJGmeBWRIe/screenshots/16-data-source-with-data.png?fit=max&auto=format&n=ppM7q3dJGmeBWRIe&q=85&s=0ccee4e3978793786377ec95a27dbbde" alt="Data Hub" width="2850" height="1608" data-path="screenshots/16-data-source-with-data.png" />
</Frame>

## Accessing the Data Hub

Click **Data Sources** in the sidebar to open the Data Hub.

## Adding Data Sources

Click **Add New** to see all available connection options:

<Frame caption="Data source connection options">
  <img src="https://mintcdn.com/astrobee-f4b330e6/ppM7q3dJGmeBWRIe/screenshots/03-add-data-source-options.png?fit=max&auto=format&n=ppM7q3dJGmeBWRIe&q=85&s=e386783859742f4b3e4daa6fef99f961" alt="Add data source" width="2850" height="1608" data-path="screenshots/03-add-data-source-options.png" />
</Frame>

### File Uploads

Upload spreadsheets directly:

| Format              | Max Size | Features                  |
| ------------------- | -------- | ------------------------- |
| CSV                 | 300 MB   | Automatic type detection  |
| Excel (.xlsx, .xls) | 300 MB   | Multiple sheets supported |

Drag and drop files or click to browse.

### External Connectors

Connect business tools via secure Fivetran integration:

| Connector         | Data Types                           |
| ----------------- | ------------------------------------ |
| **Google Sheets** | Live sync with specific sheets       |
| **Salesforce**    | Leads, Opportunities, Accounts       |
| **HubSpot**       | Contacts, Deals, Marketing data      |
| **LinkedIn Ads**  | Campaign analytics, Ad performance   |
| **Reddit Ads**    | Campaigns, Posts, Engagement metrics |
| **Klaviyo**       | Email campaigns, Flows, Subscribers  |
| **Meta Ads**      | Campaigns, Audiences, Performance    |
| **Google Ads**    | Campaigns, Ad groups, Conversions    |

<Info>
  External connections use [Fivetran](https://www.fivetran.com/), a SOC 2 certified data integration platform. Your credentials are encrypted and never stored by AstroBee.
</Info>

## Data Source Cards

Each connected source shows a card with key information:

| Field                | Description                        |
| -------------------- | ---------------------------------- |
| **Name**             | Editable display name              |
| **Type**             | CSV Upload or connector name       |
| **Pattern Analysis** | Status of column pattern discovery |
| **Intra Linkage**    | Status of relationship discovery   |
| **Last Sync**        | When data was last updated         |
| **Rows Synced**      | Total row count                    |
| **Tables**           | Available tables in this source    |

## Exploring Tables

Click a table name to preview its data:

<Frame caption="Table preview showing data and schema">
  <img src="https://mintcdn.com/astrobee-f4b330e6/ppM7q3dJGmeBWRIe/screenshots/17-table-detail.png?fit=max&auto=format&n=ppM7q3dJGmeBWRIe&q=85&s=ba347065b528201be827495e3f7da9ca" alt="Table preview" width="2850" height="1608" data-path="screenshots/17-table-detail.png" />
</Frame>

The preview shows:

* Column names with data types
* Sample data (up to 20 rows)
* Pattern analysis buttons for each column

### Pattern Analysis

AstroBee automatically analyzes columns to discover patterns:

<Frame caption="Pattern analysis for Customer ID column">
  <img src="https://mintcdn.com/astrobee-f4b330e6/ppM7q3dJGmeBWRIe/screenshots/18-column-patterns.png?fit=max&auto=format&n=ppM7q3dJGmeBWRIe&q=85&s=8967feffe07b370733f1fb82d6def125" alt="Pattern analysis" width="2850" height="1608" data-path="screenshots/18-column-patterns.png" />
</Frame>

Pattern details include:

* **Description** — Human-readable pattern explanation
* **Coverage** — Percentage of values matching the pattern
* **Regex** — Technical pattern definition
* **Examples** — Sample values matching the pattern

Patterns help AstroBee:

* Understand data semantics (IDs, emails, dates)
* Suggest appropriate entity mappings
* Discover relationships between tables

## Linkage Discovery

AstroBee automatically discovers relationships between tables within a data source:

* **Key references** — Foreign key relationships (e.g., `orders.customer_id` → `customers.customer_id`)
* **Pattern matches** — Columns with matching patterns across tables

View discovered linkages in the Data Layer → Linkages tab.

## Managing Data Sources

### Renaming

Click the data source name to rename it. Names help identify sources when connecting to data layers.

### Syncing

External connectors sync automatically based on your Fivetran configuration. File uploads are one-time imports.

To update file data:

1. Upload a new version of the file
2. The existing source is replaced

### Deleting

Click the menu button (⋮) on a data source card to delete it.

<Warning>
  Deleting a data source removes its data from AstroBee. Data layers using this source will lose access to its tables.
</Warning>

## Demo Data

New accounts can load demo datasets to explore AstroBee:

| Demo                    | Contents                                        |
| ----------------------- | ----------------------------------------------- |
| **Basic E-Commerce**    | Customers, Products, Orders (1 source)          |
| **Complete E-Commerce** | Full e-commerce with marketing data (2 sources) |

Demo data is great for learning the platform before connecting your own data.

## Next Steps

<CardGroup cols={2}>
  <Card title="Build a Data Layer" icon="sitemap" href="/features/data-layer">
    Create entities and relationships from your data
  </Card>

  <Card title="Connector Guides" icon="plug" href="/data/overview">
    Step-by-step guides for each connector
  </Card>
</CardGroup>