Фабрики и конвейеры Microsoft.DataFactory

Статья
03/10/2023

Определение ресурса Bicep

Тип ресурса фабрик и конвейеров можно развернуть в следующих объектах:

Группы ресурсов — см. команды развертывания групп ресурсов.

Список измененных свойств в каждой версии API см. в журнале изменений.

Формат ресурсов

Чтобы создать ресурс Microsoft.DataFactory/factories/pipelines, добавьте следующий Bicep в шаблон.

resource symbolicname 'Microsoft.DataFactory/factories/pipelines@2018-06-01' = {
  name: 'string'
  parent: resourceSymbolicName
  properties: {
    activities: [
      {
        dependsOn: [
          {
            activity: 'string'
            dependencyConditions: [
              'string'
            ]
          }
        ]
        description: 'string'
        name: 'string'
        userProperties: [
          {
            name: 'string'
            value: any()
          }
        ]
        type: 'string'
        // For remaining properties, see Activity objects
      }
    ]
    annotations: [
      any
    ]
    concurrency: int
    description: 'string'
    folder: {
      name: 'string'
    }
    parameters: {}
    policy: {
      elapsedTimeMetric: {
        duration: any()
      }
    }
    runDimensions: {}
    variables: {}
  }
}

Объекты действий

Задайте свойство type , чтобы указать тип объекта .

Для AppendVariable используйте:

  type: 'AppendVariable'
  typeProperties: {
    value: any()
    variableName: 'string'
  }

Для AzureDataExplorerCommand используйте:

  type: 'AzureDataExplorerCommand'
  linkedServiceName: {
    parameters: {}
    referenceName: 'string'
    type: 'LinkedServiceReference'
  }
  policy: {
    retry: any()
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any()
  }
  typeProperties: {
    command: any()
    commandTimeout: any()
  }

Для AzureFunctionActivity используйте:

  type: 'AzureFunctionActivity'
  linkedServiceName: {
    parameters: {}
    referenceName: 'string'
    type: 'LinkedServiceReference'
  }
  policy: {
    retry: any()
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any()
  }
  typeProperties: {
    body: any()
    functionName: any()
    headers: any()
    method: 'string'
  }

Для AzureMLBatchExecution используйте:

  type: 'AzureMLBatchExecution'
  linkedServiceName: {
    parameters: {}
    referenceName: 'string'
    type: 'LinkedServiceReference'
  }
  policy: {
    retry: any()
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any()
  }
  typeProperties: {
    globalParameters: {}
    webServiceInputs: {}
    webServiceOutputs: {}
  }

Для AzureMLExecutePipeline используйте:

  type: 'AzureMLExecutePipeline'
  linkedServiceName: {
    parameters: {}
    referenceName: 'string'
    type: 'LinkedServiceReference'
  }
  policy: {
    retry: any()
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any()
  }
  typeProperties: {
    continueOnStepFailure: any()
    dataPathAssignments: any()
    experimentName: any()
    mlParentRunId: any()
    mlPipelineEndpointId: any()
    mlPipelineId: any()
    mlPipelineParameters: any()
    version: any()
  }

Для AzureMLUpdateResource используйте:

  type: 'AzureMLUpdateResource'
  linkedServiceName: {
    parameters: {}
    referenceName: 'string'
    type: 'LinkedServiceReference'
  }
  policy: {
    retry: any()
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any()
  }
  typeProperties: {
    trainedModelFilePath: any()
    trainedModelLinkedServiceName: {
      parameters: {}
      referenceName: 'string'
      type: 'LinkedServiceReference'
    }
    trainedModelName: any()
  }

Для копирования используйте:

  type: 'Copy'
  inputs: [
    {
      parameters: {}
      referenceName: 'string'
      type: 'DatasetReference'
    }
  ]
  linkedServiceName: {
    parameters: {}
    referenceName: 'string'
    type: 'LinkedServiceReference'
  }
  outputs: [
    {
      parameters: {}
      referenceName: 'string'
      type: 'DatasetReference'
    }
  ]
  policy: {
    retry: any()
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any()
  }
  typeProperties: {
    dataIntegrationUnits: any()
    enableSkipIncompatibleRow: any()
    enableStaging: any()
    logSettings: {
      copyActivityLogSettings: {
        enableReliableLogging: any()
        logLevel: any()
      }
      enableCopyActivityLog: any()
      logLocationSettings: {
        linkedServiceName: {
          parameters: {}
          referenceName: 'string'
          type: 'LinkedServiceReference'
        }
        path: any()
      }
    }
    logStorageSettings: {
      enableReliableLogging: any()
      linkedServiceName: {
        parameters: {}
        referenceName: 'string'
        type: 'LinkedServiceReference'
      }
      logLevel: any()
      path: any()
    }
    parallelCopies: any()
    preserve: [
      any
    ]
    preserveRules: [
      any
    ]
    redirectIncompatibleRowSettings: {
      linkedServiceName: any()
      path: any()
    }
    sink: {
      disableMetricsCollection: any()
      maxConcurrentConnections: any()
      sinkRetryCount: any()
      sinkRetryWait: any()
      writeBatchSize: any()
      writeBatchTimeout: any()
      type: 'string'
      // For remaining properties, see CopySink objects
    }
    skipErrorFile: {
      dataInconsistency: any()
      fileMissing: any()
    }
    source: {
      disableMetricsCollection: any()
      maxConcurrentConnections: any()
      sourceRetryCount: any()
      sourceRetryWait: any()
      type: 'string'
      // For remaining properties, see CopySource objects
    }
    stagingSettings: {
      enableCompression: any()
      linkedServiceName: {
        parameters: {}
        referenceName: 'string'
        type: 'LinkedServiceReference'
      }
      path: any()
    }
    translator: any()
    validateDataConsistency: any()
  }

Для настраиваемого используйте:

  type: 'Custom'
  linkedServiceName: {
    parameters: {}
    referenceName: 'string'
    type: 'LinkedServiceReference'
  }
  policy: {
    retry: any()
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any()
  }
  typeProperties: {
    autoUserSpecification: any()
    command: any()
    extendedProperties: {}
    folderPath: any()
    referenceObjects: {
      datasets: [
        {
          parameters: {}
          referenceName: 'string'
          type: 'DatasetReference'
        }
      ]
      linkedServices: [
        {
          parameters: {}
          referenceName: 'string'
          type: 'LinkedServiceReference'
        }
      ]
    }
    resourceLinkedService: {
      parameters: {}
      referenceName: 'string'
      type: 'LinkedServiceReference'
    }
    retentionTimeInDays: any()
  }

Для DatabricksNotebook используйте:

  type: 'DatabricksNotebook'
  linkedServiceName: {
    parameters: {}
    referenceName: 'string'
    type: 'LinkedServiceReference'
  }
  policy: {
    retry: any()
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any()
  }
  typeProperties: {
    baseParameters: {}
    libraries: [
      {
      }
    ]
    notebookPath: any()
  }

Для DatabricksSparkJar используйте:

  type: 'DatabricksSparkJar'
  linkedServiceName: {
    parameters: {}
    referenceName: 'string'
    type: 'LinkedServiceReference'
  }
  policy: {
    retry: any()
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any()
  }
  typeProperties: {
    libraries: [
      {
      }
    ]
    mainClassName: any()
    parameters: [
      any
    ]
  }

Для DatabricksSparkPython используйте:

  type: 'DatabricksSparkPython'
  linkedServiceName: {
    parameters: {}
    referenceName: 'string'
    type: 'LinkedServiceReference'
  }
  policy: {
    retry: any()
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any()
  }
  typeProperties: {
    libraries: [
      {
      }
    ]
    parameters: [
      any
    ]
    pythonFile: any()
  }

