# Sync Apollo to Google BigQuery

Automatically sync your Apollo data into Google BigQuery with Flatly's no-code, triggerless, turnkey integration service.

## Historical & Dynamic Data

### One-way Sync

### For Non-technical Users

[Connect Apollo to Google BigQuery](https://app.flatly.io/signup) [Which Apollo API does Flatly use?](https://developer.apollo.io/)

## Source: Apollo

Apollo is a leader in Sales Intelligence & Sales Engagement.

**Auth:** OAuth  
**Available datasets**  
- Accounts  
- Contacts  
- Opportunities

## Destination: Google BigQuery

Looker reads tables from Google BigQuery.

**Auth:** Service Account  
**Supported file formats**  
- NDJSON

## How it works

1. ### Connect Apollo

Authenticate Apollo (OAuth) and Google BigQuery (Service Account) in the Flatly dashboard. You only have to do this once.

2. ### Choose your datasets

Pick which Apollo datasets to sync and set your sync frequency. The frequencies available to you depend on your Flatly [plan](/content/pricing/index.html).

3. ### Data lands in Google BigQuery

Flatly uploads your Apollo data to Google BigQuery automatically and refreshes it based on your sync frequency.

## FAQ: Google BigQuery

### How does schema setup work?

Flatly leverages intelligent schema generation that adapts to BigQuery's auto-detection protocols, handling data type inference and column ordering automatically so you never have to manually map fields.

### What about data sanitization?

Data hygiene is built directly into the ingestion process. Before a single row is written to BigQuery, Flatly validates your data against a generated reference schema. It proactively detects and strips out "schema violators" — inconsistent data types or malformed records that would typically cause a load job to crash. Flatly logs these exclusions in a detailed metadata file, ensuring your pipeline remains resilient and continuous while giving you full transparency into data quality issues.

### How performant and scalable is this integration?

This integration is designed for scale and flexibility, the engine processes data in memory-optimized chunks to handle massive datasets efficiently. It offers powerful pre-load controls, allowing you to filter rows based on custom logic (e.g., date ranges, specific values) and allowlist specific keys. This ensures that you only sync high-value data, optimizing your BigQuery storage costs and query performance.

### How does authorization work?

Everything is secured via Service Account authentication, providing a stable, production-grade connection for your most critical analytics dashboards.

### What is special about this integration?

Price-to-performance is impressive. Data can be synced to BigQuery every 6 hours for just $19 a month.

## Features

### Full data refresh
Maintain up-to-date flat files when any nested or bundled data changes in your source app.

### Connection Management
Manage multiple tenants, with connection health monitoring.

### Bulk Job Management
Control multiple jobs at the same time, with live progress monitoring.

### Merged datasets
Export left-joined combo objects like deals+products.

### Write options
Refresh one flat file or create a stack of timestamped versions.

### Filterability
Include only the columns or views essential for your reporting.

### Notifications
Get alerts about your syncs via email, webhooks or Slack notifications.

### Logging
Access up to one thousand log entries for your sync operations.

### Custom Field Enrichment
Get useful values in your data instead of identifiers or definitions.

### Metadata Attachment
See file statistics alongside your flat files to keep track of their origins.

### Dark UI Mode
Reduce eye strain and save energy by using our built in dark mode.

### Programmatic Jobs
Queue jobs by making API calls or agent requests.

### Time Stamp Enrichment
Get human-readable dates and times from UNIX timestamps.

### High frequency
10-minute refresh cycles mean your data store is near real-time.

### High capacity
Reliably flatten billions of cells to CSV files without hiccups.

### Advanced Security
Two-factor authentication and Destination Lock controls.

### Stripe-powered Billing
Reliable payments provider with automatic, familiar invoicing and 1% of Sales to Stripe Climate.

### Mobile access
Manage your sync operations from your phone if you are traveling.

## Connect Apollo to Google BigQuery

Get started today with a 14-day free trial. No credit card required. Both human and AI support are available.

[Get started](https://app.flatly.io/signup) [Learn more →](/content/faq/index.html)