# Sync Attio to Google BigQuery

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

## Historical & Dynamic Data

## One-way Sync

## For Non-technical Users

[Connect Attio to Google BigQuery](https://app.flatly.io/signup) [Which Attio API does Flatly use?](https://developers.attio.com/docs)

## Source: Attio

Attio is a modern CRM and workspace platform built for teams to manage relationships, organize data, and drive workflows.

### Auth:
OAuth

### Available datasets

- Companies
- Companies-Last X Days
- Deals
- Deals-Last X Days
- Lists
- Records by List
- People
- People-Last X Days

## Destination: Google BigQuery

Looker reads tables from Google BigQuery.

### Auth:
Service Account

### Supported file formats

- NDJSON

## How it works

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

2. **Choose your datasets**  
   Pick which Attio 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 Attio 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.

### 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.

### 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.

### 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 Attio to Google BigQuery

Get started today with a 14-day free trial. No credit card required.