CODEWITHSUNDEEP
pythonsslsqlalchemypsycopg2
Sarang Manjrekar
Sarang Manjrekar

Reputation: 1991

(psycopg2.OperationalError) SSL error: certificate verify failed

I am trying to use Sqlalchemy package to be able to connect to Redshift datawarehouse. 

from sqlalchemy import create_engine
import psycopg2


red_engine=create_engine('redshift+psycopg2://admin:XXXXXXXXX@IP:PORT/DBNAME')

test = pd.read_sql_query(query,red_engine)

Error message I get is :

OperationalError: (psycopg2.OperationalError) SSL error: certificate verify failed

I am unable to see why this SSL veirifcation is falling all, used to go smoothly earlier.

Upvotes: 2

Views: 4453

Answers (1)

GHunt
GHunt

Reputation: 11

I encountered the same error. I updated the sqlalchemy-redshift package to the latest, 0.7.0, which updates the certificates used to connect to Redshift.

To update, use pip install -U sqlalchemy-redshift.

Upvotes: 1

Related Questions