Skip to main content

POST /v1/datasets/<name>/acceleration/refresh

Performs an on-demand refresh for an accelerated dataset. On-demand refresh applies only to full and append refresh modes (not changes).

Request Body:

  • refresh_sql (String, Optional): Refresh SQL to use, see Refresh SQL docs. Defaults to the refresh_sql specified in the spicepod.
  • refresh_mode (String, Optional): Refresh mode to use, see Refresh Modes docs. Defaults to refresh_mode specified in the spicepod.

Example:

curl -i -XPOST 127.0.0.1:8090/v1/datasets/taxi_trips/acceleration/refresh \
  -H "Content-Type: application/json" \
  -d '{
    "refresh_sql": "SELECT * FROM taxi_trips WHERE tip_amount > 10.0",
    "refresh_mode": "full"
  }'

Response:

HTTP/1.1 201 Created
content-type: application/json
content-length: 55
date: Thu, 11 Apr 2024 20:11:18 GMT

{"message":"Dataset refresh triggered for taxi_trips."}
Note

On-demand refresh always initiates a new refresh, terminating any in-progress refresh for the dataset.