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!