Add a Dataset and query data

Add a dataset and query it using SQL Query in the Playground

To add a dataset to the Spice app, navigate to the Code tab.

Use the Components sidebar on the right to select from available Data Connectors, Model Providers, and ready-to-use Datasets.

Adding a ready-to-use Dataset

1. Navigate to Code tab.

2. In Components sidebar, click the Datasets tab.

Spice.ai app Code configuration

1. Select and add the NYC Taxi Trips dataset

   1. Note the configuration has been added to the editor

Add the NYC Taxi Trips dataset

1. Click Save in the code toolbar and then Deploy on popup card that appears in the bottom right.

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.

Exexuting the sample query for the NYC Taxi Trips dataset.

[Optional] Execute a SQL query using cURL

Go app Settings and copy one of the app API Keys.

Getting an API Key from the app Settings.

Replace [API-KEY] in the sample below with your API Key and execute from a terminal.

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'

Showing results from executing a sample NYC Taxi Trips dataaset query using cURL.

🎉 Congratulations, you've now added a dataset and queried it.

Continue to Step 4 to add an AI Model and chat with the dataset.

Need help? Ask a question, raise issues, and provide feedback to the Spice AI team on Discord.