public final class SqlSource extends TabularSource
A copy activity SQL source.
  • Constructor Details

    • SqlSource

      public SqlSource()
  • Method Details

    • sqlReaderQuery

      public Object sqlReaderQuery()
      Get the sqlReaderQuery property: SQL reader query. Type: string (or Expression with resultType string).
      Returns:
      the sqlReaderQuery value.
    • withSqlReaderQuery

      public SqlSource withSqlReaderQuery(Object sqlReaderQuery)
      Set the sqlReaderQuery property: SQL reader query. Type: string (or Expression with resultType string).
      Parameters:
      sqlReaderQuery - the sqlReaderQuery value to set.
      Returns:
      the SqlSource object itself.
    • sqlReaderStoredProcedureName

      public Object sqlReaderStoredProcedureName()
      Get the sqlReaderStoredProcedureName property: 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).
      Returns:
      the sqlReaderStoredProcedureName value.
    • withSqlReaderStoredProcedureName

      public SqlSource withSqlReaderStoredProcedureName(Object sqlReaderStoredProcedureName)
      Set the sqlReaderStoredProcedureName property: 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).
      Parameters:
      sqlReaderStoredProcedureName - the sqlReaderStoredProcedureName value to set.
      Returns:
      the SqlSource object itself.
    • storedProcedureParameters

      public Map<String,StoredProcedureParameter> storedProcedureParameters()
      Get the storedProcedureParameters property: Value and type setting for stored procedure parameters. Example: "{Parameter1: {value: "1", type: "int"}}".
      Returns:
      the storedProcedureParameters value.
    • withStoredProcedureParameters

      public SqlSource withStoredProcedureParameters(Map<String,StoredProcedureParameter> storedProcedureParameters)
      Set the storedProcedureParameters property: Value and type setting for stored procedure parameters. Example: "{Parameter1: {value: "1", type: "int"}}".
      Parameters:
      storedProcedureParameters - the storedProcedureParameters value to set.
      Returns:
      the SqlSource object itself.
    • isolationLevel

      public Object isolationLevel()
      Get the isolationLevel property: 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).
      Returns:
      the isolationLevel value.
    • withIsolationLevel

      public SqlSource withIsolationLevel(Object isolationLevel)
      Set the isolationLevel property: 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).
      Parameters:
      isolationLevel - the isolationLevel value to set.
      Returns:
      the SqlSource object itself.
    • partitionOption

      public Object partitionOption()
      Get the partitionOption property: The partition mechanism that will be used for Sql read in parallel. Possible values include: "None", "PhysicalPartitionsOfTable", "DynamicRange".
      Returns:
      the partitionOption value.
    • withPartitionOption

      public SqlSource withPartitionOption(Object partitionOption)
      Set the partitionOption property: The partition mechanism that will be used for Sql read in parallel. Possible values include: "None", "PhysicalPartitionsOfTable", "DynamicRange".
      Parameters:
      partitionOption - the partitionOption value to set.
      Returns:
      the SqlSource object itself.
    • partitionSettings

      public SqlPartitionSettings partitionSettings()
      Get the partitionSettings property: The settings that will be leveraged for Sql source partitioning.
      Returns:
      the partitionSettings value.
    • withPartitionSettings

      public SqlSource withPartitionSettings(SqlPartitionSettings partitionSettings)
      Set the partitionSettings property: The settings that will be leveraged for Sql source partitioning.
      Parameters:
      partitionSettings - the partitionSettings value to set.
      Returns:
      the SqlSource object itself.
    • withQueryTimeout

      public SqlSource withQueryTimeout(Object queryTimeout)
      Set the queryTimeout property: Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+)\.)?(\d\d):(60|([0-5][0-9])):(60|([0-5][0-9])).
      Overrides:
      withQueryTimeout in class TabularSource
      Parameters:
      queryTimeout - the queryTimeout value to set.
      Returns:
      the TabularSource object itself.
    • withAdditionalColumns

      public SqlSource withAdditionalColumns(Object additionalColumns)
      Set the additionalColumns property: Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).
      Overrides:
      withAdditionalColumns in class TabularSource
      Parameters:
      additionalColumns - the additionalColumns value to set.
      Returns:
      the TabularSource object itself.
    • withSourceRetryCount

      public SqlSource withSourceRetryCount(Object sourceRetryCount)
      Set the sourceRetryCount property: Source retry count. Type: integer (or Expression with resultType integer).
      Overrides:
      withSourceRetryCount in class TabularSource
      Parameters:
      sourceRetryCount - the sourceRetryCount value to set.
      Returns:
      the CopySource object itself.
    • withSourceRetryWait

      public SqlSource withSourceRetryWait(Object sourceRetryWait)
      Set the sourceRetryWait property: Source retry wait. Type: string (or Expression with resultType string), pattern: ((\d+)\.)?(\d\d):(60|([0-5][0-9])):(60|([0-5][0-9])).
      Overrides:
      withSourceRetryWait in class TabularSource
      Parameters:
      sourceRetryWait - the sourceRetryWait value to set.
      Returns:
      the CopySource object itself.
    • withMaxConcurrentConnections

      public SqlSource withMaxConcurrentConnections(Object maxConcurrentConnections)
      Set the maxConcurrentConnections property: The maximum concurrent connection count for the source data store. Type: integer (or Expression with resultType integer).
      Overrides:
      withMaxConcurrentConnections in class TabularSource
      Parameters:
      maxConcurrentConnections - the maxConcurrentConnections value to set.
      Returns:
      the CopySource object itself.
    • withDisableMetricsCollection

      public SqlSource withDisableMetricsCollection(Object disableMetricsCollection)
      Set the disableMetricsCollection property: If true, disable data store metrics collection. Default is false. Type: boolean (or Expression with resultType boolean).
      Overrides:
      withDisableMetricsCollection in class TabularSource
      Parameters:
      disableMetricsCollection - the disableMetricsCollection value to set.
      Returns:
      the CopySource object itself.
    • validate

      public void validate()
      Validates the instance.
      Overrides:
      validate in class TabularSource
      Throws:
      IllegalArgumentException - thrown if the instance is not valid.