Для DataLakeAnalyticsU-SQL используйте:

  type: 'DataLakeAnalyticsU-SQL'
  linkedServiceName: {
    parameters: {}
    referenceName: 'string'
    type: 'LinkedServiceReference'
  }
  policy: {
    retry: any()
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any()
  }
  typeProperties: {
    compilationMode: any()
    degreeOfParallelism: any()
    parameters: {}
    priority: any()
    runtimeVersion: any()
    scriptLinkedService: {
      parameters: {}
      referenceName: 'string'
      type: 'LinkedServiceReference'
    }
    scriptPath: any()
  }

Для удаления используйте:

  type: 'Delete'
  linkedServiceName: {
    parameters: {}
    referenceName: 'string'
    type: 'LinkedServiceReference'
  }
  policy: {
    retry: any()
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any()
  }
  typeProperties: {
    dataset: {
      parameters: {}
      referenceName: 'string'
      type: 'DatasetReference'
    }
    enableLogging: any()
    logStorageSettings: {
      enableReliableLogging: any()
      linkedServiceName: {
        parameters: {}
        referenceName: 'string'
        type: 'LinkedServiceReference'
      }
      logLevel: any()
      path: any()
    }
    maxConcurrentConnections: int
    recursive: any()
    storeSettings: {
      disableMetricsCollection: any()
      maxConcurrentConnections: any()
      type: 'string'
      // For remaining properties, see StoreReadSettings objects
    }
  }

Для ExecuteDataFlow используйте:

  type: 'ExecuteDataFlow'
  linkedServiceName: {
    parameters: {}
    referenceName: 'string'
    type: 'LinkedServiceReference'
  }
  policy: {
    retry: any()
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any()
  }
  typeProperties: {
    compute: {
      computeType: any()
      coreCount: any()
    }
    continueOnError: any()
    dataFlow: {
      datasetParameters: any()
      parameters: {}
      referenceName: 'string'
      type: 'DataFlowReference'
    }
    integrationRuntime: {
      parameters: {}
      referenceName: 'string'
      type: 'IntegrationRuntimeReference'
    }
    runConcurrently: any()
    sourceStagingConcurrency: any()
    staging: {
      folderPath: any()
      linkedService: {
        parameters: {}
        referenceName: 'string'
        type: 'LinkedServiceReference'
      }
    }
    traceLevel: any()
  }

Для ExecutePipeline используйте:

  type: 'ExecutePipeline'
  policy: {
    secureInput: bool
  }
  typeProperties: {
    parameters: {}
    pipeline: {
      name: 'string'
      referenceName: 'string'
      type: 'PipelineReference'
    }
    waitOnCompletion: bool
  }

Для ExecuteSSISPackage используйте:

  type: 'ExecuteSSISPackage'
  linkedServiceName: {
    parameters: {}
    referenceName: 'string'
    type: 'LinkedServiceReference'
  }
  policy: {
    retry: any()
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any()
  }
  typeProperties: {
    connectVia: {
      parameters: {}
      referenceName: 'string'
      type: 'IntegrationRuntimeReference'
    }
    environmentPath: any()
    executionCredential: {
      domain: any()
      password: {
        type: 'string'
        value: 'string'
      }
      userName: any()
    }
    loggingLevel: any()
    logLocation: {
      logPath: any()
      type: 'File'
      typeProperties: {
        accessCredential: {
          domain: any()
          password: {
            type: 'string'
            // For remaining properties, see SecretBase objects
          }
          userName: any()
        }
        logRefreshInterval: any()
      }
    }
    packageConnectionManagers: {}
    packageLocation: {
      packagePath: any()
      type: 'string'
      typeProperties: {
        accessCredential: {
          domain: any()
          password: {
            type: 'string'
            // For remaining properties, see SecretBase objects
          }
          userName: any()
        }
        childPackages: [
          {
            packageContent: any()
            packageLastModifiedDate: 'string'
            packageName: 'string'
            packagePath: any()
          }
        ]
        configurationAccessCredential: {
          domain: any()
          password: {
            type: 'string'
            // For remaining properties, see SecretBase objects
          }
          userName: any()
        }
        configurationPath: any()
        packageContent: any()
        packageLastModifiedDate: 'string'
        packageName: 'string'
        packagePassword: {
          type: 'string'
          // For remaining properties, see SecretBase objects
        }
      }
    }
    packageParameters: {}
    projectConnectionManagers: {}
    projectParameters: {}
    propertyOverrides: {}
    runtime: any()
  }

Для ExecuteWranglingDataflow используйте:

  type: 'ExecuteWranglingDataflow'
  policy: {
    retry: any()
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any()
  }
  typeProperties: {
    compute: {
      computeType: any()
      coreCount: any()
    }
    continueOnError: any()
    dataFlow: {
      datasetParameters: any()
      parameters: {}
      referenceName: 'string'
      type: 'DataFlowReference'
    }
    integrationRuntime: {
      parameters: {}
      referenceName: 'string'
      type: 'IntegrationRuntimeReference'
    }
    queries: [
      {
        dataflowSinks: [
          {
            dataset: {
              parameters: {}
              referenceName: 'string'
              type: 'DatasetReference'
            }
            description: 'string'
            flowlet: {
              datasetParameters: any()
              parameters: {}
              referenceName: 'string'
              type: 'DataFlowReference'
            }
            linkedService: {
              parameters: {}
              referenceName: 'string'
              type: 'LinkedServiceReference'
            }
            name: 'string'
            rejectedDataLinkedService: {
              parameters: {}
              referenceName: 'string'
              type: 'LinkedServiceReference'
            }
            schemaLinkedService: {
              parameters: {}
              referenceName: 'string'
              type: 'LinkedServiceReference'
            }
            script: 'string'
          }
        ]
        queryName: 'string'
      }
    ]
    runConcurrently: any()
    sinks: {}
    sourceStagingConcurrency: any()
    staging: {
      folderPath: any()
      linkedService: {
        parameters: {}
        referenceName: 'string'
        type: 'LinkedServiceReference'
      }
    }
    traceLevel: any()
  }

Для параметра Fail (Сбой) используйте:

  type: 'Fail'
  typeProperties: {
    errorCode: any()
    message: any()
  }

Для параметра Фильтр используйте:

  type: 'Filter'
  typeProperties: {
    condition: {
      type: 'Expression'
      value: 'string'
    }
    items: {
      type: 'Expression'
      value: 'string'
    }
  }

Для ForEach используйте:

  type: 'ForEach'
  typeProperties: {
    activities: [
      {
        dependsOn: [
          {
            activity: 'string'
            dependencyConditions: [
              'string'
            ]
          }
        ]
        description: 'string'
        name: 'string'
        userProperties: [
          {
            name: 'string'
            value: any()
          }
        ]
        type: 'string'
        // For remaining properties, see Activity objects
      }
    ]
    batchCount: int
    isSequential: bool
    items: {
      type: 'Expression'
      value: 'string'
    }
  }

Для GetMetadata используйте:

  type: 'GetMetadata'
  linkedServiceName: {
    parameters: {}
    referenceName: 'string'
    type: 'LinkedServiceReference'
  }
  policy: {
    retry: any()
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any()
  }
  typeProperties: {
    dataset: {
      parameters: {}
      referenceName: 'string'
      type: 'DatasetReference'
    }
    fieldList: [
      any
    ]
    formatSettings: {
      type: 'string'
      // For remaining properties, see FormatReadSettings objects
    }
    storeSettings: {
      disableMetricsCollection: any()
      maxConcurrentConnections: any()
      type: 'string'
      // For remaining properties, see StoreReadSettings objects
    }
  }

