| description | Add an OpenAI model and chat with the NYC Taxi Trips dataset |
|---|---|
| icon | circle-4 |
{% hint style="info" %} An OpenAI API Platform account and API key is required. {% endhint %}
- Navigate to Build > Code.
- In Components sidebar, click Model Providers tab, and select OpenAI.
- Enter the Model name.
- Enter the Model ID, (e.g.
gpt-4o). - Set the OpenAI API Key secret
- API keys and other secrets are securely stored and encrypted.
- Insert
tools: autoin theparamssection of thegpt-4oModel to automatically connect datasets to the model.
The final Spicepod configuration in the editor should be as follows:
name: my-first-app
kind: Spicepod
version: v1beta1
datasets:
- from: s3://spiceai-demo-datasets/taxi_trips/2024/
name: samples.taxi_trips
description: Taxi trips dataset from Spice.ai demo datasets.
params:
file_format: parquet
models:
- from: openai:gpt-4o
name: gpt-4o
params:
endpoint: https://api.openai.com/v1
openai_api_key: ${secrets:OPENAI_API_KEY}
tools: auto- Click Save in the code toolbar and then Deploy in the popup card that appears in the bottom right to deploy the changes.
- Navigate to Playground and select AI Chat in the sidebar.
- Ask a question about the NYC Taxi Trips dataset in the chat. For example:
- "What datasets are available?"
- "What is the average fare amount of a taxi trip?"
- Replace
[API-KEY]in the sample below with the project API Key and execute in a terminal.
{% tabs %} {% tab title="cURL" %}
curl --request POST \
--url 'https://data.spiceai.io/v1/chat/completions' \
--header 'Content-Type: application/json' \
--header 'X-API-KEY: 31393037|8f2f6125e7b8487f80964041c123d3c3' \
--data '{ "messages": [{ "role": "user", "content": "Hello!" }], "model": "gpt-4o" }'{% endtab %} {% endtabs %}
馃帀 Congratulations, you've now added an OpenAI model and can use it to ask questions of the NYC Taxi Trips dataset.
Continue to Next Steps to explore use-cases to do more with the Spice.ai Cloud Platform.
{% hint style="info" %} Need help? Ask a question, raise issues, and provide feedback to the Spice AI team on Slack. {% endhint %}