Release v2023.30.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.

Athena Federation SDK jars

CheckSum	File
3444820758 28515251	aws-athena-federation-sdk-2023.30.1-withdep.jar
270232463 634412	aws-athena-federation-sdk-2023.30.1.jar

Athena Federation Connector Lambda jars

CheckSum	File
1627618735 42775404	athena-aws-cmdb-2023.30.1.jar
1252650093 46687206	athena-cloudera-hive-2023.30.1.jar
1313732702 42483514	athena-cloudera-impala-2023.30.1.jar
3438220915 37420815	athena-cloudwatch-2023.30.1.jar
2914028511 31272411	athena-cloudwatch-metrics-2023.30.1.jar
3531557911 32941722	athena-datalakegen2-2023.30.1.jar
682743730 38220381	athena-db2-2023.30.1.jar
3305565538 40882080	athena-db2-as400-2023.30.1.jar
1375439052 33093119	athena-docdb-2023.30.1.jar
2232276190 32871483	athena-dynamodb-2023.30.1.jar
4270108327 57935172	athena-elasticsearch-2023.30.1.jar
2501047414 92891006	athena-gcs-2023.30.1.jar
436400982 80179347	athena-google-bigquery-2023.30.1.jar
4226871655 93730314	athena-hbase-2023.30.1.jar
3869132601 46687563	athena-hortonworks-hive-2023.30.1.jar
3600520671 44462578	athena-kafka-2023.30.1.jar
1571852034 51225690	athena-msk-2023.30.1.jar
3444070022 35796701	athena-mysql-2023.30.1.jar
388576864 55343024	athena-neptune-2023.30.1.jar
4129885716 38395982	athena-oracle-2023.30.1.jar
1255623996 32625257	athena-postgresql-2023.30.1.jar
652028728 35872538	athena-redis-2023.30.1.jar
1470207743 33641225	athena-redshift-2023.30.1.jar
2053966956 33328750	athena-saphana-2023.30.1.jar
1384837142 63515862	athena-snowflake-2023.30.1.jar
3630234183 32945882	athena-sqlserver-2023.30.1.jar
867722534 35158940	athena-synapse-2023.30.1.jar
3661947280 31551974	athena-teradata-2023.30.1.jar
467504023 31863027	athena-timestream-2023.30.1.jar
2475526145 31386247	athena-tpcds-2023.30.1.jar
3154448558 30713690	athena-udfs-2023.30.1.jar
968459170 32616537	athena-vertica-2023.30.1.jar

Athena Federation Connector Lambda zips

CheckSum	File
1838337074 86556565	athena-gcs.zip
2628399582 81944693	athena-saphana.zip

What's Changed