Для HDInsightHive используйте:

  type: 'HDInsightHive'
  linkedServiceName: {
    parameters: {}
    referenceName: 'string'
    type: 'LinkedServiceReference'
  }
  policy: {
    retry: any()
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any()
  }
  typeProperties: {
    arguments: [
      any
    ]
    defines: {}
    getDebugInfo: 'string'
    queryTimeout: int
    scriptLinkedService: {
      parameters: {}
      referenceName: 'string'
      type: 'LinkedServiceReference'
    }
    scriptPath: any()
    storageLinkedServices: [
      {
        parameters: {}
        referenceName: 'string'
        type: 'LinkedServiceReference'
      }
    ]
    variables: [
      any
    ]
  }

Для HDInsightMapReduce используйте:

  type: 'HDInsightMapReduce'
  linkedServiceName: {
    parameters: {}
    referenceName: 'string'
    type: 'LinkedServiceReference'
  }
  policy: {
    retry: any()
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any()
  }
  typeProperties: {
    arguments: [
      any
    ]
    className: any()
    defines: {}
    getDebugInfo: 'string'
    jarFilePath: any()
    jarLibs: [
      any
    ]
    jarLinkedService: {
      parameters: {}
      referenceName: 'string'
      type: 'LinkedServiceReference'
    }
    storageLinkedServices: [
      {
        parameters: {}
        referenceName: 'string'
        type: 'LinkedServiceReference'
      }
    ]
  }

Для HDInsightPig используйте:

  type: 'HDInsightPig'
  linkedServiceName: {
    parameters: {}
    referenceName: 'string'
    type: 'LinkedServiceReference'
  }
  policy: {
    retry: any()
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any()
  }
  typeProperties: {
    arguments: any()
    defines: {}
    getDebugInfo: 'string'
    scriptLinkedService: {
      parameters: {}
      referenceName: 'string'
      type: 'LinkedServiceReference'
    }
    scriptPath: any()
    storageLinkedServices: [
      {
        parameters: {}
        referenceName: 'string'
        type: 'LinkedServiceReference'
      }
    ]
  }

Для HDInsightSpark используйте:

  type: 'HDInsightSpark'
  linkedServiceName: {
    parameters: {}
    referenceName: 'string'
    type: 'LinkedServiceReference'
  }
  policy: {
    retry: any()
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any()
  }
  typeProperties: {
    arguments: [
      any
    ]
    className: 'string'
    entryFilePath: any()
    getDebugInfo: 'string'
    proxyUser: any()
    rootPath: any()
    sparkConfig: {}
    sparkJobLinkedService: {
      parameters: {}
      referenceName: 'string'
      type: 'LinkedServiceReference'
    }
  }

Для HDInsightStreaming используйте:

  type: 'HDInsightStreaming'
  linkedServiceName: {
    parameters: {}
    referenceName: 'string'
    type: 'LinkedServiceReference'
  }
  policy: {
    retry: any()
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any()
  }
  typeProperties: {
    arguments: [
      any
    ]
    combiner: any()
    commandEnvironment: [
      any
    ]
    defines: {}
    fileLinkedService: {
      parameters: {}
      referenceName: 'string'
      type: 'LinkedServiceReference'
    }
    filePaths: [
      any
    ]
    getDebugInfo: 'string'
    input: any()
    mapper: any()
    output: any()
    reducer: any()
    storageLinkedServices: [
      {
        parameters: {}
        referenceName: 'string'
        type: 'LinkedServiceReference'
      }
    ]
  }

Для параметра IfCondition используйте:

  type: 'IfCondition'
  typeProperties: {
    expression: {
      type: 'Expression'
      value: 'string'
    }
    ifFalseActivities: [
      {
        dependsOn: [
          {
            activity: 'string'
            dependencyConditions: [
              'string'
            ]
          }
        ]
        description: 'string'
        name: 'string'
        userProperties: [
          {
            name: 'string'
            value: any()
          }
        ]
        type: 'string'
        // For remaining properties, see Activity objects
      }
    ]
    ifTrueActivities: [
      {
        dependsOn: [
          {
            activity: 'string'
            dependencyConditions: [
              'string'
            ]
          }
        ]
        description: 'string'
        name: 'string'
        userProperties: [
          {
            name: 'string'
            value: any()
          }
        ]
        type: 'string'
        // For remaining properties, see Activity objects
      }
    ]
  }

Для поиска используйте:

  type: 'Lookup'
  linkedServiceName: {
    parameters: {}
    referenceName: 'string'
    type: 'LinkedServiceReference'
  }
  policy: {
    retry: any()
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any()
  }
  typeProperties: {
    dataset: {
      parameters: {}
      referenceName: 'string'
      type: 'DatasetReference'
    }
    firstRowOnly: any()
    source: {
      disableMetricsCollection: any()
      maxConcurrentConnections: any()
      sourceRetryCount: any()
      sourceRetryWait: any()
      type: 'string'
      // For remaining properties, see CopySource objects
    }
  }

Для скрипта используйте:

  type: 'Script'
  linkedServiceName: {
    parameters: {}
    referenceName: 'string'
    type: 'LinkedServiceReference'
  }
  policy: {
    retry: any()
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any()
  }
  typeProperties: {
    logSettings: {
      logDestination: 'string'
      logLocationSettings: {
        linkedServiceName: {
          parameters: {}
          referenceName: 'string'
          type: 'LinkedServiceReference'
        }
        path: any()
      }
    }
    scriptBlockExecutionTimeout: any()
    scripts: [
      {
        parameters: [
          {
            direction: 'string'
            name: any()
            size: int
            type: 'string'
            value: any()
          }
        ]
        text: any()
        type: 'string'
      }
    ]
  }

Для SetVariable используйте:

  type: 'SetVariable'
  typeProperties: {
    value: any()
    variableName: 'string'
  }

Для SparkJob используйте:

  type: 'SparkJob'
  linkedServiceName: {
    parameters: {}
    referenceName: 'string'
    type: 'LinkedServiceReference'
  }
  policy: {
    retry: any()
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any()
  }
  typeProperties: {
    args: [
      any
    ]
    className: any()
    conf: any()
    configurationType: 'string'
    driverSize: any()
    executorSize: any()
    file: any()
    files: [
      any
    ]
    filesV2: [
      any
    ]
    numExecutors: any()
    pythonCodeReference: [
      any
    ]
    scanFolder: any()
    sparkConfig: {}
    sparkJob: {
      referenceName: any()
      type: 'SparkJobDefinitionReference'
    }
    targetBigDataPool: {
      referenceName: any()
      type: 'BigDataPoolReference'
    }
    targetSparkConfiguration: {
      referenceName: any()
      type: 'SparkConfigurationReference'
    }
  }

Для SqlServerStoredProcedure используйте:

  type: 'SqlServerStoredProcedure'
  linkedServiceName: {
    parameters: {}
    referenceName: 'string'
    type: 'LinkedServiceReference'
  }
  policy: {
    retry: any()
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any()
  }
  typeProperties: {
    storedProcedureName: any()
    storedProcedureParameters: any()
  }

