René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"How to use readonly transaction","articleBody":"I want to execute the query from a database in which my service account has no `beginOrRollbackReadWriteTransaction` permission, and I use this library with pandas via codes like here:\r\n\r\n```python\r\nfrom sqlalchemy import create_engine\r\nimport pandas as pd\r\n\r\nengine = create_engine( \"spanner:///projects/project_id/instances/instance_id/databases/demo\")\r\npd.read_sql(\"SELECT * from plans\", engine)\r\n```\r\n\r\nAnd I got a message returns: \"Caller is missing IAM permission spanner.databases.beginOrRollbackReadWriteTransaction on resource projects/project_id/instances/instance_id/databases/demo\"\r\n\r\nSo how to use this library to execute some read-only SQL? Because I want only a limited number of people to have write access","author":{"url":"https://github.com/wusendong","@type":"Person","name":"wusendong"},"datePublished":"2021-07-16T06:06:38.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":6},"url":"https://github.com/97/python-spanner-sqlalchemy/issues/97"}