Glue Jobs fail with ERROR when AvailabilityZone is specified

[evilensky]

CloudFormation Lint Version

1.12.3

What operating system are you using?

Mac and Linux

Describe the bug

GlueConnections fail linting when az is specified:

INFO     cfnlint.runner:runner.py:125 Run scan of template tests/data/integration/based-on-poc-serverless-service.yml
ERROR    lint_cfn:lint_cfn.py:17 W3010: Availability zone properties should not be hardcoded: Avoid hardcoding availability zones 'us-west-2c'
 at:Resources/AlsoPoliticianProcessingDefaultGlueConnection/Properties/ConnectionInput/PhysicalConnectionRequirements/AvailabilityZone

https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-glue-connection-physicalconnectionrequirements.html#cfn-glue-connection-physicalconnectionrequirements-availabilityzone

What's not documented is that AvailabilityZone is required if SecurityGroupIdList[] is provided or the Glue Connection silently fails.

Expected behavior

Should not lint as error.

Reproduction template

Resources:
  AlsoPoliticianProcessingDefaultGlueConnection:
    Properties:
      CatalogId:
        Ref: AWS::AccountId
      ConnectionInput:
        ConnectionType: NETWORK
        Description: Default VPC Connection for job also-politician-processing
        Name: tools-dev-poc-serverless-service-also-politician-processing-network
        PhysicalConnectionRequirements:
          AvailabilityZone: us-west-2c
          SecurityGroupIdList:
          - Fn::ImportValue: DefaultGlueSecurityGroupId
          SubnetId:
            Fn::ImportValue: DefaultGlueSubnetId