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/SvEfWkbKLITdMCmhwFZmqEDUmxzU+whDRxavLbYUiRLXtkxDP334VKSP2Iv2LDHzS+2xcvDw3sOj7gBkosIxT28kyQjUoSHDBTGMmhP2lko4JNXklBQhSLgPGCsxMffb8XcBSGF6qa9ikKWJRoMkmfln+1ne1fpKNAq77QlIY1xq5hmNQyo7SJBPvaY0/jNPAovg6yRMLwILySJ0FjSNea8DoqyknaBQkdxdkZYexdkWJ+dCWmVWGljRMAlBhLkukWj1yV6p/J1bR6Fwrm2ekDmAotP2yVEwEgyUA4ZON9T+EVBAV5SWU17jtN9hpDBdivc3g1YWSMU3VcG2nbTK3jebd4NFwk3T0x6dGae+oZMI+C3RgdUUFBoMINYVlhLKDZAa8/LRAraLqBtH7pijPSTU2uuOF6uw1VJ1UiSsEZLSYA9Aq/ioD4TKJ0ltMR40nujy7Tr0ZfIoJtjPm72BUvirgRuIWmMPLqn/a74fmCfgW2MOTbkIc8motqSHSiKdziXjaHIfSubELjy0Gqls3O9aAIq8Ro1Vey54OoEM9hDJBP6gEvtmvgMoGvbmxzaNgPSZHijV3smmHSNhzYDfJK154Jne4aPN7c313fiTPw8+fWDQKqmAUu0NJ0ZV36N4o/3N5Mbkf5MbVPPMIgfxcV4DC2veuiD9CB6Z2PX3cvx+LTg+8d4JePWALEpS4xx3hizzpn22/Hb0wjRY6nnGtXWn4xjHdumserfOGS3p3uoMUa5QLbAoXGGgSPHnzpOfbHoRmZD8gSMjaHhnIVBrD0xP3QTJ31Tnwm55TBk5wn5dh1pk2DfnZLkygptCYOVRkQMSwwCQ3BBuDJZV4lVpQ0e5uaehv+xbvfHSsylNqhy8Y/bt9e6POnSZlAjVW6b6Sm+qYICRsuLUW/xONpwMLejZ0HfrdmlfBP4UFdEvhiNjCulqVyk4vvxD+OjZt3ysFC4RON8irIOKRfXQzSJlaZKPJ6fM+JjDhznEcsmaFqn9aTX06/Ivx94jPWe7OL+5q9SZ3g98Ito7pKuvQj9O++ksikVldiVGF0iK1VsX29XXpYVnl/mvF2t0BKnRDgcaTPghnXAl/k4H583NpKcmSS6d5FqafdQ+xvI5MDyB/w2uxPw/31l777SH1fCJxp5I7XlBieTbnqH38Pygrs5XP8yKPo7yoHNHzJgJ3P9ZjOTET8F07b8+FuDIRkwg6UMOqnI1lQ68m8FxVyaiC8I9nrSh9Ab8bduPyc31T+Udg1MxDT8DzJIp6MzUvvQZlChVGzI+00/dN3xOL9jgN3Uoxhts2EGv+M9vVj7sJcov13dXb+HDGb9Bax2Kp00ueL8lauOp0uN6W5F/GwDRtpF00VeB8qfPwECJx0o
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";
22import Translate from "@docusaurus/Translate";
23
24<Heading
25  as={"h1"}
26  className={"openapi__heading"}
27  children={"Update Refresh SQL"}
28>
29</Heading>
30
31<MethodEndpoint
32  method={"patch"}
33  path={"/v1/datasets/{name}/acceleration"}
34  context={"endpoint"}
35>
36  
37</MethodEndpoint>
38
39
40
41Update the refresh SQL for a dataset's acceleration.
42
43This endpoint allows for updating the `refresh_sql` parameter for a dataset's acceleration at runtime.
44The change is **temporary** and will revert to the `spicepod.yml` definition at the next runtime restart.
45
46<Heading
47  id={"request"}
48  as={"h2"}
49  className={"openapi-tabs__heading"}
50>
51  <Translate id="theme.openapi.request.title">Request</Translate>
52</Heading>
53
54<ParamsDetails
55  {...require("./patch-dataset-acceleration.ParamsDetails.json")}
56>
57  
58</ParamsDetails>
59
60<RequestSchema
61  {...require("./patch-dataset-acceleration.RequestSchema.json")}
62>
63  
64</RequestSchema>
65
66<StatusCodes
67  {...require("./patch-dataset-acceleration.StatusCodes.json")}
68>
69  
70</StatusCodes>
71
72
73      

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/SvEfWkbKLITdMCmhwFZmqEDUmxzU+whDRxavLbYUiRLXtkxDP334VKSP2Iv2LDHzS+2xcvDw3sOj7gBkosIxT28kyQjUoSHDBTGMmhP2lko4JNXklBQhSLgPGCsxMffb8XcBSGF6qa9ikKWJRoMkmfln+1ne1fpKNAq77QlIY1xq5hmNQyo7SJBPvaY0/jNPAovg6yRMLwILySJ0FjSNea8DoqyknaBQkdxdkZYexdkWJ+dCWmVWGljRMAlBhLkukWj1yV6p/J1bR6Fwrm2ekDmAotP2yVEwEgyUA4ZON9T+EVBAV5SWU17jtN9hpDBdivc3g1YWSMU3VcG2nbTK3jebd4NFwk3T0x6dGae+oZMI+C3RgdUUFBoMINYVlhLKDZAa8/LRAraLqBtH7pijPSTU2uuOF6uw1VJ1UiSsEZLSYA9Aq/ioD4TKJ0ltMR40nujy7Tr0ZfIoJtjPm72BUvirgRuIWmMPLqn/a74fmCfgW2MOTbkIc8motqSHSiKdziXjaHIfSubELjy0Gqls3O9aAIq8Ro1Vey54OoEM9hDJBP6gEvtmvgMoGvbmxzaNgPSZHijV3smmHSNhzYDfJK154Jne4aPN7c313fiTPw8+fWDQKqmAUu0NJ0ZV36N4o/3N5Mbkf5MbVPPMIgfxcV4DC2veuiD9CB6Z2PX3cvx+LTg+8d4JePWALEpS4xx3hizzpn22/Hb0wjRY6nnGtXWn4xjHdumserfOGS3p3uoMUa5QLbAoXGGgSPHnzpOfbHoRmZD8gSMjaHhnIVBrD0xP3QTJ31Tnwm55TBk5wn5dh1pk2DfnZLkygptCYOVRkQMSwwCQ3BBuDJZV4lVpQ0e5uaehv+xbvfHSsylNqhy8Y/bt9e6POnSZlAjVW6b6Sm+qYICRsuLUW/xONpwMLejZ0HfrdmlfBP4UFdEvhiNjCulqVyk4vvxD+OjZt3ysFC4RON8irIOKRfXQzSJlaZKPJ6fM+JjDhznEcsmaFqn9aTX06/Ivx94jPWe7OL+5q9SZ3g98Ito7pKuvQj9O++ksikVldiVGF0iK1VsX29XXpYVnl/mvF2t0BKnRDgcaTPghnXAl/k4H583NpKcmSS6d5FqafdQ+xvI5MDyB/w2uxPw/31l777SH1fCJxp5I7XlBieTbnqH38Pygrs5XP8yKPo7yoHNHzJgJ3P9ZjOTET8F07b8+FuDIRkwg6UMOqnI1lQ68m8FxVyaiC8I9nrSh9Ab8bduPyc31T+Udg1MxDT8DzJIp6MzUvvQZlChVGzI+00/dN3xOL9jgN3Uoxhts2EGv+M9vVj7sJcov13dXb+HDGb9Bax2Kp00ueL8lauOp0uN6W5F/GwDRtpF00VeB8qfPwECJx0o
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";
22import Translate from "@docusaurus/Translate";
23
24<Heading
25  as={"h1"}
26  className={"openapi__heading"}
27  children={"Update Refresh SQL"}
28>
29</Heading>
30
31<MethodEndpoint
32  method={"patch"}
33  path={"/v1/datasets/{name}/acceleration"}
34  context={"endpoint"}
35>
36  
37</MethodEndpoint>
38
39
40
41Update the refresh SQL for a dataset's acceleration.
42
43This endpoint allows for updating the `refresh_sql` parameter for a dataset's acceleration at runtime.
44The change is **temporary** and will revert to the `spicepod.yml` definition at the next runtime restart.
45
46<Heading
47  id={"request"}
48  as={"h2"}
49  className={"openapi-tabs__heading"}
50>
51  <Translate id="theme.openapi.request.title">Request</Translate>
52</Heading>
53
54<ParamsDetails
55  {...require("./patch-dataset-acceleration.ParamsDetails.json")}
56>
57  
58</ParamsDetails>
59
60<RequestSchema
61  {...require("./patch-dataset-acceleration.RequestSchema.json")}
62>
63  
64</RequestSchema>
65
66<StatusCodes
67  {...require("./patch-dataset-acceleration.StatusCodes.json")}
68>
69  
70</StatusCodes>
71
72
73