Class SqlMISource


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

      • SqlMISource

        public SqlMISource()
    • Method Detail

      • 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.