Glue / Client / create_connection

create_connection#

Glue.Client.create_connection(**kwargs)#

Creates a connection definition in the Data Catalog.

Connections used for creating federated resources require the IAM glue:PassConnection permission.

See also: AWS API Documentation

Request Syntax

response = client.create_connection(
    CatalogId='string',
    ConnectionInput={
        'Name': 'string',
        'Description': 'string',
        'ConnectionType': 'JDBC'|'SFTP'|'MONGODB'|'KAFKA'|'NETWORK'|'MARKETPLACE'|'CUSTOM'|'SALESFORCE'|'VIEW_VALIDATION_REDSHIFT'|'VIEW_VALIDATION_ATHENA',
        'MatchCriteria': [
            'string',
        ],
        'ConnectionProperties': {
            'string': 'string'
        },
        'PhysicalConnectionRequirements': {
            'SubnetId': 'string',
            'SecurityGroupIdList': [
                'string',
            ],
            'AvailabilityZone': 'string'
        },
        'AuthenticationConfiguration': {
            'AuthenticationType': 'BASIC'|'OAUTH2'|'CUSTOM',
            'SecretArn': 'string',
            'OAuth2Properties': {
                'OAuth2GrantType': 'AUTHORIZATION_CODE'|'CLIENT_CREDENTIALS'|'JWT_BEARER',
                'OAuth2ClientApplication': {
                    'UserManagedClientApplicationClientId': 'string',
                    'AWSManagedClientApplicationReference': 'string'
                },
                'TokenUrl': 'string',
                'TokenUrlParametersMap': {
                    'string': 'string'
                },
                'AuthorizationCodeProperties': {
                    'AuthorizationCode': 'string',
                    'RedirectUri': 'string'
                }
            }
        },
        'ValidateCredentials': True|False
    },
    Tags={
        'string': 'string'
    }
)
Parameters:
  • CatalogId (string) – The ID of the Data Catalog in which to create the connection. If none is provided, the Amazon Web Services account ID is used by default.

  • ConnectionInput (dict) –

    [REQUIRED]

    A ConnectionInput object defining the connection to create.

    • Name (string) – [REQUIRED]

      The name of the connection.

    • Description (string) –

      The description of the connection.

    • ConnectionType (string) – [REQUIRED]

      The type of the connection. Currently, these types are supported:

      • JDBC - Designates a connection to a database through Java Database Connectivity (JDBC). JDBC Connections use the following ConnectionParameters.

        • Required: All of ( HOST, PORT, JDBC_ENGINE) or JDBC_CONNECTION_URL.

        • Required: All of ( USERNAME, PASSWORD) or SECRET_ID.

        • Optional: JDBC_ENFORCE_SSL, CUSTOM_JDBC_CERT, CUSTOM_JDBC_CERT_STRING, SKIP_CUSTOM_JDBC_CERT_VALIDATION. These parameters are used to configure SSL with JDBC.

      • KAFKA - Designates a connection to an Apache Kafka streaming platform. KAFKA Connections use the following ConnectionParameters.

        • Required: KAFKA_BOOTSTRAP_SERVERS.

        • Optional: KAFKA_SSL_ENABLED, KAFKA_CUSTOM_CERT, KAFKA_SKIP_CUSTOM_CERT_VALIDATION. These parameters are used to configure SSL with KAFKA.

        • Optional: KAFKA_CLIENT_KEYSTORE, KAFKA_CLIENT_KEYSTORE_PASSWORD, KAFKA_CLIENT_KEY_PASSWORD, ENCRYPTED_KAFKA_CLIENT_KEYSTORE_PASSWORD, ENCRYPTED_KAFKA_CLIENT_KEY_PASSWORD. These parameters are used to configure TLS client configuration with SSL in KAFKA.

        • Optional: KAFKA_SASL_MECHANISM. Can be specified as SCRAM-SHA-512, GSSAPI, or AWS_MSK_IAM.

        • Optional: KAFKA_SASL_SCRAM_USERNAME, KAFKA_SASL_SCRAM_PASSWORD, ENCRYPTED_KAFKA_SASL_SCRAM_PASSWORD. These parameters are used to configure SASL/SCRAM-SHA-512 authentication with KAFKA.

        • Optional: KAFKA_SASL_GSSAPI_KEYTAB, KAFKA_SASL_GSSAPI_KRB5_CONF, KAFKA_SASL_GSSAPI_SERVICE, KAFKA_SASL_GSSAPI_PRINCIPAL. These parameters are used to configure SASL/GSSAPI authentication with KAFKA.

      • MONGODB - Designates a connection to a MongoDB document database. MONGODB Connections use the following ConnectionParameters.

        • Required: CONNECTION_URL.

        • Required: All of ( USERNAME, PASSWORD) or SECRET_ID.

      • SALESFORCE - Designates a connection to Salesforce using OAuth authencation.

        • Requires the AuthenticationConfiguration member to be configured.

      • VIEW_VALIDATION_REDSHIFT - Designates a connection used for view validation by Amazon Redshift.

      • VIEW_VALIDATION_ATHENA - Designates a connection used for view validation by Amazon Athena.

      • NETWORK - Designates a network connection to a data source within an Amazon Virtual Private Cloud environment (Amazon VPC). NETWORK Connections do not require ConnectionParameters. Instead, provide a PhysicalConnectionRequirements.

      • MARKETPLACE - Uses configuration settings contained in a connector purchased from Amazon Web Services Marketplace to read from and write to data stores that are not natively supported by Glue. MARKETPLACE Connections use the following ConnectionParameters.

        • Required: CONNECTOR_TYPE, CONNECTOR_URL, CONNECTOR_CLASS_NAME, CONNECTION_URL.

        • Required for JDBC CONNECTOR_TYPE connections: All of ( USERNAME, PASSWORD) or SECRET_ID.

      • CUSTOM - Uses configuration settings contained in a custom connector to read from and write to data stores that are not natively supported by Glue.

      SFTP is not supported.

      For more information about how optional ConnectionProperties are used to configure features in Glue, consult Glue connection properties.

      For more information about how optional ConnectionProperties are used to configure features in Glue Studio, consult Using connectors and connections.

    • MatchCriteria (list) –

      A list of criteria that can be used in selecting this connection.

      • (string) –

    • ConnectionProperties (dict) – [REQUIRED]

      These key-value pairs define parameters for the connection.

      • (string) –

        • (string) –

    • PhysicalConnectionRequirements (dict) –

      The physical connection requirements, such as virtual private cloud (VPC) and SecurityGroup, that are needed to successfully make this connection.

      • SubnetId (string) –

        The subnet ID used by the connection.

      • SecurityGroupIdList (list) –

        The security group ID list used by the connection.

        • (string) –

      • AvailabilityZone (string) –

        The connection’s Availability Zone.

    • AuthenticationConfiguration (dict) –

      The authentication properties of the connection. Used for a Salesforce connection.

      • AuthenticationType (string) –

        A structure containing the authentication configuration in the CreateConnection request.

      • SecretArn (string) –

        The secret manager ARN to store credentials in the CreateConnection request.

      • OAuth2Properties (dict) –

        The properties for OAuth2 authentication in the CreateConnection request.

        • OAuth2GrantType (string) –

          The OAuth2 grant type in the CreateConnection request. For example, AUTHORIZATION_CODE, JWT_BEARER, or CLIENT_CREDENTIALS.

        • OAuth2ClientApplication (dict) –

          The client application type in the CreateConnection request. For example, AWS_MANAGED or USER_MANAGED.

          • UserManagedClientApplicationClientId (string) –

            The client application clientID if the ClientAppType is USER_MANAGED.

          • AWSManagedClientApplicationReference (string) –

            The reference to the SaaS-side client app that is Amazon Web Services managed.

        • TokenUrl (string) –

          The URL of the provider’s authentication server, to exchange an authorization code for an access token.

        • TokenUrlParametersMap (dict) –

          A map of parameters that are added to the token GET request.

          • (string) –

            • (string) –

        • AuthorizationCodeProperties (dict) –

          The set of properties required for the the OAuth2 AUTHORIZATION_CODE grant type.

          • AuthorizationCode (string) –

            An authorization code to be used in the third leg of the AUTHORIZATION_CODE grant workflow. This is a single-use code which becomes invalid once exchanged for an access token, thus it is acceptable to have this value as a request parameter.

          • RedirectUri (string) –

            The redirect URI where the user gets redirected to by authorization server when issuing an authorization code. The URI is subsequently used when the authorization code is exchanged for an access token.

    • ValidateCredentials (boolean) –

      A flag to validate the credentials during create connection. Used for a Salesforce connection. Default is true.

  • Tags (dict) –

    The tags you assign to the connection.

    • (string) –

      • (string) –

Return type:

dict

Returns:

Response Syntax

{
    'CreateConnectionStatus': 'READY'|'IN_PROGRESS'|'FAILED'
}

Response Structure

  • (dict) –

    • CreateConnectionStatus (string) –

      The status of the connection creation request. The request can take some time for certain authentication types, for example when creating an OAuth connection with token exchange over VPC.

Exceptions

  • Glue.Client.exceptions.AlreadyExistsException

  • Glue.Client.exceptions.InvalidInputException

  • Glue.Client.exceptions.OperationTimeoutException

  • Glue.Client.exceptions.ResourceNumberLimitExceededException

  • Glue.Client.exceptions.GlueEncryptionException