Reporting and data integration
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.
Last updated · Read as Markdown
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
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.
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.
See Pike and Data warehouse sync working together on your data.
ISO 27001
GDPR
SOC 2 Type II
Built to keep sensitive client data secure and private.