Для параметра Switch используйте:

  type: 'Switch'
  typeProperties: {
    cases: [
      {
        activities: [
          {
            dependsOn: [
              {
                activity: 'string'
                dependencyConditions: [
                  'string'
                ]
              }
            ]
            description: 'string'
            name: 'string'
            userProperties: [
              {
                name: 'string'
                value: any()
              }
            ]
            type: 'string'
            // For remaining properties, see Activity objects
          }
        ]
        value: 'string'
      }
    ]
    defaultActivities: [
      {
        dependsOn: [
          {
            activity: 'string'
            dependencyConditions: [
              'string'
            ]
          }
        ]
        description: 'string'
        name: 'string'
        userProperties: [
          {
            name: 'string'
            value: any()
          }
        ]
        type: 'string'
        // For remaining properties, see Activity objects
      }
    ]
    on: {
      type: 'Expression'
      value: 'string'
    }
  }

Для SynapseNotebook используйте:

  type: 'SynapseNotebook'
  linkedServiceName: {
    parameters: {}
    referenceName: 'string'
    type: 'LinkedServiceReference'
  }
  policy: {
    retry: any()
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any()
  }
  typeProperties: {
    conf: any()
    driverSize: any()
    executorSize: any()
    notebook: {
      referenceName: any()
      type: 'NotebookReference'
    }
    numExecutors: int
    parameters: {}
    sparkPool: {
      referenceName: any()
      type: 'BigDataPoolReference'
    }
  }

Для параметра Until используйте:

  type: 'Until'
  typeProperties: {
    activities: [
      {
        dependsOn: [
          {
            activity: 'string'
            dependencyConditions: [
              'string'
            ]
          }
        ]
        description: 'string'
        name: 'string'
        userProperties: [
          {
            name: 'string'
            value: any()
          }
        ]
        type: 'string'
        // For remaining properties, see Activity objects
      }
    ]
    expression: {
      type: 'Expression'
      value: 'string'
    }
    timeout: any()
  }

Для проверки используйте:

  type: 'Validation'
  typeProperties: {
    childItems: any()
    dataset: {
      parameters: {}
      referenceName: 'string'
      type: 'DatasetReference'
    }
    minimumSize: any()
    sleep: any()
    timeout: any()
  }

Для параметра Ожидание используйте:

  type: 'Wait'
  typeProperties: {
    waitTimeInSeconds: any()
  }

Для WebActivity используйте:

  type: 'WebActivity'
  linkedServiceName: {
    parameters: {}
    referenceName: 'string'
    type: 'LinkedServiceReference'
  }
  policy: {
    retry: any()
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any()
  }
  typeProperties: {
    authentication: {
      credential: {
        referenceName: 'string'
        type: 'CredentialReference'
      }
      password: {
        type: 'string'
        // For remaining properties, see SecretBase objects
      }
      pfx: {
        type: 'string'
        // For remaining properties, see SecretBase objects
      }
      resource: any()
      type: 'string'
      username: any()
      userTenant: any()
    }
    body: any()
    connectVia: {
      parameters: {}
      referenceName: 'string'
      type: 'IntegrationRuntimeReference'
    }
    datasets: [
      {
        parameters: {}
        referenceName: 'string'
        type: 'DatasetReference'
      }
    ]
    disableCertValidation: bool
    headers: any()
    linkedServices: [
      {
        parameters: {}
        referenceName: 'string'
        type: 'LinkedServiceReference'
      }
    ]
    method: 'string'
    url: any()
  }

Для веб-перехватчика используйте:

  type: 'WebHook'
  typeProperties: {
    authentication: {
      credential: {
        referenceName: 'string'
        type: 'CredentialReference'
      }
      password: {
        type: 'string'
        // For remaining properties, see SecretBase objects
      }
      pfx: {
        type: 'string'
        // For remaining properties, see SecretBase objects
      }
      resource: any()
      type: 'string'
      username: any()
      userTenant: any()
    }
    body: any()
    headers: any()
    method: 'POST'
    reportStatusOnCallBack: any()
    timeout: 'string'
    url: any()
  }

Объекты CopySink

Задайте свойство type , чтобы указать тип объекта .

Для AvroSink используйте:

  type: 'AvroSink'
  formatSettings: {
    fileNamePrefix: any()
    maxRowsPerFile: any()
    recordName: 'string'
    recordNamespace: 'string'
    type: 'string'
  }
  storeSettings: {
    copyBehavior: any()
    disableMetricsCollection: any()
    maxConcurrentConnections: any()
    type: 'string'
    // For remaining properties, see StoreWriteSettings objects
  }

Для AzureBlobFSSink используйте:

  type: 'AzureBlobFSSink'
  copyBehavior: any()
  metadata: [
    {
      name: any()
      value: any()
    }
  ]

Для AzureDatabricksDeltaLakeSink используйте:

  type: 'AzureDatabricksDeltaLakeSink'
  importSettings: {
    dateFormat: any()
    timestampFormat: any()
    type: 'string'
  }
  preCopyScript: any()

Для AzureDataExplorerSink используйте:

  type: 'AzureDataExplorerSink'
  flushImmediately: any()
  ingestionMappingAsJson: any()
  ingestionMappingName: any()

Для AzureDataLakeStoreSink используйте:

  type: 'AzureDataLakeStoreSink'
  copyBehavior: any()
  enableAdlsSingleFileParallel: any()

Для AzureMySqlSink используйте:

  type: 'AzureMySqlSink'
  preCopyScript: any()

Для AzurePostgreSqlSink используйте:

  type: 'AzurePostgreSqlSink'
  preCopyScript: any()

Для AzureQueueSink используйте:

  type: 'AzureQueueSink'

Для AzureSearchIndexSink используйте:

  type: 'AzureSearchIndexSink'
  writeBehavior: 'string'

Для AzureSqlSink используйте:

  type: 'AzureSqlSink'
  preCopyScript: any()
  sqlWriterStoredProcedureName: any()
  sqlWriterTableType: any()
  sqlWriterUseTableLock: any()
  storedProcedureParameters: any()
  storedProcedureTableTypeParameterName: any()
  tableOption: any()
  upsertSettings: {
    interimSchemaName: any()
    keys: any()
    useTempDB: any()
  }
  writeBehavior: any()

Для AzureTableSink используйте:

  type: 'AzureTableSink'
  azureTableDefaultPartitionKeyValue: any()
  azureTableInsertType: any()
  azureTablePartitionKeyName: any()
  azureTableRowKeyName: any()

Для BinarySink используйте:

  type: 'BinarySink'
  storeSettings: {
    copyBehavior: any()
    disableMetricsCollection: any()
    maxConcurrentConnections: any()
    type: 'string'
    // For remaining properties, see StoreWriteSettings objects
  }

Для BlobSink используйте:

  type: 'BlobSink'
  blobWriterAddHeader: any()
  blobWriterDateTimeFormat: any()
  blobWriterOverwriteFiles: any()
  copyBehavior: any()
  metadata: [
    {
      name: any()
      value: any()
    }
  ]

Для CommonDataServiceForAppsSink используйте:

  type: 'CommonDataServiceForAppsSink'
  alternateKeyName: any()
  ignoreNullValues: any()
  writeBehavior: 'Upsert'

Для CosmosDbMongoDbApiSink используйте:

  type: 'CosmosDbMongoDbApiSink'
  writeBehavior: any()

Для CosmosDbSqlApiSink используйте:

  type: 'CosmosDbSqlApiSink'
  writeBehavior: any()

Для DelimitedTextSink используйте:

  type: 'DelimitedTextSink'
  formatSettings: {
    fileExtension: any()
    fileNamePrefix: any()
    maxRowsPerFile: any()
    quoteAllText: any()
    type: 'string'
  }
  storeSettings: {
    copyBehavior: any()
    disableMetricsCollection: any()
    maxConcurrentConnections: any()
    type: 'string'
    // For remaining properties, see StoreWriteSettings objects
  }

