title: Create a CloudFormation template to create multiple Glue Connections
body: <p>I am trying to create FOUR Glue Connections using Cloud Formation template.</p>
  <p>The template should ideally create all FOUR connections and I could add more if I want to. I have tried using multiple resources, doesn't work.</p>
  <p>But the below code is creating the the connection for the LAST connection only. Here is my Code:</p>
  <pre><code>AWSTemplateFormatVersion: 2010-09-09
  Description: Glue Connection
  Parameters:
    VpcId:
      Description: VPC-ID
      Type: 'AWS::EC2::VPC::Id'
      Default: vpc-xxxxxxxxx
    SecurityGroup:
      Description: SG-ID
      Type: 'AWS::EC2::SecurityGroup::Id'
      Default: sg-xxxxxxxxx
    SubnetRESA1:
      Type: String
      Description: Public Subnet
      Default: subnet-xxxxxxxxx
  Resources:
    GC31IPP:
      Type: 'AWS::Glue::Connection'
      Properties:
        CatalogId: 'a/c_number'
        ConnectionInput:
          ConnectionProperties:
            Name: GENERIC_CONNECTION
            Type: Network
          ConnectionType: NETWORK
          Description: &gt;-
            Adding a Generic connection with VPC, Subnet and Security Group to
            access SAP and other DBs
          Name: GENERIC_CONNECTION
          PhysicalConnectionRequirements:
            AvailabilityZone: us-east-1a
            SecurityGroupIdList:
              - sg-xxxxxxxxx
            SubnetId: subnet-xxxxxxxxx
        ConnectionInput:
          ConnectionProperties:
            Name: MySQL_CONNECTION
            Type: JDBC
            JDBC_CONNECTION_URL: &quot;jdbc:mysql://host-url:3306/db&quot;
            USERNAME: &quot;user&quot;
            PASSWORD: &quot;pass&quot;
          ConnectionType: JDBC
          Description: &gt;-
            MySQL connection to POS DB
          Name: MySQL_CONNECTION
          PhysicalConnectionRequirements:
            AvailabilityZone: us-east-1a
            SecurityGroupIdList:
              - sg-xxxxxxxxx
            SubnetId: subnet-xxxxxxxxx
        ConnectionInput:
          ConnectionProperties:
            Name: SAP_ECC_CONNECTION_Pre-ProdEnv
            Type: JDBC
            JDBC_CONNECTION_URL: &quot;jdbc:sap://host-url:31015/?instanceNumber=10&amp;databaseName=db_name&quot;
            USERNAME: &quot;user&quot;
            PASSWORD: &quot;pass&quot;
          ConnectionType: JDBC
          Description: &gt;-
            SAP ECC Pre Prod connection
          Name: SAP_ECC_CONNECTION_Pre-ProdEnv
          PhysicalConnectionRequirements:
            AvailabilityZone: us-east-1a
            SecurityGroupIdList:
              - sg-xxxxxxxxx
            SubnetId: subnet-xxxxxxxxx
        ConnectionInput:
          ConnectionProperties:
            Name: SAP_QAL_CONNECTION_QAEnv
            Type: JDBC
            JDBC_CONNECTION_URL: &quot;jdbc:sap://host-url:32015/?instanceNumber=20&amp;databaseName=db_name&quot;
            USERNAME: &quot;seru&quot;
            PASSWORD: &quot;pass&quot;
          ConnectionType: JDBC
          Description: &gt;-
            SAP ECC Pre Prod connection
          Name: SAP_QAL_CONNECTION_QAEnv
          PhysicalConnectionRequirements:
            AvailabilityZone: us-east-1a
            SecurityGroupIdList:
              - sg-xxxxxxxxx
            SubnetId: subnet-xxxxxxxxx
  </code></pre>
  <p>The above template is creating only ONE connection i.e. the last one. Named: <code>SAP_QAL_CONNECTION_QAEnv</code>.</p>
  <p>How can I add all of them in a single script?</p>