earlyspot.blogg.se

Q1) Am I missing some steps to configure? Please do suggest if any other way is available to connect cluster with python/drivers Is the server running on host and accepting Psycopg2.OperationalError: could not connect to server: Connection timed out I've followed some of the docs, blogs & various libraries like redshift_tool with pandas, SQLAlchemy, pyodbc to configure clusters for python & came up with one library to use psycopg2 conn = nnect(īut I'm facing following error for all the libraries including psycopg2

I configured security group and configured inbound with:ġ) Type : Redshift, Protocol : TCP, Port Range: 5439, Source: 0.0.0.0/0Ģ) Type : Redshift, Protocol : TCP, Port Range: 5439, Source: 'Security group name' Cluster is inside VPC and having no publicly access. I'm newbie to AWS Redshift & I'm not able to fetch data from schema from Redshift cluster.