Home
Documentation
Start typing to search…

Data Export Quickstart

Learn how to export data from ZettaBlock for offline usage, including analysis, backup, or integration into external systems.

Currently, you can export data in the following ways:

  • via a CSV file download
  • via Analytics API (if CSV download is too manual)
  • via GraphQL API (to surface into your own dApp)
  • via an ETL pipeline
  • via webhooks (coming soon)
  • via Kafka Streams (coming soon)
  • by connecting to the Data Lake via a Jupyter Notebook (doc).

Option

Limit

Summary

Common Use Case

CSV Download

5MB/ query

Click the download button after executing the SQL query.

Download SQL query results into CSV within the UI.

Analytics API

  • 1 concurrent call (Free and Build),
  • 10+ concurrent calls (Enterprise),
  • 10MB download / day (Free),
  • 1GB download/day (Build),
  • custom (Enterprise)
  1. Create from any SQL input.
  2. Access through GraphQL.
  3. Export data in any format.

Get data from ad-hoc queries:
• Exploratory use cases
• When tables don’t update often, usually metadata info.

Transactional/ GraphQL API

  • 1 call / sec (Free),
  • 5 calls / sec (Build),
  • custom like 1k calls / sec (Enterprise)
  1. Serve as GraphQL API.
  2. Build your own API with desired transformation logic.

Serve data streams to dApps/ apps directly, in need of low latency (10ms) support.

ETL pipeline*

No

  1. ZettaBlock managed ELT pipelines (integrity & uptime guaranteed).
  2. Self-serve ELT connectors (users provide DB credentials).
  3. Can export to BigQuery, Snowflake, S3, Databricks, MongoDB, Postgres, and other popular databases and warehouses.

The default choice for the analytics use case.
• E.g., ingest new Polygon transactions every 24 hours.

*To discuss the option of exporting data via ETL Pipeline, contact our team directly.

CSV Download

To download a CSV file of your query results, simply navigate to this panel:

Updated about 1 month ago