Для DocumentDbCollectionSink используйте:

  type: 'DocumentDbCollectionSink'
  nestingSeparator: any()
  writeBehavior: any()

Для DynamicsCrmSink используйте:

  type: 'DynamicsCrmSink'
  alternateKeyName: any()
  ignoreNullValues: any()
  writeBehavior: 'Upsert'

Для DynamicsSink используйте:

  type: 'DynamicsSink'
  alternateKeyName: any()
  ignoreNullValues: any()
  writeBehavior: 'Upsert'

Для FileSystemSink используйте:

  type: 'FileSystemSink'
  copyBehavior: any()

Для InformixSink используйте:

  type: 'InformixSink'
  preCopyScript: any()

Для JsonSink используйте:

  type: 'JsonSink'
  formatSettings: {
    filePattern: any()
    type: 'string'
  }
  storeSettings: {
    copyBehavior: any()
    disableMetricsCollection: any()
    maxConcurrentConnections: any()
    type: 'string'
    // For remaining properties, see StoreWriteSettings objects
  }

Для MicrosoftAccessSink используйте:

  type: 'MicrosoftAccessSink'
  preCopyScript: any()

Для MongoDbAtlasSink используйте:

  type: 'MongoDbAtlasSink'
  writeBehavior: any()

Для MongoDbV2Sink используйте:

  type: 'MongoDbV2Sink'
  writeBehavior: any()

Для OdbcSink используйте:

  type: 'OdbcSink'
  preCopyScript: any()

Для OracleSink используйте:

  type: 'OracleSink'
  preCopyScript: any()

Для OrcSink используйте:

  type: 'OrcSink'
  formatSettings: {
    fileNamePrefix: any()
    maxRowsPerFile: any()
    type: 'string'
  }
  storeSettings: {
    copyBehavior: any()
    disableMetricsCollection: any()
    maxConcurrentConnections: any()
    type: 'string'
    // For remaining properties, see StoreWriteSettings objects
  }

Для ParquetSink используйте:

  type: 'ParquetSink'
  formatSettings: {
    fileNamePrefix: any()
    maxRowsPerFile: any()
    type: 'string'
  }
  storeSettings: {
    copyBehavior: any()
    disableMetricsCollection: any()
    maxConcurrentConnections: any()
    type: 'string'
    // For remaining properties, see StoreWriteSettings objects
  }

Для RestSink используйте:

  type: 'RestSink'
  additionalHeaders: any()
  httpCompressionType: any()
  httpRequestTimeout: any()
  requestInterval: any()
  requestMethod: any()

Для SalesforceServiceCloudSink используйте:

  type: 'SalesforceServiceCloudSink'
  externalIdFieldName: any()
  ignoreNullValues: any()
  writeBehavior: 'string'

Для SalesforceSink используйте:

  type: 'SalesforceSink'
  externalIdFieldName: any()
  ignoreNullValues: any()
  writeBehavior: 'string'

Для SapCloudForCustomerSink используйте:

  type: 'SapCloudForCustomerSink'
  httpRequestTimeout: any()
  writeBehavior: 'string'

Для SnowflakeSink используйте:

  type: 'SnowflakeSink'
  importSettings: {
    additionalCopyOptions: {}
    additionalFormatOptions: {}
    type: 'string'
  }
  preCopyScript: any()

Для SqlDWSink используйте:

  type: 'SqlDWSink'
  allowCopyCommand: any()
  allowPolyBase: any()
  copyCommandSettings: {
    additionalOptions: {}
    defaultValues: [
      {
        columnName: any()
        defaultValue: any()
      }
    ]
  }
  polyBaseSettings: {
    rejectSampleValue: any()
    rejectType: 'string'
    rejectValue: any()
    useTypeDefault: any()
  }
  preCopyScript: any()
  sqlWriterUseTableLock: any()
  tableOption: any()
  upsertSettings: {
    interimSchemaName: any()
    keys: any()
  }
  writeBehavior: any()

Для SqlMISink используйте:

  type: 'SqlMISink'
  preCopyScript: any()
  sqlWriterStoredProcedureName: any()
  sqlWriterTableType: any()
  sqlWriterUseTableLock: any()
  storedProcedureParameters: any()
  storedProcedureTableTypeParameterName: any()
  tableOption: any()
  upsertSettings: {
    interimSchemaName: any()
    keys: any()
    useTempDB: any()
  }
  writeBehavior: any()

Для SqlServerSink используйте:

  type: 'SqlServerSink'
  preCopyScript: any()
  sqlWriterStoredProcedureName: any()
  sqlWriterTableType: any()
  sqlWriterUseTableLock: any()
  storedProcedureParameters: any()
  storedProcedureTableTypeParameterName: any()
  tableOption: any()
  upsertSettings: {
    interimSchemaName: any()
    keys: any()
    useTempDB: any()
  }
  writeBehavior: any()

Для SqlSink используйте:

  type: 'SqlSink'
  preCopyScript: any()
  sqlWriterStoredProcedureName: any()
  sqlWriterTableType: any()
  sqlWriterUseTableLock: any()
  storedProcedureParameters: any()
  storedProcedureTableTypeParameterName: any()
  tableOption: any()
  upsertSettings: {
    interimSchemaName: any()
    keys: any()
    useTempDB: any()
  }
  writeBehavior: any()

Объекты StoreWriteSettings

Задайте свойство type , чтобы указать тип объекта .

Для AzureBlobFSWriteSettings используйте:

  type: 'AzureBlobFSWriteSettings'
  blockSizeInMB: any()

Для AzureBlobStorageWriteSettings используйте:

  type: 'AzureBlobStorageWriteSettings'
  blockSizeInMB: any()

Для AzureDataLakeStoreWriteSettings используйте:

  type: 'AzureDataLakeStoreWriteSettings'
  expiryDateTime: any()

Для AzureFileStorageWriteSettings используйте:

  type: 'AzureFileStorageWriteSettings'

Для FileServerWriteSettings используйте:

  type: 'FileServerWriteSettings'

Для SftpWriteSettings используйте:

  type: 'SftpWriteSettings'
  operationTimeout: any()
  useTempFileRename: any()

Объекты CopySource

Задайте свойство type , чтобы указать тип объекта .

Для AmazonMWSSource используйте:

  type: 'AmazonMWSSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для AmazonRdsForOracleSource используйте:

  type: 'AmazonRdsForOracleSource'
  additionalColumns: any()
  oracleReaderQuery: any()
  partitionOption: any()
  partitionSettings: {
    partitionColumnName: any()
    partitionLowerBound: any()
    partitionNames: any()
    partitionUpperBound: any()
  }
  queryTimeout: any()

Для AmazonRdsForSqlServerSource используйте:

  type: 'AmazonRdsForSqlServerSource'
  additionalColumns: any()
  partitionOption: any()
  partitionSettings: {
    partitionColumnName: any()
    partitionLowerBound: any()
    partitionUpperBound: any()
  }
  produceAdditionalTypes: any()
  queryTimeout: any()
  sqlReaderQuery: any()
  sqlReaderStoredProcedureName: any()
  storedProcedureParameters: any()

Для AmazonRedshiftSource используйте:

  type: 'AmazonRedshiftSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()
  redshiftUnloadSettings: {
    bucketName: any()
    s3LinkedServiceName: {
      parameters: {}
      referenceName: 'string'
      type: 'LinkedServiceReference'
    }
  }