• build(deps): bump aws-sdk.version from 1.12.507 to 1.12.514 (#1397)
• build(deps): bump io.lettuce:lettuce-core from 6.2.4.RELEASE to 6.2.5.RELEASE (#1386)
• build(deps): bump com.google.api.grpc:grpc-google-cloud-bigquerystorage-v1 from 2.39.1 to 2.41.0 (#1396)
• build(deps): bump org.apache.kafka:kafka-clients from 3.5.0 to 3.5.1 (#1393)
• build(deps): bump com.mysql:mysql-connector-j from 8.0.33 to 8.1.0 (#1390)
• build(deps): bump com.google.cloud:google-cloud-bigquery from 2.29.0 to 2.30.1 (#1388)
• Performance improvement on Google BigQuery connector with storage API implementation for Table(#1347)
• Case insensitive table name search in JDBC connectors (#1289)

Full Changelog: https://github.com/awslabs/aws-athena-query-federation/compare/v2023.29.1..v2023.30.1

Release v2023.29.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.

Athena Federation SDK jars

CheckSum	File
2023828011 28494550	aws-athena-federation-sdk-2023.29.1-withdep.jar
4031663016 634413	aws-athena-federation-sdk-2023.29.1.jar

Athena Federation Connector Lambda jars

CheckSum	File
135626413 42750037	athena-aws-cmdb-2023.29.1.jar
2280667757 46665450	athena-cloudera-hive-2023.29.1.jar
2435575205 42461759	athena-cloudera-impala-2023.29.1.jar
3118230847 37400116	athena-cloudwatch-2023.29.1.jar
777068409 31251711	athena-cloudwatch-metrics-2023.29.1.jar
523963330 32919966	athena-datalakegen2-2023.29.1.jar
1925179999 38198625	athena-db2-2023.29.1.jar
3760243189 40860325	athena-db2-as400-2023.29.1.jar
1396451021 33072419	athena-docdb-2023.29.1.jar
545963840 32850769	athena-dynamodb-2023.29.1.jar
3006491957 57914473	athena-elasticsearch-2023.29.1.jar
2689814516 92870305	athena-gcs-2023.29.1.jar
620605729 76847465	athena-google-bigquery-2023.29.1.jar
3592592993 93709615	athena-hbase-2023.29.1.jar
2119311155 46665806	athena-hortonworks-hive-2023.29.1.jar
2412827201 44441081	athena-kafka-2023.29.1.jar
4208572272 51204192	athena-msk-2023.29.1.jar
4122429550 35770449	athena-mysql-2023.29.1.jar
1226266181 55322322	athena-neptune-2023.29.1.jar
1828103099 38374225	athena-oracle-2023.29.1.jar
3528820288 32603376	athena-postgresql-2023.29.1.jar
4043328925 35843310	athena-redis-2023.29.1.jar
1291452478 33619345	athena-redshift-2023.29.1.jar
1795213069 33306994	athena-saphana-2023.29.1.jar
1711629516 63494108	athena-snowflake-2023.29.1.jar
1713683754 32924125	athena-sqlserver-2023.29.1.jar
3033243499 35137184	athena-synapse-2023.29.1.jar
66790606 31530218	athena-teradata-2023.29.1.jar
1505370491 31842330	athena-timestream-2023.29.1.jar
1767137752 31365546	athena-tpcds-2023.29.1.jar
3686156901 30692990	athena-udfs-2023.29.1.jar
2637764726 32595837	athena-vertica-2023.29.1.jar

Athena Federation Connector Lambda zips

CheckSum	File
3234562393 86542635	athena-gcs.zip
759287916 81901517	athena-saphana.zip

What's Changed

• limit clause pushdown fix for unsupported data sources (#1373)
• Pushing down 'not equal' to predicate (#1365)
• Added ! as valid character in Secret, due to syntax of service linked secrets (#1383)
• build(deps): bump aws-sdk.version from 1.12.504 to 1.12.507 (#1380)
• build(deps): bump msal4j from 1.13.8 to 1.13.9
• build(deps): bump aws-sdk.version from 1.12.504 to 1.12.506
• build(deps): bump protobuf-java from 3.23.3 to 3.23.4
• build(deps): bump google-cloud-resourcemanager from 1.22.0 to 1.23.0
• build(deps): bump google-cloud-storage from 2.23.0 to 2.24.0
• build(deps): bump jt400 from 11.2 to 20.0.0
• build(deps): bump avro from 1.11.1 to 1.11.2
• build(deps-dev): bump DynamoDBLocal from 1.22.0 to 2.0.0
• build(deps): bump google-cloud-storage from 2.22.4 to 2.23.0
• build(deps): bump hadoop-common from 3.3.5 to 3.3.6
• build(deps): bump grpc-google-cloud-bigquerystorage-v1
• build(deps): bump google-cloud-resourcemanager from 1.21.0 to 1.22.0
• build(deps): bump aws-cdk.version from 1.203.0 to 1.204.0
• build(deps): bump snowflake-jdbc from 3.13.32 to 3.13.33
• build(deps): bump google-cloud-bigquery from 2.27.1 to 2.29.0
• build(deps): bump aws-msk-iam-auth from 1.1.6 to 1.1.7
• build(deps): bump guava from 32.0.1-jre to 32.1.1-jre
• build(deps): bump jqwik from 1.7.3 to 1.7.4
• build(deps): bump aws-sdk.version from 1.12.490 to 1.12.504
• build(deps-dev): bump equalsverifier from 3.14.2 to 3.15
• build(deps): bump redshift-jdbc42 from 2.1.0.16 to 2.1.0.17
• build(deps): bump ngdbc from 2.17.7 to 2.17.10
• build(deps): bump license-maven-plugin from 2.1.0 to 2.2.0

Full Changelog: https://github.com/awslabs/aws-athena-query-federation/compare/v2023.25.1..v2023.29.1

Release v2023.25.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.

Athena Federation SDK jars

CheckSum	File
185377341 28459153	aws-athena-federation-sdk-2023.25.1-withdep.jar
2138104322 634414	aws-athena-federation-sdk-2023.25.1.jar

Athena Federation Connector Lambda jars

CheckSum	File
3628747419 42681572	athena-aws-cmdb-2023.25.1.jar
1956629229 46629983	athena-cloudera-hive-2023.25.1.jar
671140333 42426294	athena-cloudera-impala-2023.25.1.jar
490472960 37362945	athena-cloudwatch-2023.25.1.jar
2397482658 31216313	athena-cloudwatch-metrics-2023.25.1.jar
2414068833 32884415	athena-datalakegen2-2023.25.1.jar
2765017213 38163159	athena-db2-2023.25.1.jar
3194146845 37160334	athena-db2-as400-2023.25.1.jar
1811738799 33037022	athena-docdb-2023.25.1.jar
531522317 32811411	athena-dynamodb-2023.25.1.jar
394831829 57879074	athena-elasticsearch-2023.25.1.jar
2046574232 92450178	athena-gcs-2023.25.1.jar
634765884 76787045	athena-google-bigquery-2023.25.1.jar
3306044718 93828560	athena-hbase-2023.25.1.jar
2436264495 46630340	athena-hortonworks-hive-2023.25.1.jar
3296296681 44405684	athena-kafka-2023.25.1.jar
2222149080 51168488	athena-msk-2023.25.1.jar
2361742786 35734984	athena-mysql-2023.25.1.jar
1974158129 55286924	athena-neptune-2023.25.1.jar
1799461886 38338667	athena-oracle-2023.25.1.jar
929103878 32567910	athena-postgresql-2023.25.1.jar
567120619 35807913	athena-redis-2023.25.1.jar
3177162648 33581087	athena-redshift-2023.25.1.jar
616384719 33271532	athena-saphana-2023.25.1.jar
3458456875 64797007	athena-snowflake-2023.25.1.jar
775003314 32888573	athena-sqlserver-2023.25.1.jar
578681120 35098784	athena-synapse-2023.25.1.jar
2664151619 31494661	athena-teradata-2023.25.1.jar
1274549796 31806934	athena-timestream-2023.25.1.jar
245555045 31330149	athena-tpcds-2023.25.1.jar
51897644 30657593	athena-udfs-2023.25.1.jar
3620133749 32560440	athena-vertica-2023.25.1.jar

Athena Federation Connector Lambda zips

CheckSum	File
2640342357 86121552	athena-gcs.zip
3332064958 81795945	athena-saphana.zip

What's Changed

• List struct support for bigquery connector (#1288)
• Enable jdbc to return for MATERIALIZED VIEW (#1336)
• Fix for data inconsistency in distinct clause Google BigQuery connector (#1319)
• build(deps): bump google-cloud-storage from 2.22.2 to 2.22.4
• build(deps): bump google-cloud-resourcemanager from 1.20.0 to 1.21.0
• build(deps): bump mongo-java-driver from 3.12.13 to 3.12.14
• build(deps): bump surefire.failsafe.version from 3.1.0 to 3.1.2
• build(deps): bump license-maven-plugin from 2.0.1 to 2.1.0
• build(deps-dev): bump DynamoDBLocal from 1.21.0 to 1.22.0
• build(deps): bump redshift-jdbc42 from 2.1.0.15 to 2.1.0.16
• build(deps): bump aws-sdk.version from 1.12.477 to 1.12.490
• build(deps): bump jsii-runtime from 1.82.0 to 1.84.0
• build(deps): bump guava from 32.0.0-jre to 32.0.1-jre
• build(deps): bump protobuf-java from 3.23.2 to 3.23.3
• build(deps): bump ngdbc from 2.16.14 to 2.17.7
• build(deps): bump hbase.version from 2.5.4-hadoop3 to 2.5.5-hadoop3
• build(deps): bump grpc-google-cloud-bigquerystorage-v1
• build(deps-dev): bump equalsverifier from 3.14.1 to 3.14.2
• build(deps): bump fasterxml.jackson.version from 2.15.1 to 2.15.2
• build(deps): bump aws-cdk.version from 1.202.0 to 1.203.0
• build(deps): bump kafka-clients from 3.4.0 to 3.5.0 (#1338)
• build(deps): bump google-cloud-bigquery from 2.26.1 to 2.27.1

Full Changelog: https://github.com/awslabs/aws-athena-query-federation/compare/v2023.23.1..v2023.25.1

Release v2023.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.

Athena Federation SDK jars

CheckSum	File
217334149 28446183	aws-athena-federation-sdk-2023.23.1-withdep.jar
3211089938 634412	aws-athena-federation-sdk-2023.23.1.jar

Athena Federation Connector Lambda jars

CheckSum	File
1734026309 42631918	athena-aws-cmdb-2023.23.1.jar
2935672859 46617911	athena-cloudera-hive-2023.23.1.jar
2856029453 42414223	athena-cloudera-impala-2023.23.1.jar
3288112189 37284212	athena-cloudwatch-2023.23.1.jar
3992074782 31203342	athena-cloudwatch-metrics-2023.23.1.jar
3549635387 32872341	athena-datalakegen2-2023.23.1.jar
256124096 38151087	athena-db2-2023.23.1.jar
858623691 37148261	athena-db2-as400-2023.23.1.jar
505439760 33024019	athena-docdb-2023.23.1.jar
4181090931 32798448	athena-dynamodb-2023.23.1.jar
1854510466 57866101	athena-elasticsearch-2023.23.1.jar
1802141465 92381415	athena-gcs-2023.23.1.jar
4194424098 76716259	athena-google-bigquery-2023.23.1.jar
1392171262 93796352	athena-hbase-2023.23.1.jar
820103529 46618269	athena-hortonworks-hive-2023.23.1.jar
377233963 44271700	athena-kafka-2023.23.1.jar
1698009002 51034505	athena-msk-2023.23.1.jar
2375658095 35722910	athena-mysql-2023.23.1.jar
2295577191 55273951	athena-neptune-2023.23.1.jar
1911273486 38326595	athena-oracle-2023.23.1.jar
3391042145 32555838	athena-postgresql-2023.23.1.jar
3098950993 35795871	athena-redis-2023.23.1.jar
1705345234 33566775	athena-redshift-2023.23.1.jar
2918910604 33255063	athena-saphana-2023.23.1.jar
3597893851 64784931	athena-snowflake-2023.23.1.jar
376910993 32876498	athena-sqlserver-2023.23.1.jar
4218250327 35086709	athena-synapse-2023.23.1.jar
3438171591 31482586	athena-teradata-2023.23.1.jar
2884646235 31780576	athena-timestream-2023.23.1.jar
2615465782 31317177	athena-tpcds-2023.23.1.jar
3962609183 30644624	athena-udfs-2023.23.1.jar
633270923 32547467	athena-vertica-2023.23.1.jar

Athena Federation Connector Lambda zips

CheckSum	File
3557087728 86102350	athena-gcs.zip
4126003434 81525659	athena-saphana.zip

What's Changed

• fixing test in mysql record handler
• fixing mysql connector syntax for top N
• Federation Release Tests Support
• build(deps): bump grpc-google-cloud-bigquerystorage-v1
• build(deps): bump redshift-jdbc42 from 2.1.0.14 to 2.1.0.15
• build(deps): bump google-cloud-resourcemanager from 1.19.0 to 1.20.0
• build(deps): bump maven-dependency-plugin from 3.5.0 to 3.6.0
• build(deps): bump snowflake-jdbc from 3.13.30 to 3.13.32
• build(deps): bump maven-checkstyle-plugin from 3.2.2 to 3.3.0
• build(deps): bump netty.version from 4.1.92.Final to 4.1.93.Final
• build(deps): bump jsii-runtime from 1.81.0 to 1.82.0
• build(deps): bump guava from 31.1-jre to 32.0.0-jre
• build(deps): bump protobuf-java from 3.23.1 to 3.23.2
• build(deps): bump aws-cdk.version from 1.201.0 to 1.202.0
• build(deps): bump aws-sdk.version from 1.12.472 to 1.12.477
• Get rid of powermock and mockito.legacy.version entirely (#1304)
• Remove powermockito dependency (#1303)
• CMDB connector - Add RDS database tags to output
• CMDB connector - Add EC2 instance tags to output

Full Changelog: https://github.com/awslabs/aws-athena-query-federation/compare/v2023.21.1..v2023.23.1

Release v2023.21.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.

Athena Federation SDK jars

CheckSum	File
1690208522 28347289	aws-athena-federation-sdk-2023.21.1-withdep.jar
1005161756 634436	aws-athena-federation-sdk-2023.21.1.jar

Athena Federation Connector Lambda jars

CheckSum	File
4187038276 42532608	athena-aws-cmdb-2023.21.1.jar
3544631682 46518146	athena-cloudera-hive-2023.21.1.jar
3380646772 42314574	athena-cloudera-impala-2023.21.1.jar
1883265228 37185074	athena-cloudwatch-2023.21.1.jar
2813726154 31104447	athena-cloudwatch-metrics-2023.21.1.jar
2895926605 32772667	athena-datalakegen2-2023.21.1.jar
1488926333 38051433	athena-db2-2023.21.1.jar
3660485697 37048440	athena-db2-as400-2023.21.1.jar
1577504555 32925127	athena-docdb-2023.21.1.jar
1647527936 32699553	athena-dynamodb-2023.21.1.jar
3212090398 57767210	athena-elasticsearch-2023.21.1.jar
1596995775 92570711	athena-gcs-2023.21.1.jar
3339532380 76893554	athena-google-bigquery-2023.21.1.jar
2282917363 93657478	athena-hbase-2023.21.1.jar
407268895 46518621	athena-hortonworks-hive-2023.21.1.jar
2936631416 44195996	athena-kafka-2023.21.1.jar
741871505 50958920	athena-msk-2023.21.1.jar
2139451681 35581051	athena-mysql-2023.21.1.jar
802537626 55175060	athena-neptune-2023.21.1.jar
1020970840 38226936	athena-oracle-2023.21.1.jar
2019887408 32470379	athena-postgresql-2023.21.1.jar
2386562056 35696049	athena-redis-2023.21.1.jar
3813937711 33481318	athena-redshift-2023.21.1.jar
732494354 33155301	athena-saphana-2023.21.1.jar
989172261 64657561	athena-snowflake-2023.21.1.jar
3433546782 32776688	athena-sqlserver-2023.21.1.jar
2376153134 34986927	athena-synapse-2023.21.1.jar
171054217 31382929	athena-teradata-2023.21.1.jar
951922206 31681683	athena-timestream-2023.21.1.jar
2787926194 31218284	athena-tpcds-2023.21.1.jar
3933836104 30545732	athena-udfs-2023.21.1.jar
1114480815 32448575	athena-vertica-2023.21.1.jar

Athena Federation Connector Lambda zips

CheckSum	File
2059181378 86261605	athena-gcs.zip
3193196094 81504111	athena-saphana.zip

What's Changed

• build(deps): bump grpc-google-cloud-bigquerystorage-v1
• build(deps): bump protobuf-java from 3.23.0 to 3.23.1
• build(deps): bump maven-source-plugin from 3.2.1 to 3.3.0
• build(deps): bump testng from 7.7.1 to 7.8.0
• build(deps): bump fasterxml.jackson.version from 2.15.0 to 2.15.1
• build(deps): bump gremlinDriverVersion from 3.6.3 to 3.6.4
• build(deps): bump maven-assembly-plugin from 3.5.0 to 3.6.0
• build(deps): bump aws-sdk.version from 1.12.470 to 1.12.472
• build(deps): bump google-cloud-bigquery from 2.25.0 to 2.26.1
• fixing jdbc metadata handler to appropriately call extended classes
• Bump serde to v4 for pushdown enhancement release
• Merge pull request #1271 from awslabs/neptune-predicate-issue
• Removed faulty gremlin predicates in favor of engine-side filtering
• AthenaUDFHandler - Handle null input
• build(deps): bump google-cloud-storage from 2.22.1 to 2.22.2
• build(deps): bump protobuf-java from 3.22.4 to 3.23.0
• build(deps): bump aws-cdk.version from 1.200.0 to 1.201.0 (#1266)
• build(deps): bump google-cloud-resourcemanager from 1.18.0 to 1.19.0

Full Changelog: https://github.com/awslabs/aws-athena-query-federation/compare/v2023.20.1..v2023.21.1

Release v2023.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.

Athena Federation SDK jars

CheckSum	File
381876613 28339665	aws-athena-federation-sdk-2023.20.1-withdep.jar
1111838295 634433	aws-athena-federation-sdk-2023.20.1.jar

Athena Federation Connector Lambda jars

CheckSum	File
2140824332 42524637	athena-aws-cmdb-2023.20.1.jar
1009667494 46510419	athena-cloudera-hive-2023.20.1.jar
2896325017 42306846	athena-cloudera-impala-2023.20.1.jar
3335630840 37207476	athena-cloudwatch-2023.20.1.jar
702929454 31096825	athena-cloudwatch-metrics-2023.20.1.jar
2920649281 32764942	athena-datalakegen2-2023.20.1.jar
666153168 38043706	athena-db2-2023.20.1.jar
2311640412 37040714	athena-db2-as400-2023.20.1.jar
764385202 32917503	athena-docdb-2023.20.1.jar
1390282296 32691931	athena-dynamodb-2023.20.1.jar
3840471830 57759588	athena-elasticsearch-2023.20.1.jar
4167537908 92294301	athena-gcs-2023.20.1.jar
3188974307 76870588	athena-google-bigquery-2023.20.1.jar
3493648210 93624004	athena-hbase-2023.20.1.jar
1412952504 46510895	athena-hortonworks-hive-2023.20.1.jar
2531831969 44188371	athena-kafka-2023.20.1.jar
1258557923 50951297	athena-msk-2023.20.1.jar
3797024649 35547475	athena-mysql-2023.20.1.jar
2836079367 55167375	athena-neptune-2023.20.1.jar
3393989816 38219210	athena-oracle-2023.20.1.jar
2429831669 32462654	athena-postgresql-2023.20.1.jar
3225778621 35688424	athena-redis-2023.20.1.jar
903921159 33473592	athena-redshift-2023.20.1.jar
513146313 33147576	athena-saphana-2023.20.1.jar
1124460521 64649835	athena-snowflake-2023.20.1.jar
2359965131 32768962	athena-sqlserver-2023.20.1.jar
3294692532 34979201	athena-synapse-2023.20.1.jar
421215128 31375204	athena-teradata-2023.20.1.jar
3343674206 31674061	athena-timestream-2023.20.1.jar
719601274 31210660	athena-tpcds-2023.20.1.jar
3889028518 30538064	athena-udfs-2023.20.1.jar
2143843396 32440951	athena-vertica-2023.20.1.jar

Athena Federation Connector Lambda zips

CheckSum	File
2832834591 85999523	athena-gcs.zip
914441348 81458436	athena-saphana.zip

What's Changed

• build(deps): bump jsii-runtime from 1.80.0 to 1.81.0
• build(deps): bump aws-sdk.version from 1.12.467 to 1.12.470
• Amazon Athena DB2AS400 Connector (#1245)
• make hortonworks hive compatible with java 8 (#1272)
• predicate-pushdown changes
• LocalKeyFactory: Don't block forever (#1262)
• Address overlap in limit + top n for dynamodb

Full Changelog: https://github.com/awslabs/aws-athena-query-federation/compare/v2023.19.1..v2023.20.1

Release v2023.19.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.

Athena Federation SDK jars

CheckSum	File
1615228563 28335847	aws-athena-federation-sdk-2023.19.1-withdep.jar
3440995421 633606	aws-athena-federation-sdk-2023.19.1.jar

Athena Federation Connector Lambda jars

CheckSum	File
977586425 42520823	athena-aws-cmdb-2023.19.1.jar
2975472402 46504197	athena-cloudera-hive-2023.19.1.jar
2452274015 42300673	athena-cloudera-impala-2023.19.1.jar
1824430883 37203654	athena-cloudwatch-2023.19.1.jar
689499447 31093009	athena-cloudwatch-metrics-2023.19.1.jar
939348079 32758780	athena-datalakegen2-2023.19.1.jar
3709944553 38037530	athena-db2-2023.19.1.jar
3370275175 32913686	athena-docdb-2023.19.1.jar
3046859182 32688020	athena-dynamodb-2023.19.1.jar
1615184211 57755770	athena-elasticsearch-2023.19.1.jar
2731680693 92290486	athena-gcs-2023.19.1.jar
3901094843 76860411	athena-google-bigquery-2023.19.1.jar
1087209496 93620188	athena-hbase-2023.19.1.jar
3182399407 46504710	athena-hortonworks-hive-2023.19.1.jar
4008766160 44184555	athena-kafka-2023.19.1.jar
4242766700 50947479	athena-msk-2023.19.1.jar
2807309242 35543658	athena-mysql-2023.19.1.jar
2607016906 55163559	athena-neptune-2023.19.1.jar
2737443167 38213058	athena-oracle-2023.19.1.jar
1289712258 32458836	athena-postgresql-2023.19.1.jar
3997393660 35684607	athena-redis-2023.19.1.jar
457027066 33469775	athena-redshift-2023.19.1.jar
1106792966 33141434	athena-saphana-2023.19.1.jar
1081002397 64643922	athena-snowflake-2023.19.1.jar
3078081075 32763114	athena-sqlserver-2023.19.1.jar
3224363014 34973109	athena-synapse-2023.19.1.jar
2061313525 31367017	athena-teradata-2023.19.1.jar
123111891 31670244	athena-timestream-2023.19.1.jar
2778933493 31206843	athena-tpcds-2023.19.1.jar
2564246887 30534244	athena-udfs-2023.19.1.jar
473174478 32437134	athena-vertica-2023.19.1.jar

Athena Federation Connector Lambda zips

CheckSum	File
554522567 86001831	athena-gcs.zip
1672179533 81468539	athena-saphana.zip

What's Changed

• build(deps): bump gremlinDriverVersion from 3.6.2 to 3.6.3
• build(deps): bump surefire.failsafe.version from 3.0.0 to 3.1.0
• build(deps): bump license-maven-plugin from 2.0.0 to 2.0.1
• build(deps): bump aws-sdk.version from 1.12.459 to 1.12.467 (#1260)
• build(deps): bump aws-sdk.version from 1.12.459 to 1.12.464
• build(deps): bump protobuf-java from 3.22.3 to 3.22.4
• Modified partitioning logic in Snowflake
• Modified partitioning logic to return a single split for lesser number of records
• Modified partitioning logic in Snowflake Connector
• build(deps): bump maven-gpg-plugin from 3.0.1 to 3.1.0
• gracefully exit get data stream name for ES version that does not support data stream (#1258)
• Add back publish.sh script in case customers are using it
• Remove publish.sh script in favor of the native sam deploy command. Update all references to it across the repo

Full Changelog: https://github.com/awslabs/aws-athena-query-federation/compare/v2023.18.1..v2023.19.1

Release v2023.18.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.

Athena Federation SDK jars

CheckSum	File
891182733 28294338	aws-athena-federation-sdk-2023.18.1-withdep.jar
3259058121 633602	aws-athena-federation-sdk-2023.18.1.jar

Athena Federation Connector Lambda jars

CheckSum	File
1289099269 42451291	athena-aws-cmdb-2023.18.1.jar
2932678151 46462687	athena-cloudera-hive-2023.18.1.jar
1021079053 42259163	athena-cloudera-impala-2023.18.1.jar
1911951404 37162482	athena-cloudwatch-2023.18.1.jar
2088111097 31050526	athena-cloudwatch-metrics-2023.18.1.jar
249684480 32717271	athena-datalakegen2-2023.18.1.jar
316277651 37996021	athena-db2-2023.18.1.jar
3361730298 32872176	athena-docdb-2023.18.1.jar
2565813415 32646512	athena-dynamodb-2023.18.1.jar
108435683 57714092	athena-elasticsearch-2023.18.1.jar
3209046396 92248977	athena-gcs-2023.18.1.jar
2466050806 76818901	athena-google-bigquery-2023.18.1.jar
2988867416 93553241	athena-hbase-2023.18.1.jar
2357555302 46463201	athena-hortonworks-hive-2023.18.1.jar
3258943047 44143044	athena-kafka-2023.18.1.jar
2455064608 50905970	athena-msk-2023.18.1.jar
1209696122 35502148	athena-mysql-2023.18.1.jar
3676385385 55075875	athena-neptune-2023.18.1.jar
3638120251 38171548	athena-oracle-2023.18.1.jar
543602779 32417327	athena-postgresql-2023.18.1.jar
2034809379 35643098	athena-redis-2023.18.1.jar
3773260484 33428266	athena-redshift-2023.18.1.jar
1952291644 33099927	athena-saphana-2023.18.1.jar
1307808253 64602545	athena-snowflake-2023.18.1.jar
3953448674 32721605	athena-sqlserver-2023.18.1.jar
3175962678 34931600	athena-synapse-2023.18.1.jar
1090587291 31325508	athena-teradata-2023.18.1.jar
3590870538 31628737	athena-timestream-2023.18.1.jar
3974706684 31165334	athena-tpcds-2023.18.1.jar
3690632561 30492735	athena-udfs-2023.18.1.jar
2660307944 32395625	athena-vertica-2023.18.1.jar

Athena Federation Connector Lambda zips

CheckSum	File
3417011914 85955220	athena-gcs.zip
1770185226 81324705	athena-saphana.zip

What's Changed

• support querying tables across databases for cloudera-hive (#1243)
• add data stream support for elasticsearch
• adding equals, toString, and hashCode to GetDataSourceCapabilitiesRequest
• [JDBC Fix] IN predicate with variable expression formed malformed SQL
• build(deps): bump ngdbc from 2.16.11 to 2.16.14 (#1238)
• build(deps): bump google-cloud-bigquery from 2.24.5 to 2.25.0 (#1237)
• build(deps): bump netty.version from 4.1.91.Final to 4.1.92.Final (#1236)
• build(deps): bump junit-bom from 5.9.2 to 5.9.3 (#1235)
• build(deps): bump google-cloud-resourcemanager from 1.17.0 to 1.18.0 (#1234)
• build(deps): bump google-cloud-storage from 2.22.0 to 2.22.1 (#1233)
• build(deps): bump jacoco-maven-plugin from 0.8.8 to 0.8.10 (#1232)
• build(deps): bump grpc-google-cloud-bigquerystorage-v1 (#1231)
• build(deps): bump aws-sdk.version from 1.12.454 to 1.12.459 (#1230)
• build(deps): bump aws-cdk.version from 1.199.0 to 1.200.0 (#1229)

Full Changelog: https://github.com/awslabs/aws-athena-query-federation/compare/v2023.17.1..v2023.18.1

Release v2023.17.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.

Athena Federation SDK jars

CheckSum	File
1347508576 28204059	aws-athena-federation-sdk-2023.17.1-withdep.jar
612794459 632953	aws-athena-federation-sdk-2023.17.1.jar

Athena Federation Connector Lambda jars

CheckSum	File
2523859470 42354958	athena-aws-cmdb-2023.17.1.jar
1081009721 46372407	athena-cloudera-hive-2023.17.1.jar
3289367499 42168922	athena-cloudera-impala-2023.17.1.jar
4194990004 37072216	athena-cloudwatch-2023.17.1.jar
3746831661 30960250	athena-cloudwatch-metrics-2023.17.1.jar
1409805175 32627030	athena-datalakegen2-2023.17.1.jar
1445443224 37905779	athena-db2-2023.17.1.jar
4008388562 32781898	athena-docdb-2023.17.1.jar
3880963363 32556234	athena-dynamodb-2023.17.1.jar
542406834 57622449	athena-elasticsearch-2023.17.1.jar
1304162774 92158560	athena-gcs-2023.17.1.jar
2507045251 76536391	athena-google-bigquery-2023.17.1.jar
1293450867 93463015	athena-hbase-2023.17.1.jar
2456525496 46372957	athena-hortonworks-hive-2023.17.1.jar
3233168544 44052763	athena-kafka-2023.17.1.jar
3208987169 50815689	athena-msk-2023.17.1.jar
2738725878 35411907	athena-mysql-2023.17.1.jar
3172962310 54985595	athena-neptune-2023.17.1.jar
911523890 38081307	athena-oracle-2023.17.1.jar
1474493344 32327085	athena-postgresql-2023.17.1.jar
1813767336 35552819	athena-redis-2023.17.1.jar
2930012371 33338024	athena-redshift-2023.17.1.jar
2909145328 33009686	athena-saphana-2023.17.1.jar
1775614847 64512304	athena-snowflake-2023.17.1.jar
1951901067 32631363	athena-sqlserver-2023.17.1.jar
286207120 34841359	athena-synapse-2023.17.1.jar
1333293987 31235268	athena-teradata-2023.17.1.jar
2191864685 31538456	athena-timestream-2023.17.1.jar
1302806756 31075055	athena-tpcds-2023.17.1.jar
3923748428 30402456	athena-udfs-2023.17.1.jar
1357193872 32305346	athena-vertica-2023.17.1.jar

Athena Federation Connector Lambda zips

CheckSum	File
3944086861 85879769	athena-gcs.zip
2443890447 81099258	athena-saphana.zip

What's Changed

• [Bug Fix] [athena-cloudwatch] Stop lowercasing all schemas and tables, fix data integrity issue
• athena-timestream: Add pagination for doListTables
• Add PaginatedRequestIterator
• [Timestream] Add case-insensitive lookup to allow queries against cased dbs/tables to succeed
• build(deps): bump aws-cdk.version from 1.198.1 to 1.199.0 (#1219)
• build(deps): bump fasterxml.jackson.version from 2.14.2 to 2.15.0 (#1221)
• build(deps): bump vertica-jdbc from 12.0.3-0 to 12.0.4-0 (#1225)
• build(deps): bump mysql-connector-j from 8.0.32 to 8.0.33 (#1224)
• build(deps): bump snowflake-jdbc from 3.13.29 to 3.13.30 (#1223)
• build(deps): bump maven-checkstyle-plugin from 3.2.1 to 3.2.2 (#1222)
• build(deps): bump lettuce-core from 6.2.3.RELEASE to 6.2.4.RELEASE (#1220)
• build(deps): bump aws-sdk.version from 1.12.450 to 1.12.454 (#1218)
• Update cut_release.yml (#1217)

Full Changelog: https://github.com/awslabs/aws-athena-query-federation/compare/v2023.16.2..v2023.17.1

Release v2023.16.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.

Athena Federation SDK jars

CheckSum	File
774421089 28095323	aws-athena-federation-sdk-2023.16.2-withdep.jar
1407983997 631548	aws-athena-federation-sdk-2023.16.2.jar

Athena Federation Connector Lambda jars

CheckSum	File
189731503 42246222	athena-aws-cmdb-2023.16.2.jar
364297972 46263671	athena-cloudera-hive-2023.16.2.jar
4090968800 42060185	athena-cloudera-impala-2023.16.2.jar
1218694276 36976933	athena-cloudwatch-2023.16.2.jar
4182206810 30851513	athena-cloudwatch-metrics-2023.16.2.jar
929912942 32518294	athena-datalakegen2-2023.16.2.jar
2893322158 37797043	athena-db2-2023.16.2.jar
2614192738 32673161	athena-docdb-2023.16.2.jar
310525440 32447497	athena-dynamodb-2023.16.2.jar
3456732252 57513716	athena-elasticsearch-2023.16.2.jar
3552026413 92049823	athena-gcs-2023.16.2.jar
1386494255 76427655	athena-google-bigquery-2023.16.2.jar
227268333 93354860	athena-hbase-2023.16.2.jar
1207377530 46264221	athena-hortonworks-hive-2023.16.2.jar
1287185985 43943674	athena-kafka-2023.16.2.jar
2792742500 50706595	athena-msk-2023.16.2.jar
2417662932 35302432	athena-mysql-2023.16.2.jar
404986945 54876858	athena-neptune-2023.16.2.jar
1678361833 37972571	athena-oracle-2023.16.2.jar
4019388370 32218349	athena-postgresql-2023.16.2.jar
3484660406 35433670	athena-redis-2023.16.2.jar
4245139591 33229288	athena-redshift-2023.16.2.jar
380990994 32901095	athena-saphana-2023.16.2.jar
3955655256 64411673	athena-snowflake-2023.16.2.jar
2722421933 32522627	athena-sqlserver-2023.16.2.jar
2725779463 34732623	athena-synapse-2023.16.2.jar
189912743 31126531	athena-teradata-2023.16.2.jar
3320115182 31427588	athena-timestream-2023.16.2.jar
3502614897 30966318	athena-tpcds-2023.16.2.jar
886541438 30293720	athena-udfs-2023.16.2.jar
415576451 32178276	athena-vertica-2023.16.2.jar

Athena Federation Connector Lambda zips

CheckSum	File
1549641596 85786007	athena-gcs.zip
1782627894 80817953	athena-saphana.zip

What's Changed

• Drop SerDe version to 2 for connectors until Athena Engine V2 receives resolution fix
• build(deps): bump ImpalaJDBC42 from 2.6.29.1035 to 2.6.30.1036 (#1215)
• build(deps): bump msal4j from 1.13.7 to 1.13.8 (#1214)
• build(deps): bump grpc-google-cloud-bigquerystorage-v1 from 2.34.2 to 2.35.0 (#1211)
• build(deps): bump google-cloud-bigquery from 2.24.4 to 2.24.5 (#1208)
• build(deps): bump google-cloud-resourcemanager from 1.16.0 to 1.17.0 (#1207)
• build(deps): bump redshift-jdbc42 from 2.1.0.13 to 2.1.0.14 (#1206)
• build(deps): bump jetty.version from 11.0.14 to 11.0.15 (#1205)
• build(deps): bump hbase.version from 2.5.3-hadoop3 to 2.5.4-hadoop3 (#1204)
• build(deps): bump google-cloud-storage from 2.21.0 to 2.22.0 (#1203)
• build(deps): bump aws-sdk.version from 1.12.445 to 1.12.450

Full Changelog: https://github.com/awslabs/aws-athena-query-federation/compare/v2023.16.1..v2023.16.2