step 2 add dataset and query data.md

For the complete documentation index, see llms.txt. Markdown versions of documentation pages are available by appending .md to page URLs; this page is available as Markdown.

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.

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the ask query parameter, and the optional goal query parameter:

GET https://docs.spice.ai/getting-started/get-started/step-2-add-dataset-and-query-data.md?ask=<question>&goal=<endgoal>

ask is the immediate question: it should be specific, self-contained, and written in natural language. goal is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.