Amazon Redshift Python connector
By using the Amazon Redshift connector for Python, you can integrate work with the Amazon SDK for Python (Boto3)
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:
-
Amazon 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 Amazon Big Data blog post Federate Amazon Redshift access with Microsoft Azure AD single sign-on
. -
Active Directory Federation Services. For more information, see the Amazon 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 Amazon 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
Topics
- Installing the Amazon Redshift Python connector
- Configuration options for the Amazon Redshift Python connector
- Importing the Python connector
- Integrating the Python connector with NumPy
- Integrating the Python connector with pandas
- Using identity provider plugins
- Examples of using the Amazon Redshift Python connector
- API reference for the Amazon Redshift Python connector