The AthenaJdbcConnector serverless application is no longer available on the serverless repo

1

The AthenaJdbcConnector seems to be gone from the aws serverless repo. As a result it is not possible to deploy it.

To reproduce with the CLI:

aws --region us-east-1 serverlessrepo get-application --application-id arn:aws:serverlessrepo:us-east-1:292517598671:applications/AthenaJdbcConnector

An error occurred (AccessDeniedException) when calling the GetApplication operation: User: arn:aws:sts::REDACTED:REDACTED is not authorized to perform: serverlessrepo:GetApplication on resource: arn:aws:serverlessrepo:us-east-1:292517598671:applications/AthenaJdbcConnector

Cloudformation:

AthenaJdbcConnector:
    Type: AWS::Serverless::Application
    Properties:
      Location:
        ApplicationId: arn:aws:serverlessrepo:us-east-1:292517598671:applications/AthenaJdbcConnector
        SemanticVersion: 2022.2.1
      Parameters:
        DefaultConnectionString: !Sub "mysql://jdbc:mysql://${RdsEndpoint}:${RdsPort}/${DatabaseName}?${!${RdsSecretName}}"
        LambdaFunctionName: datacatalogname
        SecretNamePrefix: !Ref RdsSecretName
        SecurityGroupIds: !Ref SecurityGroupId
        SpillBucket: !Ref SpillBucketName
        SubnetIds: !Join [",", [!Ref PrivateSubnet1, !Ref PrivateSubnet2, !Ref PrivateSubnet3]]

Cloudformation Error:

Transform AWS::Serverless-2016-10-31 failed with: Invalid Serverless Application Specification document. Number of errors found: 1. Resource with id [AthenaJdbcConnector] is invalid. User: arn:aws:sts::REDACTED:REDACTED is not authorized to perform: serverlessrepo:CreateCloudFormationTemplate on resource: arn:aws:serverlessrepo:us-east-1:292517598671:applications/AthenaJdbcConnector

Moreover, the web page of the AthenaJdbcConnector while still being indexed by search engines, is no longer available.

While it might seem like a permission error, the fact that the application page is gone and that we get the same error even with a user with admin privileges makes us think that the application was removed/retired/made-private.

1 Answer
2
Accepted Answer

Hello,

The JDBC Connector is a compile-only project which is used as a dependency of several other connectors. As a result, this connector can no longer be deployed on its own as of this PR from February 2022.

If you used to use this connector to run federated queries against PostgreSQL, MySQL, or Amazon Redshift, you can now directly deploy our connectors for each one: PostgreSQL, MySQL, and Amazon Redshift.

profile pictureAWS
answered a year ago
AWS
EXPERT
reviewed a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions