Class: Aws::Glue::Types::JDBCConnectorOptions

Inherits:
Struct
  • Object
show all
Defined in:
gems/aws-sdk-glue/lib/aws-sdk-glue/types.rb

Overview

Additional connection options for the connector.

Constant Summary collapse

SENSITIVE =
[]

Instance Attribute Summary collapse

Instance Attribute Details

#data_type_mappingHash<String,String>

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.

Returns:

  • (Hash<String,String>)


12966
12967
12968
12969
12970
12971
12972
12973
12974
12975
12976
12977
# File 'gems/aws-sdk-glue/lib/aws-sdk-glue/types.rb', line 12966

class JDBCConnectorOptions < Struct.new(
  :filter_predicate,
  :partition_column,
  :lower_bound,
  :upper_bound,
  :num_partitions,
  :job_bookmark_keys,
  :job_bookmark_keys_sort_order,
  :data_type_mapping)
  SENSITIVE = []
  include Aws::Structure
end

#filter_predicateString

Extra condition clause to filter data from source. For example:

BillingCity='Mountain View'

When using a query instead of a table name, you should validate that the query works with the specified filterPredicate.

Returns:

  • (String)


12966
12967
12968
12969
12970
12971
12972
12973
12974
12975
12976
12977
# File 'gems/aws-sdk-glue/lib/aws-sdk-glue/types.rb', line 12966

class JDBCConnectorOptions < Struct.new(
  :filter_predicate,
  :partition_column,
  :lower_bound,
  :upper_bound,
  :num_partitions,
  :job_bookmark_keys,
  :job_bookmark_keys_sort_order,
  :data_type_mapping)
  SENSITIVE = []
  include Aws::Structure
end

#job_bookmark_keysArray<String>

The name of the job bookmark keys on which to sort.

Returns:

  • (Array<String>)


12966
12967
12968
12969
12970
12971
12972
12973
12974
12975
12976
12977
# File 'gems/aws-sdk-glue/lib/aws-sdk-glue/types.rb', line 12966

class JDBCConnectorOptions < Struct.new(
  :filter_predicate,
  :partition_column,
  :lower_bound,
  :upper_bound,
  :num_partitions,
  :job_bookmark_keys,
  :job_bookmark_keys_sort_order,
  :data_type_mapping)
  SENSITIVE = []
  include Aws::Structure
end

#job_bookmark_keys_sort_orderString

Specifies an ascending or descending sort order.

Returns:

  • (String)


12966
12967
12968
12969
12970
12971
12972
12973
12974
12975
12976
12977
# File 'gems/aws-sdk-glue/lib/aws-sdk-glue/types.rb', line 12966

class JDBCConnectorOptions < Struct.new(
  :filter_predicate,
  :partition_column,
  :lower_bound,
  :upper_bound,
  :num_partitions,
  :job_bookmark_keys,
  :job_bookmark_keys_sort_order,
  :data_type_mapping)
  SENSITIVE = []
  include Aws::Structure
end

#lower_boundInteger

The minimum value of partitionColumn that is used to decide partition stride.

Returns:

  • (Integer)


12966
12967
12968
12969
12970
12971
12972
12973
12974
12975
12976
12977
# File 'gems/aws-sdk-glue/lib/aws-sdk-glue/types.rb', line 12966

class JDBCConnectorOptions < Struct.new(
  :filter_predicate,
  :partition_column,
  :lower_bound,
  :upper_bound,
  :num_partitions,
  :job_bookmark_keys,
  :job_bookmark_keys_sort_order,
  :data_type_mapping)
  SENSITIVE = []
  include Aws::Structure
end

#num_partitionsInteger

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.

Returns:

  • (Integer)


12966
12967
12968
12969
12970
12971
12972
12973
12974
12975
12976
12977
# File 'gems/aws-sdk-glue/lib/aws-sdk-glue/types.rb', line 12966

class JDBCConnectorOptions < Struct.new(
  :filter_predicate,
  :partition_column,
  :lower_bound,
  :upper_bound,
  :num_partitions,
  :job_bookmark_keys,
  :job_bookmark_keys_sort_order,
  :data_type_mapping)
  SENSITIVE = []
  include Aws::Structure
end

#partition_columnString

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.

Returns:

  • (String)


12966
12967
12968
12969
12970
12971
12972
12973
12974
12975
12976
12977
# File 'gems/aws-sdk-glue/lib/aws-sdk-glue/types.rb', line 12966

class JDBCConnectorOptions < Struct.new(
  :filter_predicate,
  :partition_column,
  :lower_bound,
  :upper_bound,
  :num_partitions,
  :job_bookmark_keys,
  :job_bookmark_keys_sort_order,
  :data_type_mapping)
  SENSITIVE = []
  include Aws::Structure
end

#upper_boundInteger

The maximum value of partitionColumn that is used to decide partition stride.

Returns:

  • (Integer)


12966
12967
12968
12969
12970
12971
12972
12973
12974
12975
12976
12977
# File 'gems/aws-sdk-glue/lib/aws-sdk-glue/types.rb', line 12966

class JDBCConnectorOptions < Struct.new(
  :filter_predicate,
  :partition_column,
  :lower_bound,
  :upper_bound,
  :num_partitions,
  :job_bookmark_keys,
  :job_bookmark_keys_sort_order,
  :data_type_mapping)
  SENSITIVE = []
  include Aws::Structure
end