Connection Methods
File Uploads
Upload spreadsheets directly to AstroBee:| Format | Max Size |
|---|---|
| CSV (.csv) | 300 MB |
| Excel (.xlsx, .xls) | 300 MB |
External Connectors
Connect business tools via secure Fivetran integration:Google Sheets
Live sync with specific Google Sheets
Salesforce
Leads, Opportunities, Accounts
HubSpot
Contacts, Deals, Marketing data
LinkedIn Ads
Campaign analytics, Ad performance
Reddit Ads
Campaigns, Posts, Engagement
Klaviyo
Email campaigns, Flows, Subscribers
Meta Ads
Campaigns, Audiences, Performance
Google Ads
Campaigns, Ad groups, Conversions
How Connectors Work
External data sources use Fivetran for secure, reliable data synchronization:- Authentication — You authorize AstroBee to access your data via OAuth
- Sync — Fivetran securely transfers data to your AstroBee warehouse
- Analysis — AstroBee analyzes patterns and discovers relationships
- Exploration — Preview tables and build your data layer
Security
- OAuth 2.0 — Industry-standard authorization (credentials never stored)
- Encryption — All data encrypted in transit (TLS 1.3) and at rest (AES-256)
- SOC 2 Certified — Both Fivetran and AstroBee maintain SOC 2 compliance
Adding a Data Source
- Navigate to Data Sources in the sidebar
- Click Add New
- Select your data source type
- Complete the authentication flow
- Wait for initial sync to complete
After Connecting
Once your data syncs, AstroBee automatically:- Detects schemas — Identifies tables, columns, and data types
- Analyzes patterns — Discovers ID formats, email patterns, date formats
- Finds linkages — Identifies relationships between tables
- Preview table data
- View discovered patterns
- Connect the source to a data layer
- Build entities and relationships
Data Source Limits
| Plan | Data Sources | Storage |
|---|---|---|
| Free | 2 | Shared warehouse |
| Pro | Unlimited | Shared warehouse |
| Enterprise | Unlimited | Bring Your Own Bucket |
Next Steps
Upload Files
Upload CSV or Excel files
Build a Data Layer
Create entities from your data