Release v2022.42.2 of Athena Query Federation

This version includes improvements and bugfixes in some connectors. See here for changes since the last release.

Binary distribution of the SDK can be found here. For pre-built versions of the connector and UDF suite please:

1. Navigate to Serverless Application Repository and search for “athena-federation”. Also check the checkbox labeled “Show apps that create custom IAM roles or resource policies”.

2. Look for entries published by the “Amazon Athena Federation” author.

You can assert the validity of the binary distribution by comparing against the below cksums.

CheckSum	File
2248223770 549796	aws-athena-federation-sdk-2022.42.2.jar
1430333765 23562848	aws-athena-federation-sdk-2022.42.2-withdep.jar

What's Changed

• athena-cloudwatch: fix athena-cloudwatch.yaml
• Modified partitioning logic in snowflake
• athena-docdb: Make use of the Glue table property "sourceTable"
• athena-docdb: add disable_projection_and_casing env var Fix the wrong jar name in tools/validate_connector.sh (#799) Update pom.xml
• athena-dynamodb: Add support for optional LambdaRole parameter
• athena-cloudwatch: Add support for optional LambdaRole parameter
• Add generative tests for the default FieldResolver as well
• Data Integrity: Add generative tests for DynamoDb and Elasticsearch.

Full Changelog: v2022.39.1...v2022.42.2

Release v2022.39.1 of Athena Query Federation

This version includes improvements and bugfixes in some connectors. See here for changes since the last release.

Binary distribution of the SDK can be found here. For pre-built versions of the connector and UDF suite please:

1. Navigate to Serverless Application Repository and search for “athena-federation”. Also check the checkbox labeled “Show apps that create custom IAM roles or resource policies”.

2. Look for entries published by the “Amazon Athena Federation” author.

You can assert the validity of the binary distribution by comparing against the below cksums.

CheckSum	File
3782708220 549744	aws-athena-federation-sdk-2022.39.1.jar
1563910625 23562796	aws-athena-federation-sdk-2022.39.1-withdep.jar

What's Changed

• DDB: Add BETWEEN support
• Elastic search connector enable pagination query data from get record. This will allow use to bypass max_result_window settings

Full Changelog: v2022.38.1...v2022.39.1

Release v2022.38.1 of Athena Query Federation

This version includes improvements and bugfixes in some connectors. See here for changes since the last release.

Binary distribution of the SDK can be found here. For pre-built versions of the connector and UDF suite please:

1. Navigate to Serverless Application Repository and search for “athena-federation”. Also check the checkbox labeled “Show apps that create custom IAM roles or resource policies”.

2. Look for entries published by the “Amazon Athena Federation” author.

You can assert the validity of the binary distribution by comparing against the below cksums.

CheckSum	File
1209013645 549743	aws-athena-federation-sdk-2022.38.1.jar
3817496865 23562795	aws-athena-federation-sdk-2022.38.1-withdep.jar

What's Changed

• athena-jdbc: Don't trim string values
• Data Integrity: Add generative testing and fixes (#780)
• Upgrade apache arrow version to 9.0.0
• neptune: added support for timestamp and case insensitive match
• Fix a typo in README.md of athena-federation-sdk
• Redirect datalake gen2 docs to Amazon Documentation
• Mass port READMEs to point to Amazon Athena Documentation
• Update JDBC Readme to specify it is not deployable
• Implemented BigInt datatype feature for Timestream connector

Full Changelog: v2022.34.1...v2022.38.1

Release v2022.34.1 of Athena Query Federation

This version includes improvements and bugfixes in some connectors. See here for changes since the last release.

Binary distribution of the SDK can be found here. For pre-built versions of the connector and UDF suite please:

1. Navigate to Serverless Application Repository and search for “athena-federation”. Also check the checkbox labeled “Show apps that create custom IAM roles or resource policies”.

2. Look for entries published by the “Amazon Athena Federation” author.

You can assert the validity of the binary distribution by comparing against the below cksums.

CheckSum	File
4197898694 538689	aws-athena-federation-sdk-2022.34.1.jar
4075597303 22999867	aws-athena-federation-sdk-2022.34.1-withdep.jar

What's Changed

• Timestream Connector Boolean Type Support
• Bump postgresql from 42.3.3 to 42.4.1 in /athena-postgresql
• Added support for Azure AD ServicePrincipal authentication for Synapse
• Update athena-oracle/README.md with more details on ssl support for RDS

Full Changelog: v2022.32.1...v2022.34.1

Release v2022.32.1 of Athena Query Federation

This version includes improvements and bugfixes in some connectors. See here for changes since the last release.

Binary distribution of the SDK can be found here. For pre-built versions of the connector and UDF suite please:

1. Navigate to Serverless Application Repository and search for “athena-federation”. Also check the checkbox labeled “Show apps that create custom IAM roles or resource policies”.

2. Look for entries published by the “Amazon Athena Federation” author.

You can assert the validity of the binary distribution by comparing against the below cksums.

CheckSum	File
474691901 539656	aws-athena-federation-sdk-2022.32.1.jar
509854253 23000834	aws-athena-federation-sdk-2022.32.1-withdep.jar

What’s Changed

• Implemented SSL based connection logic in the oracle connector (#749)
• Add partition columns in Glue Metadata to schema
• Removed Default values for GCPProjectId and SecretNamePrefix for Google BigQuery

Full Changelog: v2022.30.2...v2022.32.1

Release v2022.30.2 of Athena Query Federation

This version includes improvements and bugfixes in some connectors. See here for changes since the last release.

Binary distribution of the SDK can be found here. For pre-built versions of the connector and UDF suite please:

1. Navigate to Serverless Application Repository and search for “athena-federation”. Also check the checkbox labeled “Show apps that create custom IAM roles or resource policies”.

2. Look for entries published by the “Amazon Athena Federation” author.

You can assert the validity of the binary distribution by comparing against the below cksums.

CheckSum	File
3630990155 539439	aws-athena-federation-sdk-2022.30.2.jar
981210327 23000617	aws-athena-federation-sdk-2022.30.2-withdep.jar

What’s Changed

• Add Support for List of Struct on infer schema logic.
• Add disable_projection_and_casing to deal with casing issues
• GlueFieldLexer: Add decimal support
• GlueFieldLexer: refactor and fix lexing logic
• GlueFieldLexer: handle Glue set type
• Add helper python script to validate json content of test config files, add fix for timestream query
• Integ Test Config File Fixes
• Adding User Agent field to Timestream SDKs (Query and Write)
• Added Timestamp and Date Datatype conversion For Snowflake (#729)
• Feature/teradata datasource (#731)
• Bump mysql-connector-java from 8.0.17 to 8.0.28 in /athena-mysql

Full Changelog: v2022.24.1...v2022.30.2

Release v2022.24.1 of Athena Query Federation

This version includes improvements and bugfixes in some connectors. See here for changes since the last release.

Binary distribution of the SDK can be found here. For pre-built versions of the connector and UDF suite please:

1. Navigate to Serverless Application Repository and search for "athena-federation". Also check the checkbox labeled "Show apps that create custom IAM roles or resource policies".

2. Look for entries published by the "Amazon Athena Federation" author.

You can assert the validity of the binary distribution by comparing against the below cksums.

CheckSum	File
4290332420 22999806	aws-athena-federation-sdk-2022.24.1-withdep.jar
1651061336 538628	aws-athena-federation-sdk-2022.24.1.jar

What's Changed

• Added spill_put_request_headers environment variable.
• S3BlockSpiller: fix double buffering bug
• Added fix to show only user defined schemas in Athena Data window

Full Changelog: v2022.23.1...v2022.24.1

Release v2022.23.1 of Athena Query Federation

This version includes improvements and bugfixes in some connectors. See here for changes since the last release.

Binary distribution of the SDK can be found here. For pre-built versions of the connector and UDF suite please:

1. Navigate to Serverless Application Repository and search for "athena-federation". Also check the checkbox labeled "Show apps that create custom IAM roles or resource policies".

2. Look for entries published by the "Amazon Athena Federation" author.

You can assert the validity of the binary distribution by comparing against the below cksums.

CheckSum	File
4016003485 22998040	aws-athena-federation-sdk-2022.23.1-withdep.jar
1257945511 536878	aws-athena-federation-sdk-2022.23.1.jar

What's Changed

• Fix for External table access issue in Azure Server less environment (#698)
• Various internal changes for versioning and maven

Full Changelog: v2022.22.1...v2022.23.1

Release v2022.22.1 of Athena Query Federation

This version includes improvements and bugfixes in some connectors. See here for changes since the last release.

Binary distribution of the SDK can be found here. For pre-built versions of the connector and UDF suite please:

1. Navigate to Serverless Application Repository and search for "athena-federation". Also check the checkbox labeled "Show apps that create custom IAM roles or resource policies".

2. Look for entries published by the "Amazon Athena Federation" author.

You can assert the validity of the binary distribution by comparing against the below cksums.

CheckSum	File
3829355949 22998045	aws-athena-federation-sdk-2022.22.1-withdep.jar
369708923 536883	aws-athena-federation-sdk-2022.22.1.jar

What's Changed

• Ddb connector with extractor and GeneratedRowWriter (#704)
• Fix for Sql Server partition issue (#707)
• Corrected athena-snowflake.yaml description
• adding option for VPC config on elasticsearch connector
• Bigquery metadata pagination implementation && fixed bigquery table casesensitive issue
• BigQuery IAM role & policies changes in template file
• Fix a small typo in README.md
• Fix log4j logger configurations
• Enhance integration test suite (#676)

Full Changelog: v2022.20.1...v2022.22.1

Release v2022.20.1 of Athena Query Federation

This version includes improvements and bugfixes in some connectors. See here for changes since the last release.

Binary distribution of the SDK can be found here. For pre-built versions of the connector and UDF suite please:

1. Navigate to Serverless Application Repository and search for "athena-federation". Also check the checkbox labeled "Show apps that create custom IAM roles or resource policies".

2. Look for entries published by the "Amazon Athena Federation" author.

You can assert the validity of the binary distribution by comparing against the below cksums.

File	CheckSum
aws-athena-federation-sdk-2022.10.1.jar	992701943 536883
aws-athena-federation-sdk-2022.10.1-withdep.jar	265281481 22998045

What's Changed

• Snowflake - Fixing snowflake emoji in readme connstrs by @avirtuos in #692
• Snowflake - Add PartitionLimit option to configure the snowflake connector via SAR by @trianz-azam in #695
• HBase - Predicate over primary key error by @hackett123 in #690

Full Changelog: v2022.10.1...v2022.20.1