redshift-connector

Full Changelog: v2.1.14...v2.1.15

Full Changelog: v2.1.13...v2.1.14

• Raised minimum supported Python version from 3.6 to 3.7
• Fixed prepared statement cache desync causing KeyError after DDL/ROLLBACK
• Raised lxml upper bound from <6.0.0 to <=6.0.2 to unblock Python 3.14 support
• Bumped beautifulsoup4 minimum version from 4.7.0 to 4.13.5 to fix lxml 6.0 parsing bug with curly braces
• Fixed Python 3.7/3.8 type hint compatibility in Metadata API

• Added support for Identity Enhanced Credentials authentication
• Fixed metadata retrieval to sanitize invalid negative and None values in metadataAPIHelper

chore: bump version to 2.1.11

chore: bump version to 2.1.10

chore: bump version to 2.1.9

chore: bump version to 2.1.8

chore: bump version to 2.1.7

• Directly imports a package as a fallback mechanism for retrieving a package’s version number during identity provider authentication.
• Fixed stale prepared statement caching issue by clearing the cache upon execution of DROP or ROLLBACK commands.

Thank you to @timm4205 for their contributions to this release.

• This driver version has been recalled. Python Driver v2.1.3 is recommended for use instead.

Thank you to @jamescaii and @jamesdow21 for their contributions to this release.

• Temporarily reverted the following commit which caused connection failure for some Docker containers when SSL was enabled: “refactor(Connection): explicitly use TLS protocol for underlying connection socket. previously TLS protocol was used by default. resolves deprecation warnings in Python 3.11" [Brooke White]

• Fix(auth, AdfsCredentialsProvider): Fixes a login issue that did not allow the loginToRp connection parameter in the AdfsCredentialsProvider to be set. [Brooke White]

• Fix(execute): fixed a bug which resulted in Pandas Timestamp datatype to be sent to Redshift as the DATE instead of TIMESTAMP/TIMESTAMPTZ when statements are executed using bind parameters. issue #206. [Brooke White]
• Test(datatype): Enable intervaly2m, intervald2s integration tests. Correct numeric integration tests. [Brooke White]
• Feat(auth, AdfsCredentialsProvider): Add support for connection parameter loginToRp in AdfsCredentialsProvider. This parameter specifies a custom relying party trust to use for ADFS authentication. Default behavior remains unchanged and backwards compatibility with previous versions is maintained The loginToRp parameter can be used to define a custom relying party trust used for authenticating with ADFS. [Brooke White]
• Doc(README): adjusts connection parameter table formatting. [Brooke White]
• Fix(datatype): Fix data ingestion to properly handle NUMERIC data types when using the binary transfer protocol to prevent incorrect results. issue #207. [Brooke White]
• Fix(cursor, execute): log underlying connection state using class variables when exception is raised. resolves db-api extension warnings #204. [Brooke White]
• Test: re-enable datatype integration tests. [Brooke White]
• Test: disable or adjust flaky integration tests. [Brooke White]

Thank you to @rmaxu for their contribution in #199 .

• Chore: lint codebase. [Brooke White]
• Feat: Adds ability to connect to datashare databases for clusters and serverless workgroups running the PREVIEW_2023 track. [Brooke White]
• Chore: Removed BrowserIdcAuthPlugin. [Brooke White]

• Feat(auth): Added support for Custom Cluster Names (CNAME) for Amazon Redshift Serverless. [Brooke White]
• Feat(datatype): Added support for IntervalY2M and IntervalD2S. [Brooke White]
• Docs(paramstyle): expanded descriptions for setting paramstyle on module and cursor level. added more examples of how to set paramstyle. [Brooke White]
• Feat(auth, iam): allowed use of getClusterCredentials V2 API when IdP Plugin authentication is used and group_federation=True. Previously an unsupported error was thrown. [Brooke White]

Thank you to @soksamnanglim for their contribution to this release.

Thank you to @jiezhen-chen , @soksamnanglim , @kyledemeule , and @gmattg for their contributions to this release.

• Fix(auth, iam): log if boto3 version insufficient for cname. [Brooke White]

