Getting Started

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 --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. That completes the getting started guide. No AI model or model provider API key is required.

Continue to Next Steps.

If you have an OpenAI, Anthropic (Claude), or xAI (Grok) API key, optionally add an AI Model and chat with the dataset.