title: AWS Glue JDBC connection created with CDK needs password in the console before it becomes valid
body: <p>I am creating a JDBC connection in Glue using secrets for username and password. I can see in the console that username is read correctly from the secret, so that's not a concern. Once I edit the details and enter the password in the console, it becomes valid. Is there something wrong with my approach?</p>
  <pre><code>glue.CfnConnection(
          self,
          id=&quot;JDBCConnection&quot;,
          catalog_id=self.account,
          connection_input=glue.CfnConnection.ConnectionInputProperty(
              name=&quot;jdbc_connection&quot;,
              connection_type=&quot;JDBC&quot;,
              physical_connection_requirements=glue.CfnConnection.PhysicalConnectionRequirementsProperty(
                  subnet_id=cdk.Fn.import_value(&quot;PrivateSubnet1&quot;),
                  security_group_id_list=[jdbc_connection_security_group.attr_group_id],
              ),
              connection_properties={
                  &quot;JDBC_CONNECTION_URL&quot;: &quot;jdbc:&lt;JDBC_URL&gt;&quot;,
                  &quot;USERNAME&quot;: &quot;{{resolve:secretsmanager:jdbc_username}}&quot;,
                  &quot;PASSWORD&quot;: &quot;{{resolve:secretsmanager:jdbc_password}}&quot;,
              },
          ),
  )
  </code></pre>