Transform

🚧

Closed Beta

Transform is available in closed beta and currently used by some of our enterprise customers.

Please sign up at chainbase.com and fill in the form if your project needs access to real-time blockchain data.

SQL

Chainbase uses SQL to transform blockchain data in real-time, which should feel familiar to anyone who has used relational database systems—Joins, aggregations, group by, etc.

The primary differences you'll notice are that:

  • A pipeline must be deployed to process data.
  • Unlike relational databases, all pipelines write their results someplace. Chainbase Bridges help you integrate the output of pipelines into your environment.
  • Certain operations - notably JOINs and aggregations - must include windows.

Data Sources

Data sources of pipelines are streams. You can think of a stream like a database table. A stream's records are like a table's rows, and its fields are like a table's columns.

Chainbase uses datasets to organize data sources. Every transaction that can be used to transform is categorized as an event, such as swap, lend, or bridge, and is enriched with contextual data.

Quickstart Guide

First, click the Create Pipeline button on the top right of the pipeline page. Then you will be brought to the pipeline editor page.

Here, you’ll be presented with a window with three panes. The upper right pane is a text box where you can edit your transform SQL. The lower right pane gives you access to Pipeline’s preview feature that gives you real-time visibility into the contents of your streams and lets you quickly iterate on pipeline designs.

Click Run Preview to preview your new pipeline. Your results should appear in under a minute: