Step 2 - Add Dataset and query data

Connect first dataset

To configure your Spice app with a custom dataset, navigate to the Code tab. On the left, you can directly edit the current App Spicepod configuration. Use the right sidebar to select from available data connectors, model providers, and ready-to-use datasets.

Adding a sample dataset

1. Navigate to Code tab.

2. In Components sidebar, click Datasets tab.

Spice App Code configuration

1. Select NYC Taxi Trips dataset - that will add a new dataset in entry in configuration code.

Add NYC Taxi Trips dataset

1. Click Save in the code toolbar and then Deploy in the bottom popup.

1. Navigate to the Playground tab, open the dataset reference, and click on the spice.samples.taxi_trips dataset to insert a sample query into the SQL editor. Then, click Run Selection.

Execute a SQL query using cURL

Go app Settings and copy one of the API Keys. Learn more about App API Keys.

Replace [API-KEY] in the sample below with your API Key.

cURL

curl --request POST \
  --url 'https://data.spiceai.io/v1/sql' \
  --header 'Content-Type: text/plain' \
  --header 'X-API-KEY: [API-KEY]' \
  --data 'select * from spice.samples.taxi_trips limit 3'

Raise issues or feedback with our team on Discord.