Can't load plugin: sqlalchemy.dialects:spanner

[antonio-cavallo]

Environment details

• python
• macos
• 3.11
• 1.6.2

Steps to reproduce

1. python -m venv env
   2.source env/bin/activate
2. pip install sqlalchemy-spanner
3. python -c "from sqlalchemy import create_engine; create_engine("spanner:/// ...

  File "/Users/sxope/Projects/learn.spanner/x/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py", line 368, in load
    raise exc.NoSuchModuleError(
sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:spanner

[pedrohml]

same here

[forksumit]

https://github.com/googleapis/python-spanner-sqlalchemy?tab=readme-ov-file#database-url
From version 1.4+ , you need spanner+spanner instead of just spanner in engine url.

Try updating the engine/database url and see if it works.