Pike
  • Pricing
  • Contact us
Log in
  1. Home/
  2. Features/
  3. Integrations/
  4. Data warehouse sync
BigQuerySnowflake

Pike and
your data warehouse

Sync projects, time, and invoices to BigQuery or Snowflake every hour.

Contact sales
The pike schema in BigQuery with Pike tables and the pike_sync_log table showing an hourly run that completed

At a glance

Destinations
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

AreaTables in the pike schema
DeliveryProjects, phases, tasks, allocations
Time and peopleTime entries, members, teams, time off
Revenue and costCustomers, 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.

Set up and use Data warehouse sync

Connect

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

How to use it in your business

  • Model margin in SQL. Join Pike time, cost, and invoices with your ERP and CRM tables to build one margin model.
  • Monitor freshness. The `pike_sync_log` table records each run, so data teams alert on a missed sync.

Limits

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

Setup steps and field mappings: Data warehouse sync docs.

Data warehouse sync integration questions

Related

  • Power BIProjects, time entries, invoices, and expenses.
  • Looker StudioProjects, time entries, invoices, and capacity.
  • Open APIProjects, tasks, customers, and members.

See Pike and Data warehouse sync working together on your data.

Contact sales
  • ISO 27001 CertifiedISO 27001
  • GDPR CompliantGDPR
  • AICPA SOC 2 Type IISOC 2 Type II

Built to keep sensitive client data secure and private.

Pike box logoPike
Features
ProjectsResourcing & capacityFinance & invoicingDashboardsCustomers & salesTime & absencePike MCPIntegrations
Company
EnterpriseBlogOur storySwitch playbookMigration guideGet in touch
Industries
Creative agenciesMarketing agenciesDigital agenciesConsulting firmsIT consultanciesArchitecture firms
Resources
DocsChangelogPrivacy policyTerms and conditionsGlossaryFree toolsFAQ
All systems operational

Engineered around the 🌎

© 2026 Pike. All rights reserved.