public final class SqlMISource extends TabularSource
A copy activity Azure SQL Managed Instance source.
  • Constructor Details

    • SqlMISource

      public SqlMISource()
  • 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 SqlMISource 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 SqlMISource object itself.
    • sqlReaderStoredProcedureName

      public Object sqlReaderStoredProcedureName()
      Get the sqlReaderStoredProcedureName property: Name of the stored procedure for a Azure SQL Managed Instance source. This cannot be used at the same time as SqlReaderQuery. Type: string (or Expression with resultType string).
      Returns:
      the sqlReaderStoredProcedureName value.
    • withSqlReaderStoredProcedureName

      public SqlMISource withSqlReaderStoredProcedureName(Object sqlReaderStoredProcedureName)
      Set the sqlReaderStoredProcedureName property: Name of the stored procedure for a Azure SQL Managed Instance 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 SqlMISource 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 SqlMISource 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 SqlMISource object itself.
    • produceAdditionalTypes

      public Object produceAdditionalTypes()
      Get the produceAdditionalTypes property: Which additional types to produce.
      Returns:
      the produceAdditionalTypes value.
    • withProduceAdditionalTypes

      public SqlMISource withProduceAdditionalTypes(Object produceAdditionalTypes)
      Set the produceAdditionalTypes property: Which additional types to produce.
      Parameters:
      produceAdditionalTypes - the produceAdditionalTypes value to set.
      Returns:
      the SqlMISource 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 SqlMISource 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 SqlMISource 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 SqlMISource 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 SqlMISource object itself.
    • withQueryTimeout

      public SqlMISource 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 SqlMISource 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 SqlMISource 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 SqlMISource 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 SqlMISource 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 SqlMISource 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.