Release v2023.37.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
1581595861 28625274	aws-athena-federation-sdk-2023.37.2-withdep.jar
1645852768 634517	aws-athena-federation-sdk-2023.37.2.jar

Athena Federation Connector Lambda jars

CheckSum	File
2863410565 42942905	athena-aws-cmdb-2023.37.2.jar
1632036628 46798014	athena-cloudera-hive-2023.37.2.jar
4175879463 42594324	athena-cloudera-impala-2023.37.2.jar
926850889 37530842	athena-cloudwatch-2023.37.2.jar
3823294834 31382452	athena-cloudwatch-metrics-2023.37.2.jar
3185773225 33063218	athena-datalakegen2-2023.37.2.jar
4100608823 38331188	athena-db2-2023.37.2.jar
501131673 41000820	athena-db2-as400-2023.37.2.jar
4135362500 33203208	athena-docdb-2023.37.2.jar
2188923238 32981511	athena-dynamodb-2023.37.2.jar
3283793188 58045200	athena-elasticsearch-2023.37.2.jar
1039410120 127752790	athena-gcs-2023.37.2.jar
1355658190 80786947	athena-google-bigquery-2023.37.2.jar
2216420620 99443230	athena-hbase-2023.37.2.jar
103872138 46798370	athena-hortonworks-hive-2023.37.2.jar
2417677562 44572447	athena-kafka-2023.37.2.jar
3908404194 51477886	athena-msk-2023.37.2.jar
2634068193 36004383	athena-mysql-2023.37.2.jar
2411127899 58544737	athena-neptune-2023.37.2.jar
2879929587 38506789	athena-oracle-2023.37.2.jar
2565794330 32737318	athena-postgresql-2023.37.2.jar
3242233638 35989490	athena-redis-2023.37.2.jar
3952700178 33754155	athena-redshift-2023.37.2.jar
2956888908 33439599	athena-saphana-2023.37.2.jar
4125700773 99717006	athena-snowflake-2023.37.2.jar
1113315752 33067377	athena-sqlserver-2023.37.2.jar
2948417270 35281233	athena-synapse-2023.37.2.jar
3578970486 31662782	athena-teradata-2023.37.2.jar
1422717410 31973057	athena-timestream-2023.37.2.jar
1901599001 31496271	athena-tpcds-2023.37.2.jar
2172752796 30824267	athena-udfs-2023.37.2.jar
1973274719 32726563	athena-vertica-2023.37.2.jar

Athena Federation Connector Lambda zips

CheckSum	File
2524542893 89819944	athena-gcs.zip
4032795307 82252014	athena-saphana.zip

What's Changed

