fusetools.db_conn_tools.Redshift

class fusetools.db_conn_tools.Redshift

Bases: object

Redshift database connections.

Methods

conn_rs_pg	Create a Redshift database connection object via psycopg2 package.
conn_rs_sa	Create a Redshift database connection object via SqlAlchemy.

classmethod conn_rs_pg(db, host, port, user, pwd)

Create a Redshift database connection object via psycopg2 package.

Parameters

• db – Redshift database name.

• host – Redshift database host address.

• port – Redshift database post.

• user – Redshift username.

• pwd – Redshift password.

Returns

Redshift database connection object.

classmethod conn_rs_sa(db, host, port, user, pwd)

Create a Redshift database connection object via SqlAlchemy.

Parameters

• db – Redshift database name.

• host – Redshift database host address.

• port – Redshift database post.

• user – Redshift username.

• pwd – Redshift password.

Returns

Redshift database connection object.