1---
2id: patch-dataset-acceleration
3title: "Update Refresh SQL"
4description: "Update the refresh SQL for a dataset's acceleration."
5sidebar_label: "Update Refresh SQL"
6hide_title: true
7hide_table_of_contents: true
8api: eJztVl1v2zYU/SvEfekWyLJTdMOmhwFZmqEDUqxzU+whNRxavLbYUqRCXtkxBP334VKSP2Iv2LDHzS+2xcvLw3MOj9gAyVWA7B7eSpIBKcAsAYUh97oi7Sxk8KlSklBQgcLj0mMoxMffb8XSeSGF6qa9CkLmORr0kmeln+1ne1foINCqymlLQhrjNiHOqrmhtqvY8qHvOQ+P5kFU0ssSCf2L7YUk4WtLusSU10GRF9KuUOggLi4Iy8p56bcXF0JaJTbaGOFxjZ4EuW7RUOkcK6fSbWkehMKltnrozAUWn3ZLCI+BpKe4KUjAVT2MXxVkUEnKi3mPc36IEhLYbYcpbsDKEiHrvhLQtptewHPGeUdcJNwyoum7M/rIHaaQgMfHWntUkJGvMYGQF1hKyBqgbcXLBPLarqBtZ10xBvrZqS1XnC7X9VVR2UCSsERLUYQDAK/C4AAGkDtLaIn7yaoyOo+7Hn8J3LQ5xeMWXzAnZsUzhaQx8OiB/vvi+wF9ArY25tSUxzjrgGoHdoAo3uJS1obCTvUjq4UKc73UqIS2cXjnCWjbBEiTYdRXB4pOOxahTQCfZFlxwbMNwMeb25vrO3Ehfpn+9l4gFXOPOVqaL4zLvwbxx7ub6Y2If+a2LhfoxU/icjKBllc9FjU+CJWzoaPq9WRyXr3Dc7mRYadmqPMcQ1jWxmxThv1m8uZ8hz0bg9m4j3XsgdqqfyP3fk/3UGIIcoWs57ELhoET+547G32x6EYWQ5R4DLWh4dD4QawDMd93E6c9qc+E3GEYwvCMfHtG2ijYd+ckubJCW0JvpREB/Rq9QO+dFy7Pa+9RiU2hDR4H4YGG/zG2+2MlllIbVKn4x/QdUJdGXdoESqTC7QI6ZjEVkMF4fTnuLR7GDadsO36W2t2aXWTXng91QVRl47FxuTSFC5T9MPlxckLWLQ8LhWs0roq51HVKxbWzS72qPYqNpkI8jEbc8SEFzuaAee01beN6stLzr8i/ZzzGek/32X3zV6kzZD2/VZYu6tqL0L/EziobE0+JfYnRObJS2e5ddVXJvMDR65S3qxVa4pTwxyNtAkxY1/gy/T6djGobSC5MFL1ygUppD7r2V4rpkeWP8DX7E/D/BeTZBaQ/soRPNK6M1JZJjkZtepffw/qSGR3udAlk/aXjyOqzBNjNXN80Cxnwkzdty48fa/TRhAmspddRSban0oF/K8iW0gR8QbRvpn0QfSv+1nXm7Kb6h9JugYGYmv9BAvGEdGZqZ20CBUrFprxv+qHrDsfojhvsp55EaZsMM/g9X9GLtbODVPlwdXf9DhJY9Deq0ql42uSGM1huOpwuEtNdc/hZA0baVd3FXteUP38CIsoNCg==
9sidebar_class_name: "patch api-method"
10info_path: docs/api/HTTP/runtime
11custom_edit_url: null
12proxy: http://localhost:8090
13---
14
15import MethodEndpoint from "@theme/ApiExplorer/MethodEndpoint";
16import ParamsDetails from "@theme/ParamsDetails";
17import RequestSchema from "@theme/RequestSchema";
18import StatusCodes from "@theme/StatusCodes";
19import OperationTabs from "@theme/OperationTabs";
20import TabItem from "@theme/TabItem";
21import Heading from "@theme/Heading";
22
23<Heading
24 as={"h1"}
25 className={"openapi__heading"}
26 children={"Update Refresh SQL"}
27>
28</Heading>
29
30<MethodEndpoint
31 method={"patch"}
32 path={"/v1/datasets/{name}/acceleration"}
33 context={"endpoint"}
34>
35
36</MethodEndpoint>
37
38
39
40Update the refresh SQL for a dataset's acceleration.
41
42This endpoint allows for updating the `refresh_sql` parameter for a dataset's acceleration at runtime.
43The change is **temporary** and will revert to the `spicepod.yml` definition at the next runtime restart.
44
45
46
47<Heading
48 id={"request"}
49 as={"h2"}
50 className={"openapi-tabs__heading"}
51 children={"Request"}
52>
53</Heading>
54
55<ParamsDetails
56 parameters={[{"name":"name","in":"path","description":"The name of the dataset to update.","required":true,"schema":{"type":"string"}}]}
57>
58
59</ParamsDetails>
60
61<RequestSchema
62 title={"Body"}
63 body={{"description":"The updated SQL statement for the dataset's refresh.","content":{"application/json":{"schema":{"type":"object","properties":{"refresh_sql":{"type":["string","null"],"description":"SQL statement used for the refresh. Defaults to the `refresh_sql` specified in the spicepod."}},"title":"AccelerationRequest"},"example":{"refresh_sql":"SELECT * FROM eth_recent_blocks WHERE block_number > 100"}}},"required":true}}
64>
65
66</RequestSchema>
67
68<StatusCodes
69 id={undefined}
70 label={undefined}
71 responses={{"200":{"description":"The refresh SQL was updated successfully."},"404":{"description":"The specified dataset was not found","content":{"application/json":{"schema":{"type":"object","required":["message"],"properties":{"message":{"type":"string","description":"The message describing the result of the request"}},"title":"MessageResponse"},"example":{"message":"Dataset eth_recent_blocks not found"}}}},"500":{"description":"An internal server error occurred while updating the refresh SQL","content":{"application/json":{"schema":{"type":"object","required":["message"],"properties":{"message":{"type":"string","description":"The message describing the result of the request"}},"title":"MessageResponse"},"example":{"message":"Request failed. An internal server error occurred while updating refresh SQL."}}}}}}
72>
73
74</StatusCodes>
75
76
77
1---
2id: patch-dataset-acceleration
3title: "Update Refresh SQL"
4description: "Update the refresh SQL for a dataset's acceleration."
5sidebar_label: "Update Refresh SQL"
6hide_title: true
7hide_table_of_contents: true
8api: eJztVl1v2zYU/SvEfekWyLJTdMOmhwFZmqEDUqxzU+whNRxavLbYUqRCXtkxBP334VKSP2Iv2LDHzS+2xcvLw3MOj9gAyVWA7B7eSpIBKcAsAYUh97oi7Sxk8KlSklBQgcLj0mMoxMffb8XSeSGF6qa9CkLmORr0kmeln+1ne1foINCqymlLQhrjNiHOqrmhtqvY8qHvOQ+P5kFU0ssSCf2L7YUk4WtLusSU10GRF9KuUOggLi4Iy8p56bcXF0JaJTbaGOFxjZ4EuW7RUOkcK6fSbWkehMKltnrozAUWn3ZLCI+BpKe4KUjAVT2MXxVkUEnKi3mPc36IEhLYbYcpbsDKEiHrvhLQtptewHPGeUdcJNwyoum7M/rIHaaQgMfHWntUkJGvMYGQF1hKyBqgbcXLBPLarqBtZ10xBvrZqS1XnC7X9VVR2UCSsERLUYQDAK/C4AAGkDtLaIn7yaoyOo+7Hn8J3LQ5xeMWXzAnZsUzhaQx8OiB/vvi+wF9ArY25tSUxzjrgGoHdoAo3uJS1obCTvUjq4UKc73UqIS2cXjnCWjbBEiTYdRXB4pOOxahTQCfZFlxwbMNwMeb25vrO3Ehfpn+9l4gFXOPOVqaL4zLvwbxx7ub6Y2If+a2LhfoxU/icjKBllc9FjU+CJWzoaPq9WRyXr3Dc7mRYadmqPMcQ1jWxmxThv1m8uZ8hz0bg9m4j3XsgdqqfyP3fk/3UGIIcoWs57ELhoET+547G32x6EYWQ5R4DLWh4dD4QawDMd93E6c9qc+E3GEYwvCMfHtG2ijYd+ckubJCW0JvpREB/Rq9QO+dFy7Pa+9RiU2hDR4H4YGG/zG2+2MlllIbVKn4x/QdUJdGXdoESqTC7QI6ZjEVkMF4fTnuLR7GDadsO36W2t2aXWTXng91QVRl47FxuTSFC5T9MPlxckLWLQ8LhWs0roq51HVKxbWzS72qPYqNpkI8jEbc8SEFzuaAee01beN6stLzr8i/ZzzGek/32X3zV6kzZD2/VZYu6tqL0L/EziobE0+JfYnRObJS2e5ddVXJvMDR65S3qxVa4pTwxyNtAkxY1/gy/T6djGobSC5MFL1ygUppD7r2V4rpkeWP8DX7E/D/BeTZBaQ/soRPNK6M1JZJjkZtepffw/qSGR3udAlk/aXjyOqzBNjNXN80Cxnwkzdty48fa/TRhAmspddRSban0oF/K8iW0gR8QbRvpn0QfSv+1nXm7Kb6h9JugYGYmv9BAvGEdGZqZ20CBUrFprxv+qHrDsfojhvsp55EaZsMM/g9X9GLtbODVPlwdXf9DhJY9Deq0ql42uSGM1huOpwuEtNdc/hZA0baVd3FXteUP38CIsoNCg==
9sidebar_class_name: "patch api-method"
10info_path: docs/api/HTTP/runtime
11custom_edit_url: null
12proxy: http://localhost:8090
13---
14
15import MethodEndpoint from "@theme/ApiExplorer/MethodEndpoint";
16import ParamsDetails from "@theme/ParamsDetails";
17import RequestSchema from "@theme/RequestSchema";
18import StatusCodes from "@theme/StatusCodes";
19import OperationTabs from "@theme/OperationTabs";
20import TabItem from "@theme/TabItem";
21import Heading from "@theme/Heading";
22
23<Heading
24 as={"h1"}
25 className={"openapi__heading"}
26 children={"Update Refresh SQL"}
27>
28</Heading>
29
30<MethodEndpoint
31 method={"patch"}
32 path={"/v1/datasets/{name}/acceleration"}
33 context={"endpoint"}
34>
35
36</MethodEndpoint>
37
38
39
40Update the refresh SQL for a dataset's acceleration.
41
42This endpoint allows for updating the `refresh_sql` parameter for a dataset's acceleration at runtime.
43The change is **temporary** and will revert to the `spicepod.yml` definition at the next runtime restart.
44
45
46
47<Heading
48 id={"request"}
49 as={"h2"}
50 className={"openapi-tabs__heading"}
51 children={"Request"}
52>
53</Heading>
54
55<ParamsDetails
56 parameters={[{"name":"name","in":"path","description":"The name of the dataset to update.","required":true,"schema":{"type":"string"}}]}
57>
58
59</ParamsDetails>
60
61<RequestSchema
62 title={"Body"}
63 body={{"description":"The updated SQL statement for the dataset's refresh.","content":{"application/json":{"schema":{"type":"object","properties":{"refresh_sql":{"type":["string","null"],"description":"SQL statement used for the refresh. Defaults to the `refresh_sql` specified in the spicepod."}},"title":"AccelerationRequest"},"example":{"refresh_sql":"SELECT * FROM eth_recent_blocks WHERE block_number > 100"}}},"required":true}}
64>
65
66</RequestSchema>
67
68<StatusCodes
69 id={undefined}
70 label={undefined}
71 responses={{"200":{"description":"The refresh SQL was updated successfully."},"404":{"description":"The specified dataset was not found","content":{"application/json":{"schema":{"type":"object","required":["message"],"properties":{"message":{"type":"string","description":"The message describing the result of the request"}},"title":"MessageResponse"},"example":{"message":"Dataset eth_recent_blocks not found"}}}},"500":{"description":"An internal server error occurred while updating the refresh SQL","content":{"application/json":{"schema":{"type":"object","required":["message"],"properties":{"message":{"type":"string","description":"The message describing the result of the request"}},"title":"MessageResponse"},"example":{"message":"Request failed. An internal server error occurred while updating refresh SQL."}}}}}}
72>
73
74</StatusCodes>
75
76
77