Demonstrates the configuration of the maximum number of seconds a connection can persist when connecting to Cloud SQL for SQL Server using SQLAlchemy.

## Explore further


For detailed documentation that includes this code sample, see the following:

- [Manage database connections](https://docs.cloud.google.com/sql/docs/sqlserver/manage-connections.md.txt)

## Code sample

### Python


To authenticate to Cloud SQL for SQL Server, set up Application Default Credentials.
For more information, see

[Set up authentication for a local development environment](https://docs.cloud.google.com/docs/authentication/set-up-adc-local-dev-environment.md.txt).

```python
# 'pool_recycle' is the maximum number of seconds a connection can persist.
# Connections that live longer than the specified amount of time will be
# re-established
pool_recycle=1800,  # 30 minutes
```

## What's next


To search and filter code samples for other Google Cloud products, see the
[Google Cloud sample browser](https://docs.cloud.google.com/docs/samples.md.txt?product=cloudsqlforsqlserver).