pub struct SqlSource {
pub tabular_source: TabularSource,
pub sql_reader_query: Option<Value>,
pub sql_reader_stored_procedure_name: Option<Value>,
pub stored_procedure_parameters: Option<Value>,
pub isolation_level: Option<Value>,
pub partition_option: Option<Value>,
pub partition_settings: Option<SqlPartitionSettings>,
}Expand description
A copy activity SQL source.
Fields§
§tabular_source: TabularSource§sql_reader_query: Option<Value>SQL reader query. Type: string (or Expression with resultType string).
sql_reader_stored_procedure_name: Option<Value>Name of the stored procedure for a SQL Database source. This cannot be used at the same time as SqlReaderQuery. Type: string (or Expression with resultType string).
stored_procedure_parameters: Option<Value>Value and type setting for stored procedure parameters. Example: “{Parameter1: {value: “1”, type: “int”}}“.
isolation_level: Option<Value>Specifies the transaction locking behavior for the SQL source. Allowed values: ReadCommitted/ReadUncommitted/RepeatableRead/Serializable/Snapshot. The default value is ReadCommitted. Type: string (or Expression with resultType string).
partition_option: Option<Value>The partition mechanism that will be used for Sql read in parallel. Possible values include: “None”, “PhysicalPartitionsOfTable”, “DynamicRange”. Type: string (or Expression with resultType string).
partition_settings: Option<SqlPartitionSettings>The settings that will be leveraged for Sql source partitioning.