step 2 add dataset and query data.md

Add a Dataset and query data

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.
  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 app Settings and copy one of the app API Keys.
  2. Replace [API-KEY] in the sample below with your API Key and execute from a terminal.

{% tabs %} {% tab title="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'

{% endtab %} {% endtabs %}

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

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