How to set Schema in `redshift_connector`?
Asked Answered
P

0

6

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.

Pachalic answered 6/1, 2021 at 6:33 Comment(0)

© 2022 - 2024 — McMap. All rights reserved.