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 project, navigate to Build > Code.

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 Build > Code.

2. In Components sidebar, click the Datasets tab.

3. Select and add the NYC Taxi Trips dataset

   1. Note the configuration has been added to the editor

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

5. 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.

[Optional] Execute a SQL query using cURL

1. Go to project Settings and copy one of the project API Keys.

2. 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'

🎉 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 Slack.