OracleSource Class
A copy activity Oracle source.
All required parameters must be populated in order to send to server.
Constructor
OracleSource(*, additional_properties: dict[str, collections.abc.MutableMapping[str, Any]] | None = None, source_retry_count: MutableMapping[str, Any] | None = None, source_retry_wait: MutableMapping[str, Any] | None = None, max_concurrent_connections: MutableMapping[str, Any] | None = None, disable_metrics_collection: MutableMapping[str, Any] | None = None, oracle_reader_query: MutableMapping[str, Any] | None = None, query_timeout: MutableMapping[str, Any] | None = None, partition_option: MutableMapping[str, Any] | None = None, partition_settings: _models.OraclePartitionSettings | None = None, additional_columns: MutableMapping[str, Any] | None = None, number_precision: MutableMapping[str, Any] | None = None, number_scale: MutableMapping[str, Any] | None = None, **kwargs: Any)Keyword-Only Parameters
| Name | Description |
|---|---|
|
additional_properties
|
Unmatched properties from the message are deserialized to this collection. Default value: None
|
|
source_retry_count
|
<xref:JSON>
Source retry count. Type: integer (or Expression with resultType integer). Default value: None
|
|
source_retry_wait
|
<xref:JSON>
Source retry wait. Type: string (or Expression with resultType string), pattern: ((d+).)?(dd):(60|([0-5][0-9])):(60|([0-5][0-9])). Default value: None
|
|
max_concurrent_connections
|
<xref:JSON>
The maximum concurrent connection count for the source data store. Type: integer (or Expression with resultType integer). Default value: None
|
|
disable_metrics_collection
|
<xref:JSON>
If true, disable data store metrics collection. Default is false. Type: boolean (or Expression with resultType boolean). Default value: None
|
|
oracle_reader_query
|
<xref:JSON>
Oracle reader query. Type: string (or Expression with resultType string). Default value: None
|
|
query_timeout
|
<xref:JSON>
Query timeout. Type: string (or Expression with resultType string), pattern: ((d+).)?(dd):(60|([0-5][0-9])):(60|([0-5][0-9])). Default value: None
|
|
partition_option
|
<xref:JSON>
The partition mechanism that will be used for Oracle read in parallel. Possible values include: "None", "PhysicalPartitionsOfTable", "DynamicRange". Default value: None
|
|
partition_settings
|
The settings that will be leveraged for Oracle source partitioning. Default value: None
|
|
additional_columns
|
<xref:JSON>
Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects). Default value: None
|
|
number_precision
|
<xref:JSON>
The decimal precision used to represent Oracle NUMBER type without precision and scale. The range is 1 to 256 and default value is 256 if not specified. Type: integer (or Expression with resultType integer). Only used for Version 2.0. Default value: None
|
|
number_scale
|
<xref:JSON>
The decimal scale used to represent Oracle NUMBER type without precision and scale. The range is 0 to 130 and default value is 130 if not specified. Type: integer (or Expression with resultType integer). Only used for Version 2.0. Default value: None
|
Variables
| Name | Description |
|---|---|
|
additional_properties
|
Unmatched properties from the message are deserialized to this collection. |
|
type
|
Copy source type. Required. |
|
source_retry_count
|
<xref:JSON>
Source retry count. Type: integer (or Expression with resultType integer). |
|
source_retry_wait
|
<xref:JSON>
Source retry wait. Type: string (or Expression with resultType string), pattern: ((d+).)?(dd):(60|([0-5][0-9])):(60|([0-5][0-9])). |
|
max_concurrent_connections
|
<xref:JSON>
The maximum concurrent connection count for the source data store. Type: integer (or Expression with resultType integer). |
|
disable_metrics_collection
|
<xref:JSON>
If true, disable data store metrics collection. Default is false. Type: boolean (or Expression with resultType boolean). |
|
oracle_reader_query
|
<xref:JSON>
Oracle reader query. Type: string (or Expression with resultType string). |
|
query_timeout
|
<xref:JSON>
Query timeout. Type: string (or Expression with resultType string), pattern: ((d+).)?(dd):(60|([0-5][0-9])):(60|([0-5][0-9])). |
|
partition_option
|
<xref:JSON>
The partition mechanism that will be used for Oracle read in parallel. Possible values include: "None", "PhysicalPartitionsOfTable", "DynamicRange". |
|
partition_settings
|
The settings that will be leveraged for Oracle source partitioning. |
|
additional_columns
|
<xref:JSON>
Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects). |
|
number_precision
|
<xref:JSON>
The decimal precision used to represent Oracle NUMBER type without precision and scale. The range is 1 to 256 and default value is 256 if not specified. Type: integer (or Expression with resultType integer). Only used for Version 2.0. |
|
number_scale
|
<xref:JSON>
The decimal scale used to represent Oracle NUMBER type without precision and scale. The range is 0 to 130 and default value is 130 if not specified. Type: integer (or Expression with resultType integer). Only used for Version 2.0. |
