Hi all! Does anyone have experience with controlling BigQuery reservations (Flex slots) from Prefect? Any best practices to share? I'm especially wondering how to ensure slots are canceled after a run. My basic use case would be to lower our BQ costs on our dbt runs: 1. Purchase flex slots 2. Run dbt models 3. Cancel flex slots Thanks for your input!

This article shows how you can create reservations directly in Python (e.g. from a Prefect flow) and how you can delete those with a cleanup function. Perhaps you could use the cleanup function with a resource manager?

Thank you @Anna Geller the resource manager sounds promising!