---
title: "Update Refresh SQL"
method: PATCH
path: "/v1/datasets/{name}/acceleration"
tags: ["Datasets"]
---

# Update Refresh SQL

`PATCH /v1/datasets/{name}/acceleration`

Update the refresh SQL for a dataset's acceleration.

This endpoint allows for updating the `refresh_sql` parameter for a dataset's acceleration at runtime.
The change is **temporary** and will revert to the `spicepod.yml` definition at the next runtime restart.

## Path parameters

- `name` string, required

## Request body

- AccelerationRequest
  - `refresh_sql` string, nullable — SQL statement used for the refresh. Defaults to current `refresh_sql` configured (either from the spicepod or a previous `refresh_sql` update).

## Response `200`

The refresh SQL was updated successfully.

## Other responses

- `404` — The specified dataset was not found
- `500` — An internal server error occurred while updating the refresh SQL

---

[API](https://skmtc.dev/spiceai/apis/runtime.md) · [All operations](https://skmtc.dev/spiceai/apis/runtime/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/spiceai/runtime/revisions/fb597a4eaa56/schema)