Can't load plugin: sqlalchemy.dialects:cockroachdb - NoSuchModuleError in AWS Lambda function

[minjie0501]

Describe the problem

Getting "Can't load plugin: sqlalchemy.dialects:cockroachdb" error while trying to connect to a cockroachDB in an AWS lambda function using SQL Alchemy. I use the sqlalchemy-cockroachdb dialect and my connection string follows this structure: "cockroachdb://username:password@host:port/defaultdb". Locally everything works fine. I have psycopg2 installed based on https://github.com/jkehler/awslambda-psycopg2 .

Environment:
AWS Lambda
Runtime: Python 3.9
Architecture: arm64

[gordthompson]

Hi there. Have a look at the suggestion here

https://stackoverflow.com/q/68189528

and see if it helps.