Для AvroSource используйте:

  type: 'AvroSource'
  additionalColumns: any()
  storeSettings: {
    disableMetricsCollection: any()
    maxConcurrentConnections: any()
    type: 'string'
    // For remaining properties, see StoreReadSettings objects
  }

Для AzureBlobFSSource используйте:

  type: 'AzureBlobFSSource'
  recursive: any()
  skipHeaderLineCount: any()
  treatEmptyAsNull: any()

Для AzureDatabricksDeltaLakeSource используйте:

  type: 'AzureDatabricksDeltaLakeSource'
  exportSettings: {
    dateFormat: any()
    timestampFormat: any()
    type: 'string'
  }
  query: any()

Для AzureDataExplorerSource используйте:

  type: 'AzureDataExplorerSource'
  additionalColumns: any()
  noTruncation: any()
  query: any()
  queryTimeout: any()

Для AzureDataLakeStoreSource используйте:

  type: 'AzureDataLakeStoreSource'
  recursive: any()

Для AzureMariaDBSource используйте:

  type: 'AzureMariaDBSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для AzureMySqlSource используйте:

  type: 'AzureMySqlSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для AzurePostgreSqlSource используйте:

  type: 'AzurePostgreSqlSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для AzureSqlSource используйте:

  type: 'AzureSqlSource'
  additionalColumns: any()
  partitionOption: any()
  partitionSettings: {
    partitionColumnName: any()
    partitionLowerBound: any()
    partitionUpperBound: any()
  }
  produceAdditionalTypes: any()
  queryTimeout: any()
  sqlReaderQuery: any()
  sqlReaderStoredProcedureName: any()
  storedProcedureParameters: any()

Для AzureTableSource используйте:

  type: 'AzureTableSource'
  additionalColumns: any()
  azureTableSourceIgnoreTableNotFound: any()
  azureTableSourceQuery: any()
  queryTimeout: any()

Для BinarySource используйте:

  type: 'BinarySource'
  formatSettings: {
    compressionProperties: {
      type: 'string'
      // For remaining properties, see CompressionReadSettings objects
    }
    type: 'string'
  }
  storeSettings: {
    disableMetricsCollection: any()
    maxConcurrentConnections: any()
    type: 'string'
    // For remaining properties, see StoreReadSettings objects
  }

Для BlobSource используйте:

  type: 'BlobSource'
  recursive: any()
  skipHeaderLineCount: any()
  treatEmptyAsNull: any()

Для CassandraSource используйте:

  type: 'CassandraSource'
  additionalColumns: any()
  consistencyLevel: 'string'
  query: any()
  queryTimeout: any()

Для CommonDataServiceForAppsSource используйте:

  type: 'CommonDataServiceForAppsSource'
  additionalColumns: any()
  query: any()

Для ConcurSource используйте:

  type: 'ConcurSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для CosmosDbMongoDbApiSource используйте:

  type: 'CosmosDbMongoDbApiSource'
  additionalColumns: any()
  batchSize: any()
  cursorMethods: {
    limit: any()
    project: any()
    skip: any()
    sort: any()
  }
  filter: any()
  queryTimeout: any()

Для CosmosDbSqlApiSource используйте:

  type: 'CosmosDbSqlApiSource'
  additionalColumns: any()
  detectDatetime: any()
  pageSize: any()
  preferredRegions: any()
  query: any()

Для CouchbaseSource используйте:

  type: 'CouchbaseSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для Db2Source используйте:

  type: 'Db2Source'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для DelimitedTextSource используйте:

  type: 'DelimitedTextSource'
  additionalColumns: any()
  formatSettings: {
    compressionProperties: {
      type: 'string'
      // For remaining properties, see CompressionReadSettings objects
    }
    skipLineCount: any()
    type: 'string'
  }
  storeSettings: {
    disableMetricsCollection: any()
    maxConcurrentConnections: any()
    type: 'string'
    // For remaining properties, see StoreReadSettings objects
  }

Для DocumentDbCollectionSource используйте:

  type: 'DocumentDbCollectionSource'
  additionalColumns: any()
  nestingSeparator: any()
  query: any()
  queryTimeout: any()

Для DrillSource используйте:

  type: 'DrillSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для DynamicsAXSource используйте:

  type: 'DynamicsAXSource'
  additionalColumns: any()
  httpRequestTimeout: any()
  query: any()
  queryTimeout: any()

Для DynamicsCrmSource используйте:

  type: 'DynamicsCrmSource'
  additionalColumns: any()
  query: any()

Для DynamicsSource используйте:

  type: 'DynamicsSource'
  additionalColumns: any()
  query: any()

Для EloquaSource используйте:

  type: 'EloquaSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для ExcelSource используйте:

  type: 'ExcelSource'
  additionalColumns: any()
  storeSettings: {
    disableMetricsCollection: any()
    maxConcurrentConnections: any()
    type: 'string'
    // For remaining properties, see StoreReadSettings objects
  }

Для FileSystemSource используйте:

  type: 'FileSystemSource'
  additionalColumns: any()
  recursive: any()

Для GoogleAdWordsSource используйте:

  type: 'GoogleAdWordsSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для GoogleBigQuerySource используйте:

  type: 'GoogleBigQuerySource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для GreenplumSource используйте:

  type: 'GreenplumSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для HBaseSource используйте:

  type: 'HBaseSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для HdfsSource используйте:

  type: 'HdfsSource'
  distcpSettings: {
    distcpOptions: any()
    resourceManagerEndpoint: any()
    tempScriptPath: any()
  }
  recursive: any()

Для HiveSource используйте:

  type: 'HiveSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для HttpSource используйте:

  type: 'HttpSource'
  httpRequestTimeout: any()

Для HubspotSource используйте:

  type: 'HubspotSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для ImpalaSource используйте:

  type: 'ImpalaSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для InformixSource используйте:

  type: 'InformixSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для JiraSource используйте:

  type: 'JiraSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для JsonSource используйте:

  type: 'JsonSource'
  additionalColumns: any()
  formatSettings: {
    compressionProperties: {
      type: 'string'
      // For remaining properties, see CompressionReadSettings objects
    }
    type: 'string'
  }
  storeSettings: {
    disableMetricsCollection: any()
    maxConcurrentConnections: any()
    type: 'string'
    // For remaining properties, see StoreReadSettings objects
  }

Для MagentoSource используйте:

  type: 'MagentoSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для MariaDBSource используйте:

  type: 'MariaDBSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для MarketoSource используйте:

  type: 'MarketoSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для MicrosoftAccessSource используйте:

  type: 'MicrosoftAccessSource'
  additionalColumns: any()
  query: any()

Для MongoDbAtlasSource используйте:

  type: 'MongoDbAtlasSource'
  additionalColumns: any()
  batchSize: any()
  cursorMethods: {
    limit: any()
    project: any()
    skip: any()
    sort: any()
  }
  filter: any()
  queryTimeout: any()

Для MongoDbSource используйте:

  type: 'MongoDbSource'
  additionalColumns: any()
  query: any()

Для MongoDbV2Source используйте:

  type: 'MongoDbV2Source'
  additionalColumns: any()
  batchSize: any()
  cursorMethods: {
    limit: any()
    project: any()
    skip: any()
    sort: any()
  }
  filter: any()
  queryTimeout: any()

Для MySqlSource используйте:

  type: 'MySqlSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для NetezzaSource используйте:

  type: 'NetezzaSource'
  additionalColumns: any()
  partitionOption: any()
  partitionSettings: {
    partitionColumnName: any()
    partitionLowerBound: any()
    partitionUpperBound: any()
  }
  query: any()
  queryTimeout: any()

Для ODataSource используйте:

  type: 'ODataSource'
  additionalColumns: any()
  httpRequestTimeout: any()
  query: any()

Для OdbcSource используйте:

  type: 'OdbcSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для Office365Source используйте:

  type: 'Office365Source'
  allowedGroups: any()
  dateFilterColumn: any()
  endTime: any()
  outputColumns: any()
  startTime: any()
  userScopeFilterUri: any()

Для OracleServiceCloudSource используйте:

  type: 'OracleServiceCloudSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для OracleSource используйте:

  type: 'OracleSource'
  additionalColumns: any()
  oracleReaderQuery: any()
  partitionOption: any()
  partitionSettings: {
    partitionColumnName: any()
    partitionLowerBound: any()
    partitionNames: any()
    partitionUpperBound: any()
  }
  queryTimeout: any()

Для OrcSource используйте:

  type: 'OrcSource'
  additionalColumns: any()
  storeSettings: {
    disableMetricsCollection: any()
    maxConcurrentConnections: any()
    type: 'string'
    // For remaining properties, see StoreReadSettings objects
  }

Для ParquetSource используйте:

  type: 'ParquetSource'
  additionalColumns: any()
  storeSettings: {
    disableMetricsCollection: any()
    maxConcurrentConnections: any()
    type: 'string'
    // For remaining properties, see StoreReadSettings objects
  }

Для PaypalSource используйте:

  type: 'PaypalSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для PhoenixSource используйте:

  type: 'PhoenixSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для PostgreSqlSource используйте:

  type: 'PostgreSqlSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для PrestoSource используйте:

  type: 'PrestoSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для QuickBooksSource используйте:

  type: 'QuickBooksSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для RelationalSource используйте:

  type: 'RelationalSource'
  additionalColumns: any()
  query: any()

Для ResponsysSource используйте:

  type: 'ResponsysSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для RestSource используйте:

  type: 'RestSource'
  additionalColumns: any()
  additionalHeaders: any()
  httpRequestTimeout: any()
  paginationRules: any()
  requestBody: any()
  requestInterval: any()
  requestMethod: any()

Для SalesforceMarketingCloudSource используйте:

  type: 'SalesforceMarketingCloudSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для SalesforceServiceCloudSource используйте:

  type: 'SalesforceServiceCloudSource'
  additionalColumns: any()
  query: any()
  readBehavior: 'string'

Для SalesforceSource используйте:

  type: 'SalesforceSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()
  readBehavior: 'string'

Для SapBwSource используйте:

  type: 'SapBwSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для SapCloudForCustomerSource используйте:

  type: 'SapCloudForCustomerSource'
  additionalColumns: any()
  httpRequestTimeout: any()
  query: any()
  queryTimeout: any()

Для SapEccSource используйте:

  type: 'SapEccSource'
  additionalColumns: any()
  httpRequestTimeout: any()
  query: any()
  queryTimeout: any()

Для SapHanaSource используйте:

  type: 'SapHanaSource'
  additionalColumns: any()
  packetSize: any()
  partitionOption: any()
  partitionSettings: {
    partitionColumnName: any()
  }
  query: any()
  queryTimeout: any()

Для SapOdpSource используйте:

  type: 'SapOdpSource'
  additionalColumns: any()
  extractionMode: any()
  projection: any()
  queryTimeout: any()
  selection: any()
  subscriberProcess: any()

Для SapOpenHubSource используйте:

  type: 'SapOpenHubSource'
  additionalColumns: any()
  baseRequestId: any()
  customRfcReadTableFunctionModule: any()
  excludeLastRequest: any()
  queryTimeout: any()
  sapDataColumnDelimiter: any()

Для SapTableSource используйте:

  type: 'SapTableSource'
  additionalColumns: any()
  batchSize: any()
  customRfcReadTableFunctionModule: any()
  partitionOption: any()
  partitionSettings: {
    maxPartitionsNumber: any()
    partitionColumnName: any()
    partitionLowerBound: any()
    partitionUpperBound: any()
  }
  queryTimeout: any()
  rfcTableFields: any()
  rfcTableOptions: any()
  rowCount: any()
  rowSkips: any()
  sapDataColumnDelimiter: any()

Для ServiceNowSource используйте:

  type: 'ServiceNowSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для SharePointOnlineListSource используйте:

  type: 'SharePointOnlineListSource'
  httpRequestTimeout: any()
  query: any()

Для ShopifySource используйте:

  type: 'ShopifySource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для SnowflakeSource используйте:

  type: 'SnowflakeSource'
  exportSettings: {
    additionalCopyOptions: {}
    additionalFormatOptions: {}
    type: 'string'
  }
  query: any()

Для SparkSource используйте:

  type: 'SparkSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для SqlDWSource используйте:

  type: 'SqlDWSource'
  additionalColumns: any()
  partitionOption: any()
  partitionSettings: {
    partitionColumnName: any()
    partitionLowerBound: any()
    partitionUpperBound: any()
  }
  queryTimeout: any()
  sqlReaderQuery: any()
  sqlReaderStoredProcedureName: any()
  storedProcedureParameters: any()

Для SqlMISource используйте:

  type: 'SqlMISource'
  additionalColumns: any()
  partitionOption: any()
  partitionSettings: {
    partitionColumnName: any()
    partitionLowerBound: any()
    partitionUpperBound: any()
  }
  produceAdditionalTypes: any()
  queryTimeout: any()
  sqlReaderQuery: any()
  sqlReaderStoredProcedureName: any()
  storedProcedureParameters: any()

Для SqlServerSource используйте:

  type: 'SqlServerSource'
  additionalColumns: any()
  partitionOption: any()
  partitionSettings: {
    partitionColumnName: any()
    partitionLowerBound: any()
    partitionUpperBound: any()
  }
  produceAdditionalTypes: any()
  queryTimeout: any()
  sqlReaderQuery: any()
  sqlReaderStoredProcedureName: any()
  storedProcedureParameters: any()

Для SqlSource используйте:

  type: 'SqlSource'
  additionalColumns: any()
  isolationLevel: any()
  partitionOption: any()
  partitionSettings: {
    partitionColumnName: any()
    partitionLowerBound: any()
    partitionUpperBound: any()
  }
  queryTimeout: any()
  sqlReaderQuery: any()
  sqlReaderStoredProcedureName: any()
  storedProcedureParameters: any()

Для SquareSource используйте:

  type: 'SquareSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для SybaseSource используйте:

  type: 'SybaseSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для TeradataSource используйте:

  type: 'TeradataSource'
  additionalColumns: any()
  partitionOption: any()
  partitionSettings: {
    partitionColumnName: any()
    partitionLowerBound: any()
    partitionUpperBound: any()
  }
  query: any()
  queryTimeout: any()

Для VerticaSource используйте:

  type: 'VerticaSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для WebSource используйте:

  type: 'WebSource'
  additionalColumns: any()

Для XeroSource используйте:

  type: 'XeroSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Для XmlSource используйте:

  type: 'XmlSource'
  additionalColumns: any()
  formatSettings: {
    compressionProperties: {
      type: 'string'
      // For remaining properties, see CompressionReadSettings objects
    }
    detectDataType: any()
    namespacePrefixes: any()
    namespaces: any()
    type: 'string'
    validationMode: any()
  }
  storeSettings: {
    disableMetricsCollection: any()
    maxConcurrentConnections: any()
    type: 'string'
    // For remaining properties, see StoreReadSettings objects
  }

