Links

Datasets and Views

Datasets and Views (Beta)
Self-managed Datasets and Views is in beta for Design Partners. Get in touch for more info.
The Spice.xyz platform comes pre-loaded with a variety of web3 datasets.
In addition, you can define and create your own private Datasets and Views, which can then be queried with SQL, cached in Spice Firecache, and published publicly to be shared with others.

Defining a Dataset

To define a dataset, first ensure your Spice app is connected to a GitHub repository, then add a dataset manifest file to the GitHub repository in the .spice/datasets path.
For example:
# .spice/datasets/recent_blocks.yml
name: eth.recent_blocks
type: append
firecache:
enabled: true
trigger: number
time_column: timestamp
See the Dataset & View YAML Specification for the full YAML schema.

Sync with GitHub

Once the manifest file is committed to the GitHub repository, navigate to the Datasets section of the Hub, and click Sync with GitHub. The newly defined dataset will appear in the datasets list.
List of synced Datasets in the Hub.

Deploy the Dataset

Click the dataset Deploy button. Because this dataset was Firecache enabled, the firecache status will now turn to Ready.
Deployed dataset eth.recent_blocks is now firecache Ready.

View Dataset details

Clicking the dataset will show its details along with it's deployments.
Dataset details page.