Quick Comparison
| Method | Type | Best For |
|---|---|---|
| Snowflake | Push | Data warehousing, analytics |
| Cloud Storage | Push | S3, GCS, Azure pipelines |
| Webhooks | Push | Event-driven architectures |
| WebSockets | Push | Real-time dashboards |
| REST API | Pull | On-demand access |
| SDK | Pull | Application integration |
| CLI | Pull | Terminal & CI/CD pipelines |
| MCP Server | Pull | AI assistants (ChatGPT, Claude.ai, etc.) |
| Push | Alerts & notifications | |
| Google Sheets | Pull | Spreadsheet workflows |
| Slack | Push | Team notifications |
Push vs Pull
Push methods deliver data automatically when workflows complete:- Snowflake, Cloud Storage, Webhooks, WebSockets, Email, Slack
- REST API, SDK, CLI, MCP Server, Google Sheets
Data Warehouse Integration
For analytics and data warehousing, we recommend:Snowflake
Most popular choice. External Tables or Data Sharing.
Cloud Storage
S3, GCS, or Azure Blob for custom pipelines.
Event-Driven Integration
For real-time notifications and event-driven architectures:Webhooks
HTTP POST to your endpoint when events occur.
WebSockets
Real-time streaming for live dashboards.
Programmatic Access
For application integration:REST API
On-demand data retrieval with pagination.
SDK
Node.js and Python libraries.
CLI
Terminal workflows and CI/CD pipelines.
MCP Server
AI assistants — ChatGPT, Claude.ai, Claude Code, Cursor, and more.
Data Formats
Depending on the delivery method, data is available in:| Format | Available In |
|---|---|
| JSON | REST API, SDK, CLI, MCP, Webhooks, WebSockets |
| Parquet | Cloud Storage, Snowflake |
| JSONL | Cloud Storage |
| CSV | REST API, CLI, Cloud Storage |