Hi Simon
 
If you are using table API, you could set state backend via environment like `env.setStateBackend()`
 
If you just launch a cluster with SQL-client, you could configure state backend and checkpoint options [1] within `flink-conf.yaml` before launching the cluster .
 
[1] 
https://ci.apache.org/projects/flink/flink-docs-stable/ops/config.html#checkpointing
 
Best
Yun Tang
 
Does current Flink support to set checkpoint properties while using Flink SQL ? 
 
For example,  statebackend choices, checkpoint interval and so on ...