Adf Azure Sql Database Source Element
X-Ref:
- Ast Adf Azure Sql Database Source Node
- Ast Adf Sql Server Source Base Node
- Ast Adf Tabular Source Base Node
- Ast Adf Additional Columns Source Base Node
- Ast Adf Queryable Source Base Node
- Ast Adf Dataset Source Base Node
Attributes
| Attribute | API Type | Default | Description |
|---|---|---|---|
| DatasetName | AstAdfAzureSqlDatabaseDatasetNode | Specifies a reference to the AzureSqlDatabase dataset that will supply the data. This is a required reference to an existing definiton. | |
| IsolationLevel | AdfAzureSqlIsolationLevel | None | Specifies if truncation is applied to results that go over a specific row-count limit. |
| MaxConcurrentConnections | Int32 | 0 | Max number of simultaneous connections to the source. |
| PartitionOption | AdfSqlPartitionOption | None | Specifies the partition mechanism for reading from Teradata database in parallel. |
| ProduceAdditionalTypes | String | Specifies the additional types to produce. | |
| QueryTimeout | String | "00:10:00" | How long to wait before timing out. |
| RetryCount | Int32 | 0 | Number of retries. |
| RetryWait | String | String representing the retry wait. Pattern: ((\\d+)\\.)?(\\d\\d):(60|([0-5][0-9])):(60|([0-5][0-9])) | |
| StoredProcedure | String | Specifies the name of the stored procedure to execute. |
Singleton Children
| Child | API Type | Description |
|---|---|---|
| <PartitionSettings /> | AstAdfSqlPartitionSettingsNode | AstAdfSqlPartitionSettingsNode objects correspond directly to partition settings for SQL sources in Azure Data Factory. |
| <Query /> | String | String is the .NET Framework String class. More information can be found at http://msdn.microsoft.com/en-us/library/system.string.aspx. |
Collection Children
| Child | API Type | Description |
|---|---|---|
| <AdditionalColumns> <AdditionalColumn /> </AdditionalColumns> | AstAdfCopySourceAdditionalColumnNode | Specifies a list of additional columns to be used in the copy activity. |
| <Annotations> <Annotation /> </Annotations> | AstAnnotationNode | This is a collection of annotation items that can be used to specify documentation, tags, or other information. Annotations are particularly useful for storing information about nodes that can be used by BimlScript code. |
| <Parameters> <Parameter /> </Parameters> | AstAdfCopyActivityParameterNode | Specifies the Dataset parameters to be used. |
| <StoredProcedureParameters> <Parameter /> </StoredProcedureParameters> | AstAdfStoredProcedureParameterNode | This collection contains the parameters that will be passed to the stored produre for execution. |