Amazon Redshift Python connector

Focus mode

Amazon Redshift Python connector - Amazon Redshift

By using the Amazon Redshift connector for Python, you can integrate work with the AWS SDK for Python (Boto3), and also pandas and Numerical Python (NumPy). For more information on pandas, see the pandas GitHub repository. For more information on NumPy, see the NumPy GitHub repository.

The Amazon Redshift Python connector provides an open source solution. You can browse the source code, request enhancements, report issues, and provide contributions.

To use the Amazon Redshift Python connector, make sure that you have Python version 3.6 or later. For more information, see the Amazon Redshift Python driver license agreement.

The Amazon Redshift Python connector provides the following:

AWS Identity and Access Management (IAM) authentication. For more information, see Identity and access management in Amazon Redshift.
Identity provider authentication using federated API access. Federated API access is supported for corporate identity providers such as the following:
- Azure AD. For more information, see the AWS Big Data blog post Federate Amazon Redshift access with Microsoft Azure AD single sign-on.
- Active Directory Federation Services. For more information, see the AWS Big Data blog post Federate access to your Amazon Redshift cluster with Active Directory Federation Services (AD FS): Part 1.
- Okta. For more information, see the AWS Big Data blog post Federate Amazon Redshift access with Okta as an identity provider.
- PingFederate. For more information, see the PingFederate site.
- JumpCloud. For more information, see the JumpCloud site.
Amazon Redshift data types.

The Amazon Redshift Python connector implements Python Database API Specification 2.0. For more information, see PEP 249—Python Database API Specification v2.0 on the Python website.