I want to execute this statement using databricks SQL Statement Execution API.

curl -X POST 
    -H 'Authorization: Bearer <access-token>' 
    -H 'Content-Type: application/json' 
    -d '{"warehouse_id": "<warehouse_id>", 
     "statement": "set use_cached_result = false;select * from <schema_name>.<table_name> limit 100", 
     "catalog": "dspf_test", 
     "wait_timeout": "50s", 
     "on_wait_timeout": "CANCEL", 
     "disposition": "EXTERNAL_LINKS"
     }' 
https://<databricks-host>/api/2.0/sql/statements/
 
 
 
 

but getting this error:

How to use this "set use_cached_result = false" along with main query in single query statement using SQL Statement Execution API

SQL Statement Execution API Reference doc:

https://docs.databricks.com/api/workspace/statementexecution/executestatement