• Test(cursor): correct test_insert_data_invalid_column_raises. [Brooke White]
• Feat(auth): Support Redshift custom domain name. [Brooke White]
• Fix(cursor, __has_valid_columns): raise exception if column validity check returns nothing. [Brooke White]
• Doc: python 3.11 support. [Brooke White]
• Refactor: logging improvements. [Brooke White]

thank you @jiezhen-chen for your contribution

Thank you to @daikikatsuragawa and @Fredericco72 , for their contributions in #139 and #141 respectively.

Thank you to @pierresouchay for their contributions in #119

Thank you to @noppaz and @hoxu for their contributions in #102 and #101 , respectively

Thank you to @hoxu for their contribution in #99

• Feat(connection, application_name): set to calling module if unspecified. [Brooke White]

• Docs(Connection, numeric_to_float): add disclaimer for precision tradeoffs. [Brooke White]

• Feat(Connection, numeric_to_float): add connection option to convert numeric datatype to Python float. [Brooke White]

• Chore(deps): update pytz requirement (#94) [dependabot[bot]]

  Updates the requirements on pytz to permit the latest version.

  • Release notes
  • Commits

  ---

  updated-dependencies:

  • dependency-name: pytz dependency-type: direct:production ...

• Fix(idp, BrowserAzureCredentialsProvider): remove client_secret parameter. [Brooke White]

• Test(auth): sha256 password. [Brooke White]

• Feat(auth): support sha256 password. [Brooke White]

• Docs(readme): add native auth connection params. [Brooke White]

• Test(native-auth): manual, unit tests and fixture. [Brooke White]

• Feat: support Redshift native authentication, Add Azure Oauth2 IdP. [Brooke White]

Thank you to @Yash621 for their contribution in #81

Thank you to @evgenyx00 for their contribution in #76

• Docs(paramstyle, named): fix example. [Brooke White]
• Chore: bump lxml >=4.6.5. [Brooke White]

• Refactor(test, paramstyle): adjust to order result set. [Brooke White]
• Test(iam, aws_credentials): allow aws creds from env var. [Brooke White]
• Fix(iam, aws_credentials): allow aws credentials from env var. [Brooke White]
• Test(paramstyle): add integration tests, rework. [Brooke White]
• Fix(paramstyle): resolve issue with pyformat. [Brooke White]

Thank you to @ramiro , @ramiro-eb for their contribution in #66

Thank you, @ashb , for your work in #60

Thank you, @kylemcleland-fanduel, for your work in #57

• Fix(cursor, metadata-queries): support for super, varbyte datatype. [Brooke White]
• Test(datatype, varbyte): ensure support. [Brooke White]
• Feat(datatype): support varbyte. [Brooke White]

• Test(datatype, system-tables): enable test for pg_proc. [Brooke White]
• Fix(JwtCredentialsProvider, refresh): use derived user from JWT token as RoleSessionName. [Brooke White]
• Test(Cursor, callproc): ensure support. [Brooke White]
• Feat(Cursor, callproc): support db-api method callproc() [Brooke White]

• Test(iam, set_iam_credentials): ensure force_lowercase is used. [Brooke White]
• Fix(iam, set_iam_credentials): utilize force_lowercase connection opt. [Brooke White]
• Fix(iam, set_iam_credentials): consider precedence when setting db_user. [Brooke White]

Thank you to @ivica-k for their contribution to this release, #42 .

• Docs(Connection, handle_DATA_ROW): add doc-string. [Brooke White]
• Docs(tutorials, BrowserAzureCredentialsProvider): fix bug in tutorial. [Brooke White]
• Docs: update doc-strings, fix typo. [Brooke White]
• Docs(readme): update connection params table, pandas usage. [Brooke White]
• Test(idp, browser-azure): display close window message after auth with IdP. [Brooke White]
• Fix(idp, browser): display close window message after auth with IdP. [Brooke White]

• Refactor(redshift-property, ssl_insecure): use ssl_insecure rather than sslInsecure in internal code. [Brooke White]
• Refactor(logging): add additional debug stmts. [Brooke White]
• Docs(tutorials): init tutorials. [Brooke White]
• Refactor(tests, idp): don't pass host, port, db password to idp fixtures. [Brooke White]
• Fix(connection, iam-auth): host, port connect() params override describe_cluster response. [Brooke White]

• Test(connection, client_protocol_invalid_logs): disable flaky test. [Brooke White]
• Test(datatype, geometryhex): ensure support for all protocols. [Brooke White]
• Feat(datatype, geometryhex): support geometryhex. [Brooke White]
• Test(connection, transfer-protocol): ensure system table queries execute. [Brooke White]
• Chore(deps): update scramp requirement (#35) [dependabot[bot]]
• Chore: update dependabot.yml prefix. [Brooke White]
• Chore: fix dependabot.yml prefix. [Brooke White]
• Chore: init dependabot.yml. [Brooke White]

• Test(connection, transfer-protocol): modify conversion functions when server version < client requests. [Brooke White]
• Fix(connection, transfer-protocol): modify conversion functions when server version < client requests. [Brooke White]

• Refactor(cursor, setinputsize): use named arguments. [Brooke White]
• Refactor(test, connection): use mock py_types, pg_types. [Brooke White]
• Refactor(Connection, type_utils): add py_types, pg_types to Connection class, declare typecode constants at package level. [Brooke White]
• Docs(contributing): update PR guidelines. [Brooke White]
• Test(hooks): disable writing test failures to file. [Brooke White]
• Refactor(connection, client-protocol): log when there is a mismatch in requested vs granted protocol. [Brooke White]
• Docs(transfer-protocol): modifying transfer protocol via connect method. [Brooke White]
• Fix(datatype): support regproc in binary format. [Brooke White]
• Feat(connection, transfer-protocol): enable binary transfer protocol by default. [Brooke White]
• Test(connection, datatype): datatype tests for supported transfer protocols. [Brooke White]
• Test(connection, transfer-protocol): manual protocol performance comparison. [Brooke White]
• Feat(connection, transfer-protocol): support binary transfer protocol. [Brooke White]
• Fix(iam_helper): user, password are not required with credential provider. [Brooke White]
• Perf(cursor, merge_socket_read): enable by default. [Brooke White]
• Docs(pull_request_template): update PR checklist. [Brooke White]

Thank you to @daltonconley and @mzvrzg for their contributions to this release, #29 and #30 respectfully.

• Fix(dependency): bump requests, beautifulsoup4, pytz. [Brooke White]
• Docs: add docstrings for methods directly used methods. [Brooke White]
• Docs(installation): clarify installation methods. [Brooke White]
• Fix(docs): remove pesky \u200e from usage examples. [Brooke White]
• Refactor(IdP): log error response of SAML request. [Brooke White]
• Chore: add dev dependency docutils. [Brooke White]
• Docs(datatype): supported Amazon Redshift datatypes and Python datatype counterpart. [Brooke White]
• Docs(cursor, paramstyle): add explanation and examples. [Brooke White]
• Fix(docs, connection-parameters): replace section header. [Brooke White]

• Fix(dependency): bump max boto3, botocore version. [Brooke White]
• Chore(dependency): bump lxml>=4.6.2. [Brooke White]

• Fix(requirements): invalid version specifiers. [Brooke White]
• Docs(autocommit): Provide autocommit usage example. [Brooke White]
• Test(auth): add manual authentication tests. [Brooke White]
• Test(iam_helper): update test cases without user and password. [Brooke White]
• Fix(credentials): user, password are not required when using AWS credentials or AWS profile. [Brooke White]

• Docs(connection): update connection parameters. [Brooke White]
• Refactor(tests): modify config for use with CI. [Brooke White]
• Test(IdP, JwtCredentialsProvider): JWT SSO IdP support. [Brooke White]
• Feat(IdP, JwtCredentialsProvider): support JWT SSO IdP. [Brooke White]
• Test(idp): cached temporary AWS credentials used if present and valid. [Brooke White]
• Feat(idp): cache temporary aws credentials to reduce calls to AWS API. [Brooke White]
• Refactor(adfs_credentials_provider): explicitly specify lxml as parser for server response. [Brooke White]
• Refactor(iam_helper): simplify validation of sslmode connection parameter. [Brooke White]
• Fix(connection): require cluster_identifier when IAM is enabled. [Brooke White]
• Test(IdP): dynamic loading and use of external IdP plugin. [Brooke White]
• Feat(IdP): support dynamically loaded IdP plugins. [Brooke White]

• Docs(auth): IAM credential authentication. [Brooke White]

• Test(auth): IAM credential authentication. [Brooke White]

• Feat(auth): support IAM credential authentication. [Brooke White]

• Test(datatype): mark for manual execution. [Brooke White]

• Docs: add conda installation instructions, shields. [Brooke White]

• Test(datatype): handle geometry. [Brooke White]

• Feat(datatype): support geometry. [Brooke White]

• Refctor(mypy): correct type errors. [Brooke White]

• Chore: add mypy pre-commit hook. [Brooke White]

• Fix(test, datatype): Fix datatype test table generation. [Brooke White]

• Revert "chore: init traffic action" [Brooke White]

  This reverts commit e73cf79799a6c04a6eaefbac77314b87388d77d0.

• Revert "chore: add manual trigger to traffic workflow" [Brooke White]

  This reverts commit 4209b703dbdf93f40310a2a05846d1e1fa1afcaf.

• Revert "chore: update traffic analyzer display name" [Brooke White]

  This reverts commit 77a9c1de1f6ce54266ff67bc6aa894d3b4910240.

• Chore: update traffic analyzer display name. [Brooke White]

• Chore: add manual trigger to traffic workflow. [Brooke White]

• Chore: init traffic action. [Brooke White]

• Fix(test,datatype): setup/teardown sql script path. [Brooke White]
• Chore(test): ignore InsecureRequestWarning. [Brooke White]
• Test(idp): integration and unit tests for adfs, azure, okta. [Brooke White]
• Test(datashare): skip datashare tests for now. [Brooke White]
• Test(datatype): handle data from server. [Brooke White]
• Feat(datatype): support timetz. [Brooke White]
• Feat(datatype): support super. [Brooke White]
• Feat(connection): add ssl_insecure parameter default to True. [Brooke White]
• Test(datashare): connection args, cursor metadata methods. [Brooke White]
• Feat(connection): add datashare support, disabled by default. [Brooke White]
• Docs: remove log args from connection parameter, explain logging usage. [Brooke White]
• Fix(logging): remove logging configuration from connect(), suppress log stderr output by default. [Brooke White]
• Perf(imports): use lazy-imports for idp plugins. [Brooke White]
• Chore: correct mypy errors. [Brooke White]
• Feat(Connection): add initializer parameter for server protocol version, default to extended metadata. [Brooke White]

• Refactor(cursor): use prepared statements in class methods. [Brooke White]

• Refactor(integer-datetime): remove datatype conversion functions for when server option integer_datetime is disabled. [Brooke White]
• Refactor: clean up setup.py. [Brooke White]
• Docs: update installation instructions to reflect pandas, numpy being optional. [Brooke White]
• Test(cursor): skips test using numpy, pandas if not available. [Brooke White]
• Refactor(cursor): check pandas, numpy available before use. [Brooke White]
• Build: make numpy, pandas optional dependencies unify dependecy list in requirements txt. [Brooke White]
• Test(datatype): remove unsupported tests for timetz, time. [Brooke White]
• Test(auth): test invalid db_groups vals result in server error. [Brooke White]
• Fix(auth): include DbGroups when getting temp credentials from boto. [Brooke White]
• Refactor(cursor): extend fetch_dataframe error handling. [Brooke White]
• Doc: Fix errors in connection parameter table. Add missing parameters to table (#12) [Brooke White]

• Doc: re-word project description (#8) [Brooke White]

• Chore: Add license, usage files and include in whl (#7) [Brooke White]

• Build: set long_description_format_type set to x-rst (#6) [Brooke White]