google_cloud_spanner_quickstart_connect_and_query.py

1# Import the Google Cloud client library
2from google.cloud import spanner
3
4def run_quickstart():
5    # Instantiate a client
6    spanner_client = spanner.Client()
7
8    # Your Cloud Spanner instance ID
9    instance_id = "your-instance-id"
10
11    # Your Cloud Spanner database ID
12    database_id = "your-database-id"
13
14    # Get a Cloud Spanner instance by ID
15    instance = spanner_client.instance(instance_id)
16
17    # Get a Cloud Spanner database by ID
18    database = instance.database(database_id)
19
20    # Execute a simple query
21    with database.snapshot() as snapshot:
22        results = snapshot.execute_sql("SELECT 1")
23
24        for row in results:
25            print(row)
26
27if __name__ == "__main__":
28    run_quickstart()