Deliver scheduled reports to spreadsheets, BI tools, signed webhooks, AI assistants, or your own data warehouse—and choose between managed Data Vault history in Datapipe or your own infrastructure.
API-only warehouses (no OAuth) · Live Excel & Power BI feeds · Optional 1–5 year Data Vault
Configure warehouse destinations once on a report and save them to your project for reuse, or send reports to spreadsheets, BI tools, webhooks, and AI without warehouse setup.
Google Sheets
Excel
Power BI
Data Studio
Google Drive
WebhooksBigQueryProClickHouseProAWS S3ProAmazon RedshiftProFireboltProPostgreSQLProMySQLProSnowflakeProDatabricks SQLProCloudflare R2Pro
Claude
ChatGPTKeep historical snapshots inside Datapipe, push rows out to your own warehouse, or use both together.
New projects default to Live data, or you can enable 90-day Saved history at no extra cost. Add Data Vault per project to keep 1 year ($7/project/month) or up to 5 years ($35/project/month) inside Datapipe, with daily CSV and Parquet backups to Google Drive.
Push fresh report rows directly into ClickHouse, AWS S3, Amazon Redshift, Firebolt, PostgreSQL, MySQL, or BigQuery on every scheduled refresh using API keys, IAM keys, or database credentials.
Send live data straight into Google Sheets, Excel (.iqy), Power BI (.pbids), Looker Studio templates, Google Drive, or CSV and JSON downloads with zero warehouse setup.
Trigger downstream pipelines with HMAC-signed webhooks, query reports via scoped Project API keys (/api/v1), or connect Claude and ChatGPT for read-only analysis.
Start free with 3 data sources across unlimited projects, then add Data Vault or connect your own warehouse as you grow.
Reviewed by Datapipe · 2026-11-03 · Cancel anytime
Questions before you start
How warehouse delivery, project reuse, spreadsheets, and Data Vault retention work.
ClickHouse, AWS S3, Amazon Redshift (Data API), Firebolt, PostgreSQL, and MySQL all connect directly with API keys, IAM access keys, service account secrets, or database credentials—no OAuth browser consent required.
Data Vault is optional managed history stored inside Datapipe (1 year for $7/project/month or up to 5 years for $35/project/month, alongside the included 90-day Saved history option). Your own data warehouse (ClickHouse, AWS S3, Redshift, Firebolt, PostgreSQL, MySQL, or BigQuery on Pro and Agency) receives fresh report rows directly in your own infrastructure on every refresh.
Open any report in your project and expand Data warehouses. Pick your warehouse, enter your endpoint or host and credentials, and Datapipe tests the connection before saving it encrypted for future scheduled refreshes.
No. Data Studio templates read from Datapipe's Data Studio and Google Sheets export path directly—you only connect a data warehouse when you want report rows pushed into your own warehouse or S3 bucket.
Still unsure? Contact us.