JdbcConnectorOptions
Additional connection options for the connector.
Types
Properties
Custom data type mapping that builds a mapping from a JDBC data type to an Glue data type. For example, the option "dataTypeMapping":{"FLOAT":"STRING"}
maps data fields of JDBC type FLOAT
into the Java String
type by calling the ResultSet.getString()
method of the driver, and uses it to build the Glue record. The ResultSet
object is implemented by each driver, so the behavior is specific to the driver you use. Refer to the documentation for your JDBC driver to understand how the driver performs the conversions.
Extra condition clause to filter data from source. For example:
The name of the job bookmark keys on which to sort.
Specifies an ascending or descending sort order.
The minimum value of partitionColumn
that is used to decide partition stride.
The number of partitions. This value, along with lowerBound
(inclusive) and upperBound
(exclusive), form partition strides for generated WHERE
clause expressions that are used to split the partitionColumn
.
The name of an integer column that is used for partitioning. This option works only when it's included with lowerBound
, upperBound
, and numPartitions
. This option works the same way as in the Spark SQL JDBC reader.
The maximum value of partitionColumn
that is used to decide partition stride.