sqlalchemy_spanner_quickstart_connect_and_query.py

1from sqlalchemy import create_engine
2from sqlalchemy import text
3
4# Connection string format:
5# spanner:///projects/<project>/instances/<instance>/databases/<database>
6# For example:
7# engine = create_engine("spanner:///projects/your-project-id/instances/your-instance-id/databases/your-database-id")
8
9engine = create_engine(
10    "spanner:///projects/project-id/instances/instance-id/databases/database-id"
11)
12
13with engine.connect() as connection:
14    result = connection.execute(text("SELECT 'Hello World'"))
15    for row in result:
16        print(row)