# Pike data warehouse sync: BigQuery and Snowflake

> Pike integrates with Google BigQuery and Snowflake: data warehouse sync writes projects, phases, tasks, time entries, members, teams, customers, deals, invoices, expenses, allocations, and time off into a schema named `pike` every hour. Schema changes are additive, and a `pike_sync_log` table records each run.

Canonical URL: https://usepike.com/integrations/data-warehouse
Last updated: 2026-10-26

## At a glance

- **Destinations:** Google BigQuery, with a service account. Snowflake, with a key-pair user.
- **Who sets it up:** Workspace admins.
- **Schedule:** Every hour, into a schema named `pike`.
- **Plan:** Scale
- **Documentation:** [Data warehouse sync docs](https://usepike.com/docs/integrations/data-warehouse)

## What syncs between Data warehouse sync and Pike

| Area | Tables in the pike schema |
| --- | --- |
| Delivery | Projects, phases, tasks, allocations |
| Time and people | Time entries, members, teams, time off |
| Revenue and cost | Customers, deals, invoices, expenses |
| Sync history | `pike_sync_log`, one row per run |

Schema changes are additive: Pike adds tables and columns and does not drop them.

## How to connect Data warehouse sync

1. Go to **Workspace settings → Integrations → Data warehouse sync** and click **Add integration**.
2. Choose **BigQuery** and connect a service account, or **Snowflake** and connect a key-pair user.
3. Pike creates the `pike` schema and syncs every hour.

Full setup steps and field mappings are in the [Data warehouse sync integration docs](https://usepike.com/docs/integrations/data-warehouse).

## How agencies use Pike with Data warehouse sync

- **Model margin in SQL.** Join Pike time, cost, and invoices with your ERP and CRM tables to build one margin model.
- **Build on stable tables.** Additive schema changes keep existing queries and dashboards working when Pike adds fields.
- **Monitor freshness.** The `pike_sync_log` table records each run, so data teams alert on a missed sync.

## Limits to know before you connect

- Destinations are Google BigQuery and Snowflake.
- The sync runs every hour.
- Pike writes to the `pike` schema only.

## Data warehouse sync integration questions

### Can I sync Pike data to BigQuery?

Yes. Pike data warehouse sync writes Pike tables into a BigQuery schema named pike every hour, connected with a service account.

### Can I sync Pike data to Snowflake?

Yes. Pike data warehouse sync writes Pike tables into a Snowflake schema named pike every hour, connected with a key-pair user.

### Which Pike plan includes data warehouse sync?

Pike data warehouse sync is available on the Scale plan.

## Related

- [Power BI](https://usepike.com/integrations/power-bi): The Pike connector with scheduled refresh.
- [Looker Studio](https://usepike.com/integrations/looker-studio): The Pike partner connector.
- [Open API](https://usepike.com/integrations/open-api): Read Pike data from your own code.