Mysql connector what is it

Privacy policy. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Operation ID: DeleteItem. This operation deletes a row from a table. Operation ID: GetItem. This operation gets a row from a table. Operation ID: GetItems. This operation gets rows from a table. Operation ID: GetTables. This operation gets tables from a database. Returns Represents a list of tables. Body TablesList.

Operation ID: PostItem. This operation inserts a new row into a table. Operation ID: PatchItem. This operation updates an existing row in a table. To enable IAM authentication, add the following configuration properties to the catalog configuration file:. You can also configure the connector to assume a specific IAM role for authentication before creating the access token, in order to apply policies specific to SEP.

Alongside this role, you must include an informal external identifier of a user to assume this role. Optional Set an IAM role to assume for authentication before creating the access token.

If set, aws. Optional The informal identifier of the user who assumes the IAM role set in aws. The amount of time to keep the generated RDS access tokens for each user before they are regenerated. The maximum value is 15 minutes. Defaults to 10m. The access key of the principal to authenticate with for the token generator service. Used for fixed authentication, setting this property disables automatic authentication.

The secret key of the principal to authenticate with for the token generator service. Optional A session token for temporary credentials, such as credentials obtained from SSO. By default the connector attempts to automatically obtain its authentication credentials from the environment. The default credential provider chain attempts to obtain credentials from the following sources, in order:.

Java system properties : aws. Instance profile credentials : credentials delievered through the Amazon EC2 metadata service. If the SEP cluster is running on an EC2 instance, these credentials most likely come from the metadata service.

Alternatively, you can set fixed credentials for authentication. To use fixed credentials for authentication, set the following configuration properties:.

Reference documentation User guides Connectors.