I just found out about BigQuery short query optimized mode support. But can only find it on cloud console ?
How can I use it with python client
Couldn’t find it on web
This features seems to deliver faster query response for shorter queries. I need this as I am using it for a RAG and I need to optimize the query generated by SQL generator