Set connection pool and overflow limits when using SQLAlchemy

Demonstrates the configuration of a connection pool size and overflow when connecting to Cloud SQL for SQL Server using SQLAlchemy.

Explore further

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

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. 

# Pool size is the maximum number of permanent connections to keep.
pool_size=5,
# Temporarily exceeds the set pool_size if no connections are available.
max_overflow=2,
# The total number of concurrent connections for your application will be
# a total of pool_size and max_overflow.

What's next

To search and filter code samples for other Google Cloud products, see the Google Cloud sample browser.