title: "refresh" sidebar_label: "refresh" pagination_prev: null pagination_next: null

Refreshes an accelerated dataset loaded by the Spice runtime

Usage

spice refresh [dataset] [flags]

spice refresh [dataset] [flags]

dataset - an accelerated dataset name

Flags

• --tls-root-certificate-file The path to the root certificate file used to verify the Spice.ai runtime server certificate
• --refresh-sql SQL used to refresh the dataset, see Refresh SQL docs (opens in a new tab).
• --refresh-mode Refresh mode to use, see Refresh Modes docs (opens in a new tab).
• --refresh-jitter-max Maximum jitter (opens in a new tab) applied to the refresh, as a duration (opens in a new tab) (e.g. 1m).
• -o, --output <format> Output format: table (default) or json.
• -h, --help Print this help message

Examples

>>> spice refresh taxi_trips --refresh-sql "SELECT * FROM taxi_trips WHERE trip_amount > 10.0"

>>> spice refresh taxi_trips --refresh-sql "SELECT * FROM taxi_trips WHERE trip_amount > 10.0"

Refreshing dataset taxi_trips ... Dataset refresh triggered for taxi_trips.

Additional Example

>>> spice refresh taxi_trips --refresh-mode append

>>> spice refresh taxi_trips --refresh-mode append

Refreshing dataset taxi_trips with append mode... Dataset refresh triggered for taxi_trips.