'How to set Schema in `redshift_connector`?
I am using redshift_connector - Amazon Redshift connector for Python >= 3.5
How to set the schema while running code from python.
import redshift_connector
# Connects to Redshift cluster using AWS credentials
conn = redshift_connector.connect(
host='examplecluster.abc123xyz789.us-west-1.redshift.amazonaws.com',
database='dev',
user='awsuser',
password='my_password'
)
cursor = conn.cursor()
cursor.execute("create awesome_schema.Temp table book(bookname varchar,author varchar)")
cursor.execute("select * from awesome_schema.book")
That's how I am setting schema to awesome_schema in the code.
But this is super tedious and not configurable. Of course, I can manipulate the string and set schema.
But I am wondering is there a better way to set Schema?
I have already looked into the https://github.com/aws/amazon-redshift-python-driver repo but have not found many suitable examples.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
