Is AthenaDynamoDBConnector available for CDK

You can use CfnApplication in the CDK to provision it.

Example code (in typescript):

    import {CfnApplication} from "aws-cdk-lib/aws-sam";

    const spillBucket = new Bucket(this, "SpillBucket")

    new CfnApplication(this, "AthenaToDynamoConnector", {
      location: {
        applicationId: "arn:aws:serverlessrepo:us-east-1:292517598671:applications/AthenaDynamoDBConnector",
        semanticVersion: "2022.34.1"
      },
      parameters: {
        AthenaCatalogName: "somecatalogname",
        SpillBucket: spillBucket.bucketName
      }
    })

AthenaDynamoDBConnector is available in the Serverless Application Repository. Please refer to Deploying a serverless application using AWS CDK to learn more about deploying it through CDK.