• Excluding large Mac/Windows Statically compiled files (#1475)
• build(deps): bump actions/checkout from 3 to 4 (#1470)
• build(deps): bump maven-shade-plugin from 3.4.1 to 3.5.0 (#1356)

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

Release v2023.37.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
1096039975 28625274	aws-athena-federation-sdk-2023.37.1-withdep.jar
546866426 634517	aws-athena-federation-sdk-2023.37.1.jar

Athena Federation Connector Lambda jars

CheckSum	File
841274181 42942906	athena-aws-cmdb-2023.37.1.jar
1614332810 46798013	athena-cloudera-hive-2023.37.1.jar
3736438253 42594322	athena-cloudera-impala-2023.37.1.jar
3562604713 37530841	athena-cloudwatch-2023.37.1.jar
2872939371 31382451	athena-cloudwatch-metrics-2023.37.1.jar
2428861763 33063217	athena-datalakegen2-2023.37.1.jar
441437225 38331189	athena-db2-2023.37.1.jar
660450840 41000820	athena-db2-as400-2023.37.1.jar
834791150 33203208	athena-docdb-2023.37.1.jar
3143760313 32981509	athena-dynamodb-2023.37.1.jar
2559083918 58045199	athena-elasticsearch-2023.37.1.jar
571851035 127752790	athena-gcs-2023.37.1.jar
264545956 80786943	athena-google-bigquery-2023.37.1.jar
1358981333 99443229	athena-hbase-2023.37.1.jar
397846694 46798369	athena-hortonworks-hive-2023.37.1.jar
252888566 44572446	athena-kafka-2023.37.1.jar
3689519195 51477886	athena-msk-2023.37.1.jar
1758284246 36004384	athena-mysql-2023.37.1.jar
112214389 58544735	athena-neptune-2023.37.1.jar
2494015390 38506788	athena-oracle-2023.37.1.jar
893904487 32737317	athena-postgresql-2023.37.1.jar
590650651 35989490	athena-redis-2023.37.1.jar
754923814 33754153	athena-redshift-2023.37.1.jar
2374535700 33439599	athena-saphana-2023.37.1.jar
4141882085 99717003	athena-snowflake-2023.37.1.jar
403354391 33067379	athena-sqlserver-2023.37.1.jar
185342563 35281232	athena-synapse-2023.37.1.jar
3294271204 31662782	athena-teradata-2023.37.1.jar
3209886677 31973057	athena-timestream-2023.37.1.jar
3391644657 31496272	athena-tpcds-2023.37.1.jar
3500708430 30824271	athena-udfs-2023.37.1.jar
2629000708 32726564	athena-vertica-2023.37.1.jar

Athena Federation Connector Lambda zips

CheckSum	File
215581243 121241340	athena-gcs.zip
1830036467 82252028	athena-saphana.zip

What's Changed

• Modified JDBC connectors to fetch metadata from underlying system tables. (#1463)
• build(deps): bump com.google.api.grpc:grpc-google-cloud-bigquerystorage-v1 from 2.41.0 to 2.41.1 (#1443)
• build(deps): bump io.lettuce:lettuce-core from 6.2.5.RELEASE to 6.2.6.RELEASE (#1440)
• build(deps): bump net.snowflake:snowflake-jdbc from 3.13.33 to 3.14.1 (#1437)
• build(deps): bump com.amazonaws:aws-lambda-java-core from 1.2.2 to 1.2.3 (#1446)
• build(deps): bump slf4j-log4j.version from 2.0.7 to 2.0.9 (#1455)
• build(deps): bump org.apache.directory.api:api-ldap-model from 2.1.3 to 2.1.4 (#1458)
• build(deps): bump com.google.protobuf:protobuf-java from 3.24.1 to 3.24.3 (#1469)
• build(deps): bump org.yaml:snakeyaml from 2.1 to 2.2 (#1441)
• build(deps): bump junit:junit from 4.13.1 to 4.13.2 (#1439)
• build(deps): bump com.google.cloud:google-cloud-resourcemanager from 1.23.0 to 1.25.0 (#1435)
• build(deps): bump net.sf.jt400:jt400 from 20.0.0 to 20.0.2 (#1436)
• build(deps): bump com.microsoft.sqlserver:mssql-jdbc from 11.2.3.jre11 to 12.4.1.jre11 (#1459)
• build(deps): bump aws-sdk.version from 1.12.533 to 1.12.548 (#1474)
• build(deps): bump com.google.guava:guava from 32.1.1-jre to 32.1.2-jre (#1444)
• build(deps): bump org.apache.commons:commons-lang3 from 3.12.0 to 3.13.0 (#1460)
• build(deps): bump net.jqwik:jqwik from 1.7.4 to 1.8.0 (#1461)
• build(deps): bump aws-sdk.version from 1.12.533 to 1.12.547 (#1465)
• build(deps): bump com.google.cloud:google-cloud-bigquery from 2.30.1 to 2.31.2 (#1467)
• Transition to AES-GCM for UDFs (#708)
• build(deps): bump org.eclipse.jetty:jetty-xml from 11.0.15 to 11.0.16 in /athena-hbase (#1472)
• Revert revert arrow13 (#1471)

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

Release v2023.35.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
372925953 28550974	aws-athena-federation-sdk-2023.35.2-withdep.jar
372517103 634416	aws-athena-federation-sdk-2023.35.2.jar

Athena Federation Connector Lambda jars

CheckSum	File
1932643615 42858026	athena-aws-cmdb-2023.35.2.jar
293027382 46723159	athena-cloudera-hive-2023.35.2.jar
1142183150 42519468	athena-cloudera-impala-2023.35.2.jar
181589760 37456543	athena-cloudwatch-2023.35.2.jar
4284190126 31308151	athena-cloudwatch-metrics-2023.35.2.jar
3882818219 32977675	athena-datalakegen2-2023.35.2.jar
2486540721 38256333	athena-db2-2023.35.2.jar
3030948220 40918033	athena-db2-as400-2023.35.2.jar
3349210857 33128846	athena-docdb-2023.35.2.jar
2571216065 32907212	athena-dynamodb-2023.35.2.jar
55189033 57970902	athena-elasticsearch-2023.35.2.jar
2562898095 93079562	athena-gcs-2023.35.2.jar
2209608741 80216691	athena-google-bigquery-2023.35.2.jar
2939019390 99366058	athena-hbase-2023.35.2.jar
2464299046 46723515	athena-hortonworks-hive-2023.35.2.jar
3363092068 44498307	athena-kafka-2023.35.2.jar
2302843261 51403747	athena-msk-2023.35.2.jar
2793777817 35929427	athena-mysql-2023.35.2.jar
3989285589 58470284	athena-neptune-2023.35.2.jar
2049678913 38431934	athena-oracle-2023.35.2.jar
442245499 32661209	athena-postgresql-2023.35.2.jar
3123169186 35908264	athena-redis-2023.35.2.jar
1668770068 33678046	athena-redshift-2023.35.2.jar
4154888265 33364745	athena-saphana-2023.35.2.jar
450339616 63551815	athena-snowflake-2023.35.2.jar
1329316237 32981835	athena-sqlserver-2023.35.2.jar
3222040843 35195690	athena-synapse-2023.35.2.jar
1130586443 31587928	athena-teradata-2023.35.2.jar
334039315 31898758	athena-timestream-2023.35.2.jar
3822381963 31421972	athena-tpcds-2023.35.2.jar
797077907 30749418	athena-udfs-2023.35.2.jar
1228715413 32652264	athena-vertica-2023.35.2.jar

Athena Federation Connector Lambda zips

CheckSum	File
2365470789 86735295	athena-gcs.zip
2841632475 82056760	athena-saphana.zip

What's Changed

• Fix dynamic filter date on timezone issue. (#1453)
• Revert "Use Arrow 13 (#1447)"
• Use Arrow 13 (#1447)

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

Release v2023.35.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
1520978532 28596583	aws-athena-federation-sdk-2023.35.1-withdep.jar
2204608942 634413	aws-athena-federation-sdk-2023.35.1.jar

Athena Federation Connector Lambda jars

CheckSum	File
18914014 42903635	athena-aws-cmdb-2023.35.1.jar
200223358 46768637	athena-cloudera-hive-2023.35.1.jar
986079504 42564948	athena-cloudera-impala-2023.35.1.jar
2453348995 37502151	athena-cloudwatch-2023.35.1.jar
720226005 31353760	athena-cloudwatch-metrics-2023.35.1.jar
2143582341 33023155	athena-datalakegen2-2023.35.1.jar
1438945815 38301814	athena-db2-2023.35.1.jar
727827244 40963513	athena-db2-as400-2023.35.1.jar
1126528275 33174455	athena-docdb-2023.35.1.jar
4261502980 32952820	athena-dynamodb-2023.35.1.jar
3495285544 58016508	athena-elasticsearch-2023.35.1.jar
3878056401 93125170	athena-gcs-2023.35.1.jar
4150760914 80262167	athena-google-bigquery-2023.35.1.jar
3288242796 99411665	athena-hbase-2023.35.1.jar
1087381938 46768993	athena-hortonworks-hive-2023.35.1.jar
2846871532 44543913	athena-kafka-2023.35.1.jar
72827178 51449353	athena-msk-2023.35.1.jar
976825298 35974907	athena-mysql-2023.35.1.jar
3956252628 58515896	athena-neptune-2023.35.1.jar
3870090773 38477415	athena-oracle-2023.35.1.jar
3478621045 32706689	athena-postgresql-2023.35.1.jar
1509654762 35953872	athena-redis-2023.35.1.jar
182971298 33723526	athena-redshift-2023.35.1.jar
2535787466 33410225	athena-saphana-2023.35.1.jar
3610004985 63597295	athena-snowflake-2023.35.1.jar
1093722085 33027316	athena-sqlserver-2023.35.1.jar
2754315151 35241170	athena-synapse-2023.35.1.jar
4132981555 31633408	athena-teradata-2023.35.1.jar
2832960869 31944367	athena-timestream-2023.35.1.jar
3140039228 31467582	athena-tpcds-2023.35.1.jar
196239539 30795030	athena-udfs-2023.35.1.jar
2227781070 32697873	athena-vertica-2023.35.1.jar

Athena Federation Connector Lambda zips

CheckSum	File
721778383 86773098	athena-gcs.zip
784331002 82171028	athena-saphana.zip

What's Changed

• build(deps): bump org.junit.support:testng-engine from 1.0.1 to 1.0.4 (#1409)
• build(deps): bump com.google.cloud:google-cloud-storage from 2.24.0 to 2.26.1 (#1421)
• build(deps-dev): bump nl.jqno.equalsverifier:equalsverifier from 3.15 to 3.15.1 (#1412)
• build(deps): bump org.yaml:snakeyaml from 2.0 to 2.1 (#1413)
• build(deps): bump org.apache.zookeeper:zookeeper from 3.8.1 to 3.9.0 (#1405)
• build(deps): bump com.sap.cloud.db.jdbc:ngdbc from 2.17.10 to 2.17.12 (#1407)
• build(deps): bump org.apache.commons:commons-lang3 from 3.12.0 to 3.13.0 (#1406)
• build(deps): bump gremlinDriverVersion from 3.6.4 to 3.7.0 (#1410)
• build(deps): bump com.microsoft.azure:msal4j from 1.13.9 to 1.13.10 (#1420)
• build(deps): bump com.amazon.redshift:redshift-jdbc42 from 2.1.0.17 to 2.1.0.18 (#1408)
• build(deps): bump software.amazon.jsii:jsii-runtime from 1.84.0 to 1.88.0 (#1432)
• build(deps): bump org.apache.zookeeper:zookeeper from 3.8.1 to 3.8.2 (#1391)
• build(deps): bump org.junit:junit-bom from 5.9.3 to 5.10.0 (#1392)
• build(deps): bump com.google.protobuf:protobuf-java from 3.23.4 to 3.24.1 (#1423)
• build(deps): bump software.amazon.msk:aws-msk-iam-auth from 1.1.7 to 1.1.9 (#1425)
• build(deps): bump netty.version from 4.1.93.Final to 4.1.97.Final (#1430)
• Fix case insensitive table name search bug (#1429)
• build(deps): bump org.apache.ivy:ivy from 2.5.1 to 2.5.2 in /athena-neptune (#1427)
• build(deps): bump aws-sdk.version from 1.12.514 to 1.12.533 (#1426)
• changed componenttype to view, and other related changes
• updated table creation script
• documentation update for custom query
• code merge, custom query changes

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

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