Для ZohoSource используйте:

  type: 'ZohoSource'
  additionalColumns: any()
  query: any()
  queryTimeout: any()

Объекты StoreReadSettings

Задайте свойство type , чтобы указать тип объекта .

Для AmazonS3CompatibleReadSettings используйте:

  type: 'AmazonS3CompatibleReadSettings'
  deleteFilesAfterCompletion: any()
  enablePartitionDiscovery: bool
  fileListPath: any()
  modifiedDatetimeEnd: any()
  modifiedDatetimeStart: any()
  partitionRootPath: any()
  prefix: any()
  recursive: any()
  wildcardFileName: any()
  wildcardFolderPath: any()

Для AmazonS3ReadSettings используйте:

  type: 'AmazonS3ReadSettings'
  deleteFilesAfterCompletion: any()
  enablePartitionDiscovery: bool
  fileListPath: any()
  modifiedDatetimeEnd: any()
  modifiedDatetimeStart: any()
  partitionRootPath: any()
  prefix: any()
  recursive: any()
  wildcardFileName: any()
  wildcardFolderPath: any()

Для AzureBlobFSReadSettings используйте:

  type: 'AzureBlobFSReadSettings'
  deleteFilesAfterCompletion: any()
  enablePartitionDiscovery: bool
  fileListPath: any()
  modifiedDatetimeEnd: any()
  modifiedDatetimeStart: any()
  partitionRootPath: any()
  recursive: any()
  wildcardFileName: any()
  wildcardFolderPath: any()

Для AzureBlobStorageReadSettings используйте:

  type: 'AzureBlobStorageReadSettings'
  deleteFilesAfterCompletion: any()
  enablePartitionDiscovery: bool
  fileListPath: any()
  modifiedDatetimeEnd: any()
  modifiedDatetimeStart: any()
  partitionRootPath: any()
  prefix: any()
  recursive: any()
  wildcardFileName: any()
  wildcardFolderPath: any()

Для AzureDataLakeStoreReadSettings используйте:

  type: 'AzureDataLakeStoreReadSettings'
  deleteFilesAfterCompletion: any()
  enablePartitionDiscovery: bool
  fileListPath: any()
  listAfter: any()
  listBefore: any()
  modifiedDatetimeEnd: any()
  modifiedDatetimeStart: any()
  partitionRootPath: any()
  recursive: any()
  wildcardFileName: any()
  wildcardFolderPath: any()

Для AzureFileStorageReadSettings используйте:

  type: 'AzureFileStorageReadSettings'
  deleteFilesAfterCompletion: any()
  enablePartitionDiscovery: bool
  fileListPath: any()
  modifiedDatetimeEnd: any()
  modifiedDatetimeStart: any()
  partitionRootPath: any()
  prefix: any()
  recursive: any()
  wildcardFileName: any()
  wildcardFolderPath: any()

Для FileServerReadSettings используйте:

  type: 'FileServerReadSettings'
  deleteFilesAfterCompletion: any()
  enablePartitionDiscovery: bool
  fileFilter: any()
  fileListPath: any()
  modifiedDatetimeEnd: any()
  modifiedDatetimeStart: any()
  partitionRootPath: any()
  recursive: any()
  wildcardFileName: any()
  wildcardFolderPath: any()

Для ftpReadSettings используйте:

  type: 'FtpReadSettings'
  deleteFilesAfterCompletion: any()
  disableChunking: any()
  enablePartitionDiscovery: bool
  fileListPath: any()
  partitionRootPath: any()
  recursive: any()
  useBinaryTransfer: bool
  wildcardFileName: any()
  wildcardFolderPath: any()

Для GoogleCloudStorageReadSettings используйте:

  type: 'GoogleCloudStorageReadSettings'
  deleteFilesAfterCompletion: any()
  enablePartitionDiscovery: bool
  fileListPath: any()
  modifiedDatetimeEnd: any()
  modifiedDatetimeStart: any()
  partitionRootPath: any()
  prefix: any()
  recursive: any()
  wildcardFileName: any()
  wildcardFolderPath: any()

Для HdfsReadSettings используйте:

  type: 'HdfsReadSettings'
  deleteFilesAfterCompletion: any()
  distcpSettings: {
    distcpOptions: any()
    resourceManagerEndpoint: any()
    tempScriptPath: any()
  }
  enablePartitionDiscovery: bool
  fileListPath: any()
  modifiedDatetimeEnd: any()
  modifiedDatetimeStart: any()
  partitionRootPath: any()
  recursive: any()
  wildcardFileName: any()
  wildcardFolderPath: any()

Для HttpReadSettings используйте:

  type: 'HttpReadSettings'
  additionalHeaders: any()
  enablePartitionDiscovery: bool
  partitionRootPath: any()
  requestBody: any()
  requestMethod: any()
  requestTimeout: any()

Для OracleCloudStorageReadSettings используйте:

  type: 'OracleCloudStorageReadSettings'
  deleteFilesAfterCompletion: any()
  enablePartitionDiscovery: bool
  fileListPath: any()
  modifiedDatetimeEnd: any()
  modifiedDatetimeStart: any()
  partitionRootPath: any()
  prefix: any()
  recursive: any()
  wildcardFileName: any()
  wildcardFolderPath: any()

Для SftpReadSettings используйте:

  type: 'SftpReadSettings'
  deleteFilesAfterCompletion: any()
  disableChunking: any()
  enablePartitionDiscovery: bool
  fileListPath: any()
  modifiedDatetimeEnd: any()
  modifiedDatetimeStart: any()
  partitionRootPath: any()
  recursive: any()
  wildcardFileName: any()
  wildcardFolderPath: any()

Объекты CompressionReadSettings

Задайте свойство type , чтобы указать тип объекта .

Для TarGZipReadSettings используйте:

  type: 'TarGZipReadSettings'
  preserveCompressionFileNameAsFolder: any()

Для TarReadSettings используйте:

  type: 'TarReadSettings'
  preserveCompressionFileNameAsFolder: any()

Для ZipDeflateReadSettings используйте:

  type: 'ZipDeflateReadSettings'
  preserveZipFileNameAsFolder: any()

Объекты SecretBase

Задайте свойство type , чтобы указать тип объекта .

Для AzureKeyVaultSecret используйте:

  type: 'AzureKeyVaultSecret'
  secretName: any()
  secretVersion: any()
  store: {
    parameters: {}
    referenceName: 'string'
    type: 'LinkedServiceReference'
  }

Для SecureString используйте:

  type: 'SecureString'
  value: 'string'

Объекты FormatReadSettings

Задайте свойство type , чтобы указать тип объекта .

Для BinaryReadSettings используйте:

  type: 'BinaryReadSettings'
  compressionProperties: {
    type: 'string'
    // For remaining properties, see CompressionReadSettings objects
  }

Для delimitedTextReadSettings используйте:

  type: 'DelimitedTextReadSettings'
  compressionProperties: {
    type: 'string'
    // For remaining properties, see CompressionReadSettings objects
  }
  skipLineCount: any()

Для JsonReadSettings используйте:

  type: 'JsonReadSettings'
  compressionProperties: {
    type: 'string'
    // For remaining properties, see CompressionReadSettings objects
  }

Для XmlReadSettings используйте:

  type: 'XmlReadSettings'
  compressionProperties: {
    type: 'string'
    // For remaining properties, see CompressionReadSettings objects
  }
  detectDataType: any()
  namespacePrefixes: any()
  namespaces: any()
  validationMode: any()

Значения свойств