redshift_connector is the Amazon Redshift connector for Python. Easy integration with pandas and numpy, as well as support for numerous Amazon Redshift-specific features help you get the most out of your data. redshift_connector integrates with various open-source projects to provide an interface to Amazon Redshift. Please open an issue with our project to request new integrations or get support for a redshift_connector issue seen in an existing integration. Following the DB-API specification, autocommit is off by default. It can be turned on by using the autocommit property of the connection. The paramstyle for a cursor can be modified via cursor.paramstyle. The default paramstyle used is format. Valid values for paramstyle include qmark, numeric, named, format, pyformat. redshift_connector uses logging for providing detailed error messages regarding IdP authentication. A do-nothing handler is enabled by default as to prevent logs from being output to sys.stderr.
Features
- IAM authentication
- Identity provider (IdP) authentication
- Redshift specific data types
- You may install from source by cloning this repository
- IAM Credentials can be supplied directly to connect(...) using an AWS profile
- Integration with pandas