Microsoft.DataFactory factories/pipelines

Article
12/03/2024

Bicep resource definition

The factories/pipelines resource type can be deployed with operations that target:

Resource groups - See resource group deployment commands

For a list of changed properties in each API version, see change log.

Resource format

To create a Microsoft.DataFactory/factories/pipelines resource, add the following Bicep to your template.

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

StoreReadSettings objects

Set the type property to specify the type of object.

For AmazonS3CompatibleReadSettings, use:

{
  deleteFilesAfterCompletion: any(Azure.Bicep.Types.Concrete.AnyType)
  enablePartitionDiscovery: any(Azure.Bicep.Types.Concrete.AnyType)
  fileListPath: any(Azure.Bicep.Types.Concrete.AnyType)
  modifiedDatetimeEnd: any(Azure.Bicep.Types.Concrete.AnyType)
  modifiedDatetimeStart: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionRootPath: any(Azure.Bicep.Types.Concrete.AnyType)
  prefix: any(Azure.Bicep.Types.Concrete.AnyType)
  recursive: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'AmazonS3CompatibleReadSettings'
  wildcardFileName: any(Azure.Bicep.Types.Concrete.AnyType)
  wildcardFolderPath: any(Azure.Bicep.Types.Concrete.AnyType)
}

For AmazonS3ReadSettings, use:

{
  deleteFilesAfterCompletion: any(Azure.Bicep.Types.Concrete.AnyType)
  enablePartitionDiscovery: any(Azure.Bicep.Types.Concrete.AnyType)
  fileListPath: any(Azure.Bicep.Types.Concrete.AnyType)
  modifiedDatetimeEnd: any(Azure.Bicep.Types.Concrete.AnyType)
  modifiedDatetimeStart: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionRootPath: any(Azure.Bicep.Types.Concrete.AnyType)
  prefix: any(Azure.Bicep.Types.Concrete.AnyType)
  recursive: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'AmazonS3ReadSettings'
  wildcardFileName: any(Azure.Bicep.Types.Concrete.AnyType)
  wildcardFolderPath: any(Azure.Bicep.Types.Concrete.AnyType)
}

For AzureBlobFSReadSettings, use:

{
  deleteFilesAfterCompletion: any(Azure.Bicep.Types.Concrete.AnyType)
  enablePartitionDiscovery: any(Azure.Bicep.Types.Concrete.AnyType)
  fileListPath: any(Azure.Bicep.Types.Concrete.AnyType)
  modifiedDatetimeEnd: any(Azure.Bicep.Types.Concrete.AnyType)
  modifiedDatetimeStart: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionRootPath: any(Azure.Bicep.Types.Concrete.AnyType)
  recursive: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'AzureBlobFSReadSettings'
  wildcardFileName: any(Azure.Bicep.Types.Concrete.AnyType)
  wildcardFolderPath: any(Azure.Bicep.Types.Concrete.AnyType)
}

For AzureBlobStorageReadSettings, use:

{
  deleteFilesAfterCompletion: any(Azure.Bicep.Types.Concrete.AnyType)
  enablePartitionDiscovery: any(Azure.Bicep.Types.Concrete.AnyType)
  fileListPath: any(Azure.Bicep.Types.Concrete.AnyType)
  modifiedDatetimeEnd: any(Azure.Bicep.Types.Concrete.AnyType)
  modifiedDatetimeStart: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionRootPath: any(Azure.Bicep.Types.Concrete.AnyType)
  prefix: any(Azure.Bicep.Types.Concrete.AnyType)
  recursive: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'AzureBlobStorageReadSettings'
  wildcardFileName: any(Azure.Bicep.Types.Concrete.AnyType)
  wildcardFolderPath: any(Azure.Bicep.Types.Concrete.AnyType)
}

For AzureDataLakeStoreReadSettings, use:

{
  deleteFilesAfterCompletion: any(Azure.Bicep.Types.Concrete.AnyType)
  enablePartitionDiscovery: any(Azure.Bicep.Types.Concrete.AnyType)
  fileListPath: any(Azure.Bicep.Types.Concrete.AnyType)
  listAfter: any(Azure.Bicep.Types.Concrete.AnyType)
  listBefore: any(Azure.Bicep.Types.Concrete.AnyType)
  modifiedDatetimeEnd: any(Azure.Bicep.Types.Concrete.AnyType)
  modifiedDatetimeStart: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionRootPath: any(Azure.Bicep.Types.Concrete.AnyType)
  recursive: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'AzureDataLakeStoreReadSettings'
  wildcardFileName: any(Azure.Bicep.Types.Concrete.AnyType)
  wildcardFolderPath: any(Azure.Bicep.Types.Concrete.AnyType)
}

For AzureFileStorageReadSettings, use:

{
  deleteFilesAfterCompletion: any(Azure.Bicep.Types.Concrete.AnyType)
  enablePartitionDiscovery: any(Azure.Bicep.Types.Concrete.AnyType)
  fileListPath: any(Azure.Bicep.Types.Concrete.AnyType)
  modifiedDatetimeEnd: any(Azure.Bicep.Types.Concrete.AnyType)
  modifiedDatetimeStart: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionRootPath: any(Azure.Bicep.Types.Concrete.AnyType)
  prefix: any(Azure.Bicep.Types.Concrete.AnyType)
  recursive: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'AzureFileStorageReadSettings'
  wildcardFileName: any(Azure.Bicep.Types.Concrete.AnyType)
  wildcardFolderPath: any(Azure.Bicep.Types.Concrete.AnyType)
}

For FileServerReadSettings, use:

{
  deleteFilesAfterCompletion: any(Azure.Bicep.Types.Concrete.AnyType)
  enablePartitionDiscovery: any(Azure.Bicep.Types.Concrete.AnyType)
  fileFilter: any(Azure.Bicep.Types.Concrete.AnyType)
  fileListPath: any(Azure.Bicep.Types.Concrete.AnyType)
  modifiedDatetimeEnd: any(Azure.Bicep.Types.Concrete.AnyType)
  modifiedDatetimeStart: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionRootPath: any(Azure.Bicep.Types.Concrete.AnyType)
  recursive: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'FileServerReadSettings'
  wildcardFileName: any(Azure.Bicep.Types.Concrete.AnyType)
  wildcardFolderPath: any(Azure.Bicep.Types.Concrete.AnyType)
}

For FtpReadSettings, use:

{
  deleteFilesAfterCompletion: any(Azure.Bicep.Types.Concrete.AnyType)
  disableChunking: any(Azure.Bicep.Types.Concrete.AnyType)
  enablePartitionDiscovery: any(Azure.Bicep.Types.Concrete.AnyType)
  fileListPath: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionRootPath: any(Azure.Bicep.Types.Concrete.AnyType)
  recursive: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'FtpReadSettings'
  useBinaryTransfer: any(Azure.Bicep.Types.Concrete.AnyType)
  wildcardFileName: any(Azure.Bicep.Types.Concrete.AnyType)
  wildcardFolderPath: any(Azure.Bicep.Types.Concrete.AnyType)
}

For GoogleCloudStorageReadSettings, use:

{
  deleteFilesAfterCompletion: any(Azure.Bicep.Types.Concrete.AnyType)
  enablePartitionDiscovery: any(Azure.Bicep.Types.Concrete.AnyType)
  fileListPath: any(Azure.Bicep.Types.Concrete.AnyType)
  modifiedDatetimeEnd: any(Azure.Bicep.Types.Concrete.AnyType)
  modifiedDatetimeStart: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionRootPath: any(Azure.Bicep.Types.Concrete.AnyType)
  prefix: any(Azure.Bicep.Types.Concrete.AnyType)
  recursive: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'GoogleCloudStorageReadSettings'
  wildcardFileName: any(Azure.Bicep.Types.Concrete.AnyType)
  wildcardFolderPath: any(Azure.Bicep.Types.Concrete.AnyType)
}

For HdfsReadSettings, use:

{
  deleteFilesAfterCompletion: any(Azure.Bicep.Types.Concrete.AnyType)
  distcpSettings: {
    distcpOptions: any(Azure.Bicep.Types.Concrete.AnyType)
    resourceManagerEndpoint: any(Azure.Bicep.Types.Concrete.AnyType)
    tempScriptPath: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  enablePartitionDiscovery: any(Azure.Bicep.Types.Concrete.AnyType)
  fileListPath: any(Azure.Bicep.Types.Concrete.AnyType)
  modifiedDatetimeEnd: any(Azure.Bicep.Types.Concrete.AnyType)
  modifiedDatetimeStart: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionRootPath: any(Azure.Bicep.Types.Concrete.AnyType)
  recursive: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'HdfsReadSettings'
  wildcardFileName: any(Azure.Bicep.Types.Concrete.AnyType)
  wildcardFolderPath: any(Azure.Bicep.Types.Concrete.AnyType)
}

For HttpReadSettings, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  additionalHeaders: any(Azure.Bicep.Types.Concrete.AnyType)
  requestBody: any(Azure.Bicep.Types.Concrete.AnyType)
  requestMethod: any(Azure.Bicep.Types.Concrete.AnyType)
  requestTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'HttpReadSettings'
}

For LakeHouseReadSettings, use:

{
  deleteFilesAfterCompletion: any(Azure.Bicep.Types.Concrete.AnyType)
  enablePartitionDiscovery: any(Azure.Bicep.Types.Concrete.AnyType)
  fileListPath: any(Azure.Bicep.Types.Concrete.AnyType)
  modifiedDatetimeEnd: any(Azure.Bicep.Types.Concrete.AnyType)
  modifiedDatetimeStart: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionRootPath: any(Azure.Bicep.Types.Concrete.AnyType)
  recursive: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'LakeHouseReadSettings'
  wildcardFileName: any(Azure.Bicep.Types.Concrete.AnyType)
  wildcardFolderPath: any(Azure.Bicep.Types.Concrete.AnyType)
}

For OracleCloudStorageReadSettings, use:

{
  deleteFilesAfterCompletion: any(Azure.Bicep.Types.Concrete.AnyType)
  enablePartitionDiscovery: any(Azure.Bicep.Types.Concrete.AnyType)
  fileListPath: any(Azure.Bicep.Types.Concrete.AnyType)
  modifiedDatetimeEnd: any(Azure.Bicep.Types.Concrete.AnyType)
  modifiedDatetimeStart: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionRootPath: any(Azure.Bicep.Types.Concrete.AnyType)
  prefix: any(Azure.Bicep.Types.Concrete.AnyType)
  recursive: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'OracleCloudStorageReadSettings'
  wildcardFileName: any(Azure.Bicep.Types.Concrete.AnyType)
  wildcardFolderPath: any(Azure.Bicep.Types.Concrete.AnyType)
}

For SftpReadSettings, use:

{
  deleteFilesAfterCompletion: any(Azure.Bicep.Types.Concrete.AnyType)
  disableChunking: any(Azure.Bicep.Types.Concrete.AnyType)
  enablePartitionDiscovery: any(Azure.Bicep.Types.Concrete.AnyType)
  fileListPath: any(Azure.Bicep.Types.Concrete.AnyType)
  modifiedDatetimeEnd: any(Azure.Bicep.Types.Concrete.AnyType)
  modifiedDatetimeStart: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionRootPath: any(Azure.Bicep.Types.Concrete.AnyType)
  recursive: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SftpReadSettings'
  wildcardFileName: any(Azure.Bicep.Types.Concrete.AnyType)
  wildcardFolderPath: any(Azure.Bicep.Types.Concrete.AnyType)
}

Activity objects

Set the type property to specify the type of object.

For AppendVariable, use:

{
  type: 'AppendVariable'
  typeProperties: {
    value: any(Azure.Bicep.Types.Concrete.AnyType)
    variableName: 'string'
  }
}

For AzureDataExplorerCommand, use:

{
  linkedServiceName: {
    parameters: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    referenceName: 'string'
    type: 'string'
  }
  policy: {
    retry: any(Azure.Bicep.Types.Concrete.AnyType)
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  type: 'AzureDataExplorerCommand'
  typeProperties: {
    command: any(Azure.Bicep.Types.Concrete.AnyType)
    commandTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  }
}

For AzureFunctionActivity, use:

{
  linkedServiceName: {
    parameters: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    referenceName: 'string'
    type: 'string'
  }
  policy: {
    retry: any(Azure.Bicep.Types.Concrete.AnyType)
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  type: 'AzureFunctionActivity'
  typeProperties: {
    body: any(Azure.Bicep.Types.Concrete.AnyType)
    functionName: any(Azure.Bicep.Types.Concrete.AnyType)
    headers: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    method: 'string'
  }
}

For AzureMLBatchExecution, use:

{
  linkedServiceName: {
    parameters: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    referenceName: 'string'
    type: 'string'
  }
  policy: {
    retry: any(Azure.Bicep.Types.Concrete.AnyType)
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  type: 'AzureMLBatchExecution'
  typeProperties: {
    globalParameters: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    webServiceInputs: {
      {customized property}: {
        filePath: any(Azure.Bicep.Types.Concrete.AnyType)
        linkedServiceName: {
          parameters: {
            {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
          }
          referenceName: 'string'
          type: 'string'
        }
      }
    }
    webServiceOutputs: {
      {customized property}: {
        filePath: any(Azure.Bicep.Types.Concrete.AnyType)
        linkedServiceName: {
          parameters: {
            {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
          }
          referenceName: 'string'
          type: 'string'
        }
      }
    }
  }
}

For AzureMLExecutePipeline, use:

{
  linkedServiceName: {
    parameters: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    referenceName: 'string'
    type: 'string'
  }
  policy: {
    retry: any(Azure.Bicep.Types.Concrete.AnyType)
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  type: 'AzureMLExecutePipeline'
  typeProperties: {
    continueOnStepFailure: any(Azure.Bicep.Types.Concrete.AnyType)
    dataPathAssignments: any(Azure.Bicep.Types.Concrete.AnyType)
    experimentName: any(Azure.Bicep.Types.Concrete.AnyType)
    mlParentRunId: any(Azure.Bicep.Types.Concrete.AnyType)
    mlPipelineEndpointId: any(Azure.Bicep.Types.Concrete.AnyType)
    mlPipelineId: any(Azure.Bicep.Types.Concrete.AnyType)
    mlPipelineParameters: any(Azure.Bicep.Types.Concrete.AnyType)
    version: any(Azure.Bicep.Types.Concrete.AnyType)
  }
}

For AzureMLUpdateResource, use:

{
  linkedServiceName: {
    parameters: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    referenceName: 'string'
    type: 'string'
  }
  policy: {
    retry: any(Azure.Bicep.Types.Concrete.AnyType)
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  type: 'AzureMLUpdateResource'
  typeProperties: {
    trainedModelFilePath: any(Azure.Bicep.Types.Concrete.AnyType)
    trainedModelLinkedServiceName: {
      parameters: {
        {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
      }
      referenceName: 'string'
      type: 'string'
    }
    trainedModelName: any(Azure.Bicep.Types.Concrete.AnyType)
  }
}

For ExecutePipeline, use:

{
  policy: {
    secureInput: bool
  }
  type: 'ExecutePipeline'
  typeProperties: {
    parameters: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    pipeline: {
      name: 'string'
      referenceName: 'string'
      type: 'string'
    }
    waitOnCompletion: bool
  }
}

For Fail, use:

{
  type: 'Fail'
  typeProperties: {
    errorCode: any(Azure.Bicep.Types.Concrete.AnyType)
    message: any(Azure.Bicep.Types.Concrete.AnyType)
  }
}

For Filter, use:

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

For ForEach, use:

{
  type: 'ForEach'
  typeProperties: {
    activities: [
      {
        dependsOn: [
          {
            activity: 'string'
            dependencyConditions: [
              'string'
            ]
          }
        ]
        description: 'string'
        name: 'string'
        onInactiveMarkAs: 'string'
        state: 'string'
        userProperties: [
          {
            name: 'string'
            value: any(Azure.Bicep.Types.Concrete.AnyType)
          }
        ]
        type: 'string'
        // For remaining properties, see Activity objects
      }
    ]
    batchCount: int
    isSequential: bool
    items: {
      type: 'string'
      value: 'string'
    }
  }
}

For IfCondition, use:

{
  type: 'IfCondition'
  typeProperties: {
    expression: {
      type: 'string'
      value: 'string'
    }
    ifFalseActivities: [
      {
        dependsOn: [
          {
            activity: 'string'
            dependencyConditions: [
              'string'
            ]
          }
        ]
        description: 'string'
        name: 'string'
        onInactiveMarkAs: 'string'
        state: 'string'
        userProperties: [
          {
            name: 'string'
            value: any(Azure.Bicep.Types.Concrete.AnyType)
          }
        ]
        type: 'string'
        // For remaining properties, see Activity objects
      }
    ]
    ifTrueActivities: [
      {
        dependsOn: [
          {
            activity: 'string'
            dependencyConditions: [
              'string'
            ]
          }
        ]
        description: 'string'
        name: 'string'
        onInactiveMarkAs: 'string'
        state: 'string'
        userProperties: [
          {
            name: 'string'
            value: any(Azure.Bicep.Types.Concrete.AnyType)
          }
        ]
        type: 'string'
        // For remaining properties, see Activity objects
      }
    ]
  }
}

For SetVariable, use:

{
  policy: {
    secureInput: bool
    secureOutput: bool
  }
  type: 'SetVariable'
  typeProperties: {
    setSystemVariable: bool
    value: any(Azure.Bicep.Types.Concrete.AnyType)
    variableName: 'string'
  }
}

For Switch, use:

{
  type: 'Switch'
  typeProperties: {
    cases: [
      {
        activities: [
          {
            dependsOn: [
              {
                activity: 'string'
                dependencyConditions: [
                  'string'
                ]
              }
            ]
            description: 'string'
            name: 'string'
            onInactiveMarkAs: 'string'
            state: 'string'
            userProperties: [
              {
                name: 'string'
                value: any(Azure.Bicep.Types.Concrete.AnyType)
              }
            ]
            type: 'string'
            // For remaining properties, see Activity objects
          }
        ]
        value: 'string'
      }
    ]
    defaultActivities: [
      {
        dependsOn: [
          {
            activity: 'string'
            dependencyConditions: [
              'string'
            ]
          }
        ]
        description: 'string'
        name: 'string'
        onInactiveMarkAs: 'string'
        state: 'string'
        userProperties: [
          {
            name: 'string'
            value: any(Azure.Bicep.Types.Concrete.AnyType)
          }
        ]
        type: 'string'
        // For remaining properties, see Activity objects
      }
    ]
    on: {
      type: 'string'
      value: 'string'
    }
  }
}

For Until, use:

{
  type: 'Until'
  typeProperties: {
    activities: [
      {
        dependsOn: [
          {
            activity: 'string'
            dependencyConditions: [
              'string'
            ]
          }
        ]
        description: 'string'
        name: 'string'
        onInactiveMarkAs: 'string'
        state: 'string'
        userProperties: [
          {
            name: 'string'
            value: any(Azure.Bicep.Types.Concrete.AnyType)
          }
        ]
        type: 'string'
        // For remaining properties, see Activity objects
      }
    ]
    expression: {
      type: 'string'
      value: 'string'
    }
    timeout: any(Azure.Bicep.Types.Concrete.AnyType)
  }
}

For Validation, use:

{
  type: 'Validation'
  typeProperties: {
    childItems: any(Azure.Bicep.Types.Concrete.AnyType)
    dataset: {
      parameters: {
        {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
      }
      referenceName: 'string'
      type: 'string'
    }
    minimumSize: any(Azure.Bicep.Types.Concrete.AnyType)
    sleep: any(Azure.Bicep.Types.Concrete.AnyType)
    timeout: any(Azure.Bicep.Types.Concrete.AnyType)
  }
}

For Wait, use:

{
  type: 'Wait'
  typeProperties: {
    waitTimeInSeconds: any(Azure.Bicep.Types.Concrete.AnyType)
  }
}

For WebHook, use:

{
  policy: {
    secureInput: bool
    secureOutput: bool
  }
  type: 'WebHook'
  typeProperties: {
    authentication: {
      credential: {
        referenceName: 'string'
        type: 'string'
      }
      password: {
        type: 'string'
        // For remaining properties, see SecretBase objects
      }
      pfx: {
        type: 'string'
        // For remaining properties, see SecretBase objects
      }
      resource: any(Azure.Bicep.Types.Concrete.AnyType)
      type: 'string'
      username: any(Azure.Bicep.Types.Concrete.AnyType)
      userTenant: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    body: any(Azure.Bicep.Types.Concrete.AnyType)
    headers: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    method: 'string'
    reportStatusOnCallBack: any(Azure.Bicep.Types.Concrete.AnyType)
    timeout: 'string'
    url: any(Azure.Bicep.Types.Concrete.AnyType)
  }
}

For Copy, use:

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

For Custom, use:

{
  linkedServiceName: {
    parameters: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    referenceName: 'string'
    type: 'string'
  }
  policy: {
    retry: any(Azure.Bicep.Types.Concrete.AnyType)
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  type: 'Custom'
  typeProperties: {
    autoUserSpecification: any(Azure.Bicep.Types.Concrete.AnyType)
    command: any(Azure.Bicep.Types.Concrete.AnyType)
    extendedProperties: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    folderPath: any(Azure.Bicep.Types.Concrete.AnyType)
    referenceObjects: {
      datasets: [
        {
          parameters: {
            {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
          }
          referenceName: 'string'
          type: 'string'
        }
      ]
      linkedServices: [
        {
          parameters: {
            {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
          }
          referenceName: 'string'
          type: 'string'
        }
      ]
    }
    resourceLinkedService: {
      parameters: {
        {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
      }
      referenceName: 'string'
      type: 'string'
    }
    retentionTimeInDays: any(Azure.Bicep.Types.Concrete.AnyType)
  }
}

For DataLakeAnalyticsU-SQL, use:

{
  linkedServiceName: {
    parameters: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    referenceName: 'string'
    type: 'string'
  }
  policy: {
    retry: any(Azure.Bicep.Types.Concrete.AnyType)
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  type: 'DataLakeAnalyticsU-SQL'
  typeProperties: {
    compilationMode: any(Azure.Bicep.Types.Concrete.AnyType)
    degreeOfParallelism: any(Azure.Bicep.Types.Concrete.AnyType)
    parameters: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    priority: any(Azure.Bicep.Types.Concrete.AnyType)
    runtimeVersion: any(Azure.Bicep.Types.Concrete.AnyType)
    scriptLinkedService: {
      parameters: {
        {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
      }
      referenceName: 'string'
      type: 'string'
    }
    scriptPath: any(Azure.Bicep.Types.Concrete.AnyType)
  }
}

For DatabricksNotebook, use:

{
  linkedServiceName: {
    parameters: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    referenceName: 'string'
    type: 'string'
  }
  policy: {
    retry: any(Azure.Bicep.Types.Concrete.AnyType)
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  type: 'DatabricksNotebook'
  typeProperties: {
    baseParameters: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    libraries: [
      {
        {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
      }
    ]
    notebookPath: any(Azure.Bicep.Types.Concrete.AnyType)
  }
}

For DatabricksSparkJar, use:

{
  linkedServiceName: {
    parameters: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    referenceName: 'string'
    type: 'string'
  }
  policy: {
    retry: any(Azure.Bicep.Types.Concrete.AnyType)
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  type: 'DatabricksSparkJar'
  typeProperties: {
    libraries: [
      {
        {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
      }
    ]
    mainClassName: any(Azure.Bicep.Types.Concrete.AnyType)
    parameters: [
      any(Azure.Bicep.Types.Concrete.AnyType)
    ]
  }
}

For DatabricksSparkPython, use:

{
  linkedServiceName: {
    parameters: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    referenceName: 'string'
    type: 'string'
  }
  policy: {
    retry: any(Azure.Bicep.Types.Concrete.AnyType)
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  type: 'DatabricksSparkPython'
  typeProperties: {
    libraries: [
      {
        {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
      }
    ]
    parameters: [
      any(Azure.Bicep.Types.Concrete.AnyType)
    ]
    pythonFile: any(Azure.Bicep.Types.Concrete.AnyType)
  }
}

For Delete, use:

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

For ExecuteDataFlow, use:

{
  linkedServiceName: {
    parameters: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    referenceName: 'string'
    type: 'string'
  }
  policy: {
    retry: any(Azure.Bicep.Types.Concrete.AnyType)
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  type: 'ExecuteDataFlow'
  typeProperties: {
    compute: {
      computeType: any(Azure.Bicep.Types.Concrete.AnyType)
      coreCount: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    continuationSettings: {
      continuationTtlInMinutes: any(Azure.Bicep.Types.Concrete.AnyType)
      customizedCheckpointKey: any(Azure.Bicep.Types.Concrete.AnyType)
      idleCondition: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    continueOnError: any(Azure.Bicep.Types.Concrete.AnyType)
    dataFlow: {
      datasetParameters: any(Azure.Bicep.Types.Concrete.AnyType)
      parameters: {
        {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
      }
      referenceName: 'string'
      type: 'string'
    }
    integrationRuntime: {
      parameters: {
        {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
      }
      referenceName: 'string'
      type: 'string'
    }
    runConcurrently: any(Azure.Bicep.Types.Concrete.AnyType)
    sourceStagingConcurrency: any(Azure.Bicep.Types.Concrete.AnyType)
    staging: {
      folderPath: any(Azure.Bicep.Types.Concrete.AnyType)
      linkedService: {
        parameters: {
          {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
        }
        referenceName: 'string'
        type: 'string'
      }
    }
    traceLevel: any(Azure.Bicep.Types.Concrete.AnyType)
  }
}

For ExecuteSSISPackage, use:

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

For ExecuteWranglingDataflow, use:

{
  policy: {
    retry: any(Azure.Bicep.Types.Concrete.AnyType)
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  type: 'ExecuteWranglingDataflow'
  typeProperties: {
    compute: {
      computeType: any(Azure.Bicep.Types.Concrete.AnyType)
      coreCount: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    continuationSettings: {
      continuationTtlInMinutes: any(Azure.Bicep.Types.Concrete.AnyType)
      customizedCheckpointKey: any(Azure.Bicep.Types.Concrete.AnyType)
      idleCondition: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    continueOnError: any(Azure.Bicep.Types.Concrete.AnyType)
    dataFlow: {
      datasetParameters: any(Azure.Bicep.Types.Concrete.AnyType)
      parameters: {
        {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
      }
      referenceName: 'string'
      type: 'string'
    }
    integrationRuntime: {
      parameters: {
        {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
      }
      referenceName: 'string'
      type: 'string'
    }
    queries: [
      {
        dataflowSinks: [
          {
            dataset: {
              parameters: {
                {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
              }
              referenceName: 'string'
              type: 'string'
            }
            description: 'string'
            flowlet: {
              datasetParameters: any(Azure.Bicep.Types.Concrete.AnyType)
              parameters: {
                {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
              }
              referenceName: 'string'
              type: 'string'
            }
            linkedService: {
              parameters: {
                {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
              }
              referenceName: 'string'
              type: 'string'
            }
            name: 'string'
            rejectedDataLinkedService: {
              parameters: {
                {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
              }
              referenceName: 'string'
              type: 'string'
            }
            schemaLinkedService: {
              parameters: {
                {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
              }
              referenceName: 'string'
              type: 'string'
            }
            script: 'string'
          }
        ]
        queryName: 'string'
      }
    ]
    runConcurrently: any(Azure.Bicep.Types.Concrete.AnyType)
    sinks: {
      {customized property}: {
        dataset: {
          parameters: {
            {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
          }
          referenceName: 'string'
          type: 'string'
        }
        description: 'string'
        flowlet: {
          datasetParameters: any(Azure.Bicep.Types.Concrete.AnyType)
          parameters: {
            {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
          }
          referenceName: 'string'
          type: 'string'
        }
        linkedService: {
          parameters: {
            {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
          }
          referenceName: 'string'
          type: 'string'
        }
        name: 'string'
        rejectedDataLinkedService: {
          parameters: {
            {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
          }
          referenceName: 'string'
          type: 'string'
        }
        schemaLinkedService: {
          parameters: {
            {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
          }
          referenceName: 'string'
          type: 'string'
        }
        script: 'string'
      }
    }
    sourceStagingConcurrency: any(Azure.Bicep.Types.Concrete.AnyType)
    staging: {
      folderPath: any(Azure.Bicep.Types.Concrete.AnyType)
      linkedService: {
        parameters: {
          {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
        }
        referenceName: 'string'
        type: 'string'
      }
    }
    traceLevel: any(Azure.Bicep.Types.Concrete.AnyType)
  }
}

For GetMetadata, use:

{
  linkedServiceName: {
    parameters: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    referenceName: 'string'
    type: 'string'
  }
  policy: {
    retry: any(Azure.Bicep.Types.Concrete.AnyType)
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  type: 'GetMetadata'
  typeProperties: {
    dataset: {
      parameters: {
        {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
      }
      referenceName: 'string'
      type: 'string'
    }
    fieldList: [
      any(Azure.Bicep.Types.Concrete.AnyType)
    ]
    formatSettings: {
      type: 'string'
      // For remaining properties, see FormatReadSettings objects
    }
    storeSettings: {
      disableMetricsCollection: any(Azure.Bicep.Types.Concrete.AnyType)
      maxConcurrentConnections: any(Azure.Bicep.Types.Concrete.AnyType)
      type: 'string'
      // For remaining properties, see StoreReadSettings objects
    }
  }
}

For HDInsightHive, use:

{
  linkedServiceName: {
    parameters: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    referenceName: 'string'
    type: 'string'
  }
  policy: {
    retry: any(Azure.Bicep.Types.Concrete.AnyType)
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  type: 'HDInsightHive'
  typeProperties: {
    arguments: [
      any(Azure.Bicep.Types.Concrete.AnyType)
    ]
    defines: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    getDebugInfo: 'string'
    queryTimeout: int
    scriptLinkedService: {
      parameters: {
        {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
      }
      referenceName: 'string'
      type: 'string'
    }
    scriptPath: any(Azure.Bicep.Types.Concrete.AnyType)
    storageLinkedServices: [
      {
        parameters: {
          {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
        }
        referenceName: 'string'
        type: 'string'
      }
    ]
    variables: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
  }
}

For HDInsightMapReduce, use:

{
  linkedServiceName: {
    parameters: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    referenceName: 'string'
    type: 'string'
  }
  policy: {
    retry: any(Azure.Bicep.Types.Concrete.AnyType)
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  type: 'HDInsightMapReduce'
  typeProperties: {
    arguments: [
      any(Azure.Bicep.Types.Concrete.AnyType)
    ]
    className: any(Azure.Bicep.Types.Concrete.AnyType)
    defines: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    getDebugInfo: 'string'
    jarFilePath: any(Azure.Bicep.Types.Concrete.AnyType)
    jarLibs: [
      any(Azure.Bicep.Types.Concrete.AnyType)
    ]
    jarLinkedService: {
      parameters: {
        {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
      }
      referenceName: 'string'
      type: 'string'
    }
    storageLinkedServices: [
      {
        parameters: {
          {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
        }
        referenceName: 'string'
        type: 'string'
      }
    ]
  }
}

For HDInsightPig, use:

{
  linkedServiceName: {
    parameters: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    referenceName: 'string'
    type: 'string'
  }
  policy: {
    retry: any(Azure.Bicep.Types.Concrete.AnyType)
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  type: 'HDInsightPig'
  typeProperties: {
    arguments: any(Azure.Bicep.Types.Concrete.AnyType)
    defines: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    getDebugInfo: 'string'
    scriptLinkedService: {
      parameters: {
        {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
      }
      referenceName: 'string'
      type: 'string'
    }
    scriptPath: any(Azure.Bicep.Types.Concrete.AnyType)
    storageLinkedServices: [
      {
        parameters: {
          {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
        }
        referenceName: 'string'
        type: 'string'
      }
    ]
  }
}

For HDInsightSpark, use:

{
  linkedServiceName: {
    parameters: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    referenceName: 'string'
    type: 'string'
  }
  policy: {
    retry: any(Azure.Bicep.Types.Concrete.AnyType)
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  type: 'HDInsightSpark'
  typeProperties: {
    arguments: [
      any(Azure.Bicep.Types.Concrete.AnyType)
    ]
    className: 'string'
    entryFilePath: any(Azure.Bicep.Types.Concrete.AnyType)
    getDebugInfo: 'string'
    proxyUser: any(Azure.Bicep.Types.Concrete.AnyType)
    rootPath: any(Azure.Bicep.Types.Concrete.AnyType)
    sparkConfig: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    sparkJobLinkedService: {
      parameters: {
        {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
      }
      referenceName: 'string'
      type: 'string'
    }
  }
}

For HDInsightStreaming, use:

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

For Lookup, use:

{
  linkedServiceName: {
    parameters: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    referenceName: 'string'
    type: 'string'
  }
  policy: {
    retry: any(Azure.Bicep.Types.Concrete.AnyType)
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  type: 'Lookup'
  typeProperties: {
    dataset: {
      parameters: {
        {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
      }
      referenceName: 'string'
      type: 'string'
    }
    firstRowOnly: any(Azure.Bicep.Types.Concrete.AnyType)
    source: {
      disableMetricsCollection: any(Azure.Bicep.Types.Concrete.AnyType)
      maxConcurrentConnections: any(Azure.Bicep.Types.Concrete.AnyType)
      sourceRetryCount: any(Azure.Bicep.Types.Concrete.AnyType)
      sourceRetryWait: any(Azure.Bicep.Types.Concrete.AnyType)
      type: 'string'
      // For remaining properties, see CopySource objects
    }
  }
}

For Script, use:

{
  linkedServiceName: {
    parameters: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    referenceName: 'string'
    type: 'string'
  }
  policy: {
    retry: any(Azure.Bicep.Types.Concrete.AnyType)
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  type: 'Script'
  typeProperties: {
    logSettings: {
      logDestination: 'string'
      logLocationSettings: {
        linkedServiceName: {
          parameters: {
            {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
          }
          referenceName: 'string'
          type: 'string'
        }
        path: any(Azure.Bicep.Types.Concrete.AnyType)
      }
    }
    scriptBlockExecutionTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
    scripts: [
      {
        parameters: [
          {
            direction: 'string'
            name: any(Azure.Bicep.Types.Concrete.AnyType)
            size: int
            type: 'string'
            value: any(Azure.Bicep.Types.Concrete.AnyType)
          }
        ]
        text: any(Azure.Bicep.Types.Concrete.AnyType)
        type: any(Azure.Bicep.Types.Concrete.AnyType)
      }
    ]
  }
}

For SparkJob, use:

{
  linkedServiceName: {
    parameters: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    referenceName: 'string'
    type: 'string'
  }
  policy: {
    retry: any(Azure.Bicep.Types.Concrete.AnyType)
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  type: 'SparkJob'
  typeProperties: {
    args: [
      any(Azure.Bicep.Types.Concrete.AnyType)
    ]
    className: any(Azure.Bicep.Types.Concrete.AnyType)
    conf: any(Azure.Bicep.Types.Concrete.AnyType)
    configurationType: 'string'
    driverSize: any(Azure.Bicep.Types.Concrete.AnyType)
    executorSize: any(Azure.Bicep.Types.Concrete.AnyType)
    file: any(Azure.Bicep.Types.Concrete.AnyType)
    files: [
      any(Azure.Bicep.Types.Concrete.AnyType)
    ]
    filesV2: [
      any(Azure.Bicep.Types.Concrete.AnyType)
    ]
    numExecutors: any(Azure.Bicep.Types.Concrete.AnyType)
    pythonCodeReference: [
      any(Azure.Bicep.Types.Concrete.AnyType)
    ]
    scanFolder: any(Azure.Bicep.Types.Concrete.AnyType)
    sparkConfig: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    sparkJob: {
      referenceName: any(Azure.Bicep.Types.Concrete.AnyType)
      type: 'string'
    }
    targetBigDataPool: {
      referenceName: any(Azure.Bicep.Types.Concrete.AnyType)
      type: 'string'
    }
    targetSparkConfiguration: {
      referenceName: any(Azure.Bicep.Types.Concrete.AnyType)
      type: 'string'
    }
  }
}

For SqlServerStoredProcedure, use:

{
  linkedServiceName: {
    parameters: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    referenceName: 'string'
    type: 'string'
  }
  policy: {
    retry: any(Azure.Bicep.Types.Concrete.AnyType)
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  type: 'SqlServerStoredProcedure'
  typeProperties: {
    storedProcedureName: any(Azure.Bicep.Types.Concrete.AnyType)
    storedProcedureParameters: any(Azure.Bicep.Types.Concrete.AnyType)
  }
}

For SynapseNotebook, use:

{
  linkedServiceName: {
    parameters: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    referenceName: 'string'
    type: 'string'
  }
  policy: {
    retry: any(Azure.Bicep.Types.Concrete.AnyType)
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  type: 'SynapseNotebook'
  typeProperties: {
    conf: any(Azure.Bicep.Types.Concrete.AnyType)
    configurationType: 'string'
    driverSize: any(Azure.Bicep.Types.Concrete.AnyType)
    executorSize: any(Azure.Bicep.Types.Concrete.AnyType)
    notebook: {
      referenceName: any(Azure.Bicep.Types.Concrete.AnyType)
      type: 'string'
    }
    numExecutors: any(Azure.Bicep.Types.Concrete.AnyType)
    parameters: {
      {customized property}: {
        type: 'string'
        value: any(Azure.Bicep.Types.Concrete.AnyType)
      }
    }
    sparkConfig: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    sparkPool: {
      referenceName: any(Azure.Bicep.Types.Concrete.AnyType)
      type: 'string'
    }
    targetSparkConfiguration: {
      referenceName: any(Azure.Bicep.Types.Concrete.AnyType)
      type: 'string'
    }
  }
}

For WebActivity, use:

{
  linkedServiceName: {
    parameters: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    referenceName: 'string'
    type: 'string'
  }
  policy: {
    retry: any(Azure.Bicep.Types.Concrete.AnyType)
    retryIntervalInSeconds: int
    secureInput: bool
    secureOutput: bool
    timeout: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  type: 'WebActivity'
  typeProperties: {
    authentication: {
      credential: {
        referenceName: 'string'
        type: 'string'
      }
      password: {
        type: 'string'
        // For remaining properties, see SecretBase objects
      }
      pfx: {
        type: 'string'
        // For remaining properties, see SecretBase objects
      }
      resource: any(Azure.Bicep.Types.Concrete.AnyType)
      type: 'string'
      username: any(Azure.Bicep.Types.Concrete.AnyType)
      userTenant: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    body: any(Azure.Bicep.Types.Concrete.AnyType)
    connectVia: {
      parameters: {
        {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
      }
      referenceName: 'string'
      type: 'string'
    }
    datasets: [
      {
        parameters: {
          {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
        }
        referenceName: 'string'
        type: 'string'
      }
    ]
    disableCertValidation: bool
    headers: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    httpRequestTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
    linkedServices: [
      {
        parameters: {
          {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
        }
        referenceName: 'string'
        type: 'string'
      }
    ]
    method: 'string'
    turnOffAsync: bool
    url: any(Azure.Bicep.Types.Concrete.AnyType)
  }
}

CompressionReadSettings objects

Set the type property to specify the type of object.

For TarGZipReadSettings, use:

{
  preserveCompressionFileNameAsFolder: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'TarGZipReadSettings'
}

For TarReadSettings, use:

{
  preserveCompressionFileNameAsFolder: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'TarReadSettings'
}

For ZipDeflateReadSettings, use:

{
  preserveZipFileNameAsFolder: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'ZipDeflateReadSettings'
}

StoreWriteSettings objects

Set the type property to specify the type of object.

For AzureBlobFSWriteSettings, use:

{
  blockSizeInMB: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'AzureBlobFSWriteSettings'
}

For AzureBlobStorageWriteSettings, use:

{
  blockSizeInMB: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'AzureBlobStorageWriteSettings'
}

For AzureDataLakeStoreWriteSettings, use:

{
  expiryDateTime: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'AzureDataLakeStoreWriteSettings'
}

For AzureFileStorageWriteSettings, use:

{
  type: 'AzureFileStorageWriteSettings'
}

For FileServerWriteSettings, use:

{
  type: 'FileServerWriteSettings'
}

For LakeHouseWriteSettings, use:

{
  type: 'LakeHouseWriteSettings'
}

For SftpWriteSettings, use:

{
  operationTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SftpWriteSettings'
  useTempFileRename: any(Azure.Bicep.Types.Concrete.AnyType)
}

CopySink objects

Set the type property to specify the type of object.

For AvroSink, use:

{
  formatSettings: {
    fileNamePrefix: any(Azure.Bicep.Types.Concrete.AnyType)
    maxRowsPerFile: any(Azure.Bicep.Types.Concrete.AnyType)
    recordName: 'string'
    recordNamespace: 'string'
    type: 'string'
  }
  storeSettings: {
    copyBehavior: any(Azure.Bicep.Types.Concrete.AnyType)
    disableMetricsCollection: any(Azure.Bicep.Types.Concrete.AnyType)
    maxConcurrentConnections: any(Azure.Bicep.Types.Concrete.AnyType)
    metadata: [
      {
        name: any(Azure.Bicep.Types.Concrete.AnyType)
        value: any(Azure.Bicep.Types.Concrete.AnyType)
      }
    ]
    type: 'string'
    // For remaining properties, see StoreWriteSettings objects
  }
  type: 'AvroSink'
}

For AzureBlobFSSink, use:

{
  copyBehavior: any(Azure.Bicep.Types.Concrete.AnyType)
  metadata: [
    {
      name: any(Azure.Bicep.Types.Concrete.AnyType)
      value: any(Azure.Bicep.Types.Concrete.AnyType)
    }
  ]
  type: 'AzureBlobFSSink'
}

For AzureDataExplorerSink, use:

{
  flushImmediately: any(Azure.Bicep.Types.Concrete.AnyType)
  ingestionMappingAsJson: any(Azure.Bicep.Types.Concrete.AnyType)
  ingestionMappingName: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'AzureDataExplorerSink'
}

For AzureDataLakeStoreSink, use:

{
  copyBehavior: any(Azure.Bicep.Types.Concrete.AnyType)
  enableAdlsSingleFileParallel: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'AzureDataLakeStoreSink'
}

For AzureDatabricksDeltaLakeSink, use:

{
  importSettings: {
    dateFormat: any(Azure.Bicep.Types.Concrete.AnyType)
    timestampFormat: any(Azure.Bicep.Types.Concrete.AnyType)
    type: 'string'
  }
  preCopyScript: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'AzureDatabricksDeltaLakeSink'
}

For AzureMySqlSink, use:

{
  preCopyScript: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'AzureMySqlSink'
}

For AzurePostgreSqlSink, use:

{
  preCopyScript: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'AzurePostgreSqlSink'
}

For AzureQueueSink, use:

{
  type: 'AzureQueueSink'
}

For AzureSearchIndexSink, use:

{
  type: 'AzureSearchIndexSink'
  writeBehavior: 'string'
}

For AzureSqlSink, use:

{
  preCopyScript: any(Azure.Bicep.Types.Concrete.AnyType)
  sqlWriterStoredProcedureName: any(Azure.Bicep.Types.Concrete.AnyType)
  sqlWriterTableType: any(Azure.Bicep.Types.Concrete.AnyType)
  sqlWriterUseTableLock: any(Azure.Bicep.Types.Concrete.AnyType)
  storedProcedureParameters: any(Azure.Bicep.Types.Concrete.AnyType)
  storedProcedureTableTypeParameterName: any(Azure.Bicep.Types.Concrete.AnyType)
  tableOption: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'AzureSqlSink'
  upsertSettings: {
    interimSchemaName: any(Azure.Bicep.Types.Concrete.AnyType)
    keys: any(Azure.Bicep.Types.Concrete.AnyType)
    useTempDB: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  writeBehavior: any(Azure.Bicep.Types.Concrete.AnyType)
}

For AzureTableSink, use:

{
  azureTableDefaultPartitionKeyValue: any(Azure.Bicep.Types.Concrete.AnyType)
  azureTableInsertType: any(Azure.Bicep.Types.Concrete.AnyType)
  azureTablePartitionKeyName: any(Azure.Bicep.Types.Concrete.AnyType)
  azureTableRowKeyName: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'AzureTableSink'
}

For BinarySink, use:

{
  storeSettings: {
    copyBehavior: any(Azure.Bicep.Types.Concrete.AnyType)
    disableMetricsCollection: any(Azure.Bicep.Types.Concrete.AnyType)
    maxConcurrentConnections: any(Azure.Bicep.Types.Concrete.AnyType)
    metadata: [
      {
        name: any(Azure.Bicep.Types.Concrete.AnyType)
        value: any(Azure.Bicep.Types.Concrete.AnyType)
      }
    ]
    type: 'string'
    // For remaining properties, see StoreWriteSettings objects
  }
  type: 'BinarySink'
}

For BlobSink, use:

{
  blobWriterAddHeader: any(Azure.Bicep.Types.Concrete.AnyType)
  blobWriterDateTimeFormat: any(Azure.Bicep.Types.Concrete.AnyType)
  blobWriterOverwriteFiles: any(Azure.Bicep.Types.Concrete.AnyType)
  copyBehavior: any(Azure.Bicep.Types.Concrete.AnyType)
  metadata: [
    {
      name: any(Azure.Bicep.Types.Concrete.AnyType)
      value: any(Azure.Bicep.Types.Concrete.AnyType)
    }
  ]
  type: 'BlobSink'
}

For CommonDataServiceForAppsSink, use:

{
  alternateKeyName: any(Azure.Bicep.Types.Concrete.AnyType)
  ignoreNullValues: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'CommonDataServiceForAppsSink'
  writeBehavior: 'string'
}

For CosmosDbMongoDbApiSink, use:

{
  type: 'CosmosDbMongoDbApiSink'
  writeBehavior: any(Azure.Bicep.Types.Concrete.AnyType)
}

For CosmosDbSqlApiSink, use:

{
  type: 'CosmosDbSqlApiSink'
  writeBehavior: any(Azure.Bicep.Types.Concrete.AnyType)
}

For DelimitedTextSink, use:

{
  formatSettings: {
    fileExtension: any(Azure.Bicep.Types.Concrete.AnyType)
    fileNamePrefix: any(Azure.Bicep.Types.Concrete.AnyType)
    maxRowsPerFile: any(Azure.Bicep.Types.Concrete.AnyType)
    quoteAllText: any(Azure.Bicep.Types.Concrete.AnyType)
    type: 'string'
  }
  storeSettings: {
    copyBehavior: any(Azure.Bicep.Types.Concrete.AnyType)
    disableMetricsCollection: any(Azure.Bicep.Types.Concrete.AnyType)
    maxConcurrentConnections: any(Azure.Bicep.Types.Concrete.AnyType)
    metadata: [
      {
        name: any(Azure.Bicep.Types.Concrete.AnyType)
        value: any(Azure.Bicep.Types.Concrete.AnyType)
      }
    ]
    type: 'string'
    // For remaining properties, see StoreWriteSettings objects
  }
  type: 'DelimitedTextSink'
}

For DocumentDbCollectionSink, use:

{
  nestingSeparator: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'DocumentDbCollectionSink'
  writeBehavior: any(Azure.Bicep.Types.Concrete.AnyType)
}

For DynamicsCrmSink, use:

{
  alternateKeyName: any(Azure.Bicep.Types.Concrete.AnyType)
  ignoreNullValues: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'DynamicsCrmSink'
  writeBehavior: 'string'
}

For DynamicsSink, use:

{
  alternateKeyName: any(Azure.Bicep.Types.Concrete.AnyType)
  ignoreNullValues: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'DynamicsSink'
  writeBehavior: 'string'
}

For FileSystemSink, use:

{
  copyBehavior: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'FileSystemSink'
}

For IcebergSink, use:

{
  formatSettings: {
    type: 'string'
  }
  storeSettings: {
    copyBehavior: any(Azure.Bicep.Types.Concrete.AnyType)
    disableMetricsCollection: any(Azure.Bicep.Types.Concrete.AnyType)
    maxConcurrentConnections: any(Azure.Bicep.Types.Concrete.AnyType)
    metadata: [
      {
        name: any(Azure.Bicep.Types.Concrete.AnyType)
        value: any(Azure.Bicep.Types.Concrete.AnyType)
      }
    ]
    type: 'string'
    // For remaining properties, see StoreWriteSettings objects
  }
  type: 'IcebergSink'
}

For InformixSink, use:

{
  preCopyScript: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'InformixSink'
}

For JsonSink, use:

{
  formatSettings: {
    filePattern: any(Azure.Bicep.Types.Concrete.AnyType)
    type: 'string'
  }
  storeSettings: {
    copyBehavior: any(Azure.Bicep.Types.Concrete.AnyType)
    disableMetricsCollection: any(Azure.Bicep.Types.Concrete.AnyType)
    maxConcurrentConnections: any(Azure.Bicep.Types.Concrete.AnyType)
    metadata: [
      {
        name: any(Azure.Bicep.Types.Concrete.AnyType)
        value: any(Azure.Bicep.Types.Concrete.AnyType)
      }
    ]
    type: 'string'
    // For remaining properties, see StoreWriteSettings objects
  }
  type: 'JsonSink'
}

For LakeHouseTableSink, use:

{
  partitionNameList: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionOption: any(Azure.Bicep.Types.Concrete.AnyType)
  tableActionOption: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'LakeHouseTableSink'
}

For MicrosoftAccessSink, use:

{
  preCopyScript: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'MicrosoftAccessSink'
}

For MongoDbAtlasSink, use:

{
  type: 'MongoDbAtlasSink'
  writeBehavior: any(Azure.Bicep.Types.Concrete.AnyType)
}

For MongoDbV2Sink, use:

{
  type: 'MongoDbV2Sink'
  writeBehavior: any(Azure.Bicep.Types.Concrete.AnyType)
}

For OdbcSink, use:

{
  preCopyScript: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'OdbcSink'
}

For OracleSink, use:

{
  preCopyScript: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'OracleSink'
}

For OrcSink, use:

{
  formatSettings: {
    fileNamePrefix: any(Azure.Bicep.Types.Concrete.AnyType)
    maxRowsPerFile: any(Azure.Bicep.Types.Concrete.AnyType)
    type: 'string'
  }
  storeSettings: {
    copyBehavior: any(Azure.Bicep.Types.Concrete.AnyType)
    disableMetricsCollection: any(Azure.Bicep.Types.Concrete.AnyType)
    maxConcurrentConnections: any(Azure.Bicep.Types.Concrete.AnyType)
    metadata: [
      {
        name: any(Azure.Bicep.Types.Concrete.AnyType)
        value: any(Azure.Bicep.Types.Concrete.AnyType)
      }
    ]
    type: 'string'
    // For remaining properties, see StoreWriteSettings objects
  }
  type: 'OrcSink'
}

For ParquetSink, use:

{
  formatSettings: {
    fileNamePrefix: any(Azure.Bicep.Types.Concrete.AnyType)
    maxRowsPerFile: any(Azure.Bicep.Types.Concrete.AnyType)
    type: 'string'
  }
  storeSettings: {
    copyBehavior: any(Azure.Bicep.Types.Concrete.AnyType)
    disableMetricsCollection: any(Azure.Bicep.Types.Concrete.AnyType)
    maxConcurrentConnections: any(Azure.Bicep.Types.Concrete.AnyType)
    metadata: [
      {
        name: any(Azure.Bicep.Types.Concrete.AnyType)
        value: any(Azure.Bicep.Types.Concrete.AnyType)
      }
    ]
    type: 'string'
    // For remaining properties, see StoreWriteSettings objects
  }
  type: 'ParquetSink'
}

For RestSink, use:

{
  additionalHeaders: any(Azure.Bicep.Types.Concrete.AnyType)
  httpCompressionType: any(Azure.Bicep.Types.Concrete.AnyType)
  httpRequestTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  requestInterval: any(Azure.Bicep.Types.Concrete.AnyType)
  requestMethod: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'RestSink'
}

For SalesforceServiceCloudSink, use:

{
  externalIdFieldName: any(Azure.Bicep.Types.Concrete.AnyType)
  ignoreNullValues: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SalesforceServiceCloudSink'
  writeBehavior: 'string'
}

For SalesforceServiceCloudV2Sink, use:

{
  externalIdFieldName: any(Azure.Bicep.Types.Concrete.AnyType)
  ignoreNullValues: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SalesforceServiceCloudV2Sink'
  writeBehavior: 'string'
}

For SalesforceSink, use:

{
  externalIdFieldName: any(Azure.Bicep.Types.Concrete.AnyType)
  ignoreNullValues: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SalesforceSink'
  writeBehavior: 'string'
}

For SalesforceV2Sink, use:

{
  externalIdFieldName: any(Azure.Bicep.Types.Concrete.AnyType)
  ignoreNullValues: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SalesforceV2Sink'
  writeBehavior: 'string'
}

For SapCloudForCustomerSink, use:

{
  httpRequestTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SapCloudForCustomerSink'
  writeBehavior: 'string'
}

For SnowflakeSink, use:

{
  importSettings: {
    additionalCopyOptions: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    additionalFormatOptions: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    storageIntegration: any(Azure.Bicep.Types.Concrete.AnyType)
    type: 'string'
  }
  preCopyScript: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SnowflakeSink'
}

For SnowflakeV2Sink, use:

{
  importSettings: {
    additionalCopyOptions: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    additionalFormatOptions: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    storageIntegration: any(Azure.Bicep.Types.Concrete.AnyType)
    type: 'string'
  }
  preCopyScript: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SnowflakeV2Sink'
}

For SqlDWSink, use:

{
  allowCopyCommand: any(Azure.Bicep.Types.Concrete.AnyType)
  allowPolyBase: any(Azure.Bicep.Types.Concrete.AnyType)
  copyCommandSettings: {
    additionalOptions: {
      {customized property}: 'string'
    }
    defaultValues: [
      {
        columnName: any(Azure.Bicep.Types.Concrete.AnyType)
        defaultValue: any(Azure.Bicep.Types.Concrete.AnyType)
      }
    ]
  }
  polyBaseSettings: {
    rejectSampleValue: any(Azure.Bicep.Types.Concrete.AnyType)
    rejectType: 'string'
    rejectValue: any(Azure.Bicep.Types.Concrete.AnyType)
    useTypeDefault: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  preCopyScript: any(Azure.Bicep.Types.Concrete.AnyType)
  sqlWriterUseTableLock: any(Azure.Bicep.Types.Concrete.AnyType)
  tableOption: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SqlDWSink'
  upsertSettings: {
    interimSchemaName: any(Azure.Bicep.Types.Concrete.AnyType)
    keys: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  writeBehavior: any(Azure.Bicep.Types.Concrete.AnyType)
}

For SqlMISink, use:

{
  preCopyScript: any(Azure.Bicep.Types.Concrete.AnyType)
  sqlWriterStoredProcedureName: any(Azure.Bicep.Types.Concrete.AnyType)
  sqlWriterTableType: any(Azure.Bicep.Types.Concrete.AnyType)
  sqlWriterUseTableLock: any(Azure.Bicep.Types.Concrete.AnyType)
  storedProcedureParameters: any(Azure.Bicep.Types.Concrete.AnyType)
  storedProcedureTableTypeParameterName: any(Azure.Bicep.Types.Concrete.AnyType)
  tableOption: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SqlMISink'
  upsertSettings: {
    interimSchemaName: any(Azure.Bicep.Types.Concrete.AnyType)
    keys: any(Azure.Bicep.Types.Concrete.AnyType)
    useTempDB: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  writeBehavior: any(Azure.Bicep.Types.Concrete.AnyType)
}

For SqlServerSink, use:

{
  preCopyScript: any(Azure.Bicep.Types.Concrete.AnyType)
  sqlWriterStoredProcedureName: any(Azure.Bicep.Types.Concrete.AnyType)
  sqlWriterTableType: any(Azure.Bicep.Types.Concrete.AnyType)
  sqlWriterUseTableLock: any(Azure.Bicep.Types.Concrete.AnyType)
  storedProcedureParameters: any(Azure.Bicep.Types.Concrete.AnyType)
  storedProcedureTableTypeParameterName: any(Azure.Bicep.Types.Concrete.AnyType)
  tableOption: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SqlServerSink'
  upsertSettings: {
    interimSchemaName: any(Azure.Bicep.Types.Concrete.AnyType)
    keys: any(Azure.Bicep.Types.Concrete.AnyType)
    useTempDB: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  writeBehavior: any(Azure.Bicep.Types.Concrete.AnyType)
}

For SqlSink, use:

{
  preCopyScript: any(Azure.Bicep.Types.Concrete.AnyType)
  sqlWriterStoredProcedureName: any(Azure.Bicep.Types.Concrete.AnyType)
  sqlWriterTableType: any(Azure.Bicep.Types.Concrete.AnyType)
  sqlWriterUseTableLock: any(Azure.Bicep.Types.Concrete.AnyType)
  storedProcedureParameters: any(Azure.Bicep.Types.Concrete.AnyType)
  storedProcedureTableTypeParameterName: any(Azure.Bicep.Types.Concrete.AnyType)
  tableOption: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SqlSink'
  upsertSettings: {
    interimSchemaName: any(Azure.Bicep.Types.Concrete.AnyType)
    keys: any(Azure.Bicep.Types.Concrete.AnyType)
    useTempDB: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  writeBehavior: any(Azure.Bicep.Types.Concrete.AnyType)
}

For WarehouseSink, use:

{
  allowCopyCommand: any(Azure.Bicep.Types.Concrete.AnyType)
  copyCommandSettings: {
    additionalOptions: {
      {customized property}: 'string'
    }
    defaultValues: [
      {
        columnName: any(Azure.Bicep.Types.Concrete.AnyType)
        defaultValue: any(Azure.Bicep.Types.Concrete.AnyType)
      }
    ]
  }
  preCopyScript: any(Azure.Bicep.Types.Concrete.AnyType)
  tableOption: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'WarehouseSink'
  writeBehavior: any(Azure.Bicep.Types.Concrete.AnyType)
}

FormatReadSettings objects

Set the type property to specify the type of object.

For BinaryReadSettings, use:

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

For DelimitedTextReadSettings, use:

{
  compressionProperties: {
    type: 'string'
    // For remaining properties, see CompressionReadSettings objects
  }
  skipLineCount: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'DelimitedTextReadSettings'
}

For JsonReadSettings, use:

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

For ParquetReadSettings, use:

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

For XmlReadSettings, use:

{
  compressionProperties: {
    type: 'string'
    // For remaining properties, see CompressionReadSettings objects
  }
  detectDataType: any(Azure.Bicep.Types.Concrete.AnyType)
  namespacePrefixes: any(Azure.Bicep.Types.Concrete.AnyType)
  namespaces: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'XmlReadSettings'
  validationMode: any(Azure.Bicep.Types.Concrete.AnyType)
}

CopySource objects

Set the type property to specify the type of object.

For AmazonMWSSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'AmazonMWSSource'
}

For AmazonRdsForOracleSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  oracleReaderQuery: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionOption: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionSettings: {
    partitionColumnName: any(Azure.Bicep.Types.Concrete.AnyType)
    partitionLowerBound: any(Azure.Bicep.Types.Concrete.AnyType)
    partitionNames: any(Azure.Bicep.Types.Concrete.AnyType)
    partitionUpperBound: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'AmazonRdsForOracleSource'
}

For AmazonRdsForSqlServerSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  isolationLevel: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionOption: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionSettings: {
    partitionColumnName: any(Azure.Bicep.Types.Concrete.AnyType)
    partitionLowerBound: any(Azure.Bicep.Types.Concrete.AnyType)
    partitionUpperBound: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  produceAdditionalTypes: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  sqlReaderQuery: any(Azure.Bicep.Types.Concrete.AnyType)
  sqlReaderStoredProcedureName: any(Azure.Bicep.Types.Concrete.AnyType)
  storedProcedureParameters: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'AmazonRdsForSqlServerSource'
}

For AmazonRedshiftSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  redshiftUnloadSettings: {
    bucketName: any(Azure.Bicep.Types.Concrete.AnyType)
    s3LinkedServiceName: {
      parameters: {
        {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
      }
      referenceName: 'string'
      type: 'string'
    }
  }
  type: 'AmazonRedshiftSource'
}

For AvroSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  storeSettings: {
    disableMetricsCollection: any(Azure.Bicep.Types.Concrete.AnyType)
    maxConcurrentConnections: any(Azure.Bicep.Types.Concrete.AnyType)
    type: 'string'
    // For remaining properties, see StoreReadSettings objects
  }
  type: 'AvroSource'
}

For AzureBlobFSSource, use:

{
  recursive: any(Azure.Bicep.Types.Concrete.AnyType)
  skipHeaderLineCount: any(Azure.Bicep.Types.Concrete.AnyType)
  treatEmptyAsNull: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'AzureBlobFSSource'
}

For AzureDataExplorerSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  noTruncation: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'AzureDataExplorerSource'
}

For AzureDataLakeStoreSource, use:

{
  recursive: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'AzureDataLakeStoreSource'
}

For AzureDatabricksDeltaLakeSource, use:

{
  exportSettings: {
    dateFormat: any(Azure.Bicep.Types.Concrete.AnyType)
    timestampFormat: any(Azure.Bicep.Types.Concrete.AnyType)
    type: 'string'
  }
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'AzureDatabricksDeltaLakeSource'
}

For AzureMariaDBSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'AzureMariaDBSource'
}

For AzureMySqlSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'AzureMySqlSource'
}

For AzurePostgreSqlSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'AzurePostgreSqlSource'
}

For AzureSqlSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  isolationLevel: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionOption: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionSettings: {
    partitionColumnName: any(Azure.Bicep.Types.Concrete.AnyType)
    partitionLowerBound: any(Azure.Bicep.Types.Concrete.AnyType)
    partitionUpperBound: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  produceAdditionalTypes: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  sqlReaderQuery: any(Azure.Bicep.Types.Concrete.AnyType)
  sqlReaderStoredProcedureName: any(Azure.Bicep.Types.Concrete.AnyType)
  storedProcedureParameters: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'AzureSqlSource'
}

For AzureTableSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  azureTableSourceIgnoreTableNotFound: any(Azure.Bicep.Types.Concrete.AnyType)
  azureTableSourceQuery: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'AzureTableSource'
}

For BinarySource, use:

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

For BlobSource, use:

{
  recursive: any(Azure.Bicep.Types.Concrete.AnyType)
  skipHeaderLineCount: any(Azure.Bicep.Types.Concrete.AnyType)
  treatEmptyAsNull: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'BlobSource'
}

For CassandraSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  consistencyLevel: 'string'
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'CassandraSource'
}

For CommonDataServiceForAppsSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'CommonDataServiceForAppsSource'
}

For ConcurSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'ConcurSource'
}

For CosmosDbMongoDbApiSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  batchSize: any(Azure.Bicep.Types.Concrete.AnyType)
  cursorMethods: {
    limit: any(Azure.Bicep.Types.Concrete.AnyType)
    project: any(Azure.Bicep.Types.Concrete.AnyType)
    skip: any(Azure.Bicep.Types.Concrete.AnyType)
    sort: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  filter: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'CosmosDbMongoDbApiSource'
}

For CosmosDbSqlApiSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  detectDatetime: any(Azure.Bicep.Types.Concrete.AnyType)
  pageSize: any(Azure.Bicep.Types.Concrete.AnyType)
  preferredRegions: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'CosmosDbSqlApiSource'
}

For CouchbaseSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'CouchbaseSource'
}

For Db2Source, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'Db2Source'
}

For DelimitedTextSource, use:

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

For DocumentDbCollectionSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  nestingSeparator: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'DocumentDbCollectionSource'
}

For DrillSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'DrillSource'
}

For DynamicsAXSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  httpRequestTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'DynamicsAXSource'
}

For DynamicsCrmSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'DynamicsCrmSource'
}

For DynamicsSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'DynamicsSource'
}

For EloquaSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'EloquaSource'
}

For ExcelSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  storeSettings: {
    disableMetricsCollection: any(Azure.Bicep.Types.Concrete.AnyType)
    maxConcurrentConnections: any(Azure.Bicep.Types.Concrete.AnyType)
    type: 'string'
    // For remaining properties, see StoreReadSettings objects
  }
  type: 'ExcelSource'
}

For FileSystemSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  recursive: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'FileSystemSource'
}

For GoogleAdWordsSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'GoogleAdWordsSource'
}

For GoogleBigQuerySource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'GoogleBigQuerySource'
}

For GoogleBigQueryV2Source, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'GoogleBigQueryV2Source'
}

For GreenplumSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'GreenplumSource'
}

For HBaseSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'HBaseSource'
}

For HdfsSource, use:

{
  distcpSettings: {
    distcpOptions: any(Azure.Bicep.Types.Concrete.AnyType)
    resourceManagerEndpoint: any(Azure.Bicep.Types.Concrete.AnyType)
    tempScriptPath: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  recursive: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'HdfsSource'
}

For HiveSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'HiveSource'
}

For HttpSource, use:

{
  httpRequestTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'HttpSource'
}

For HubspotSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'HubspotSource'
}

For ImpalaSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'ImpalaSource'
}

For InformixSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'InformixSource'
}

For JiraSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'JiraSource'
}

For JsonSource, use:

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

For LakeHouseTableSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  timestampAsOf: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'LakeHouseTableSource'
  versionAsOf: any(Azure.Bicep.Types.Concrete.AnyType)
}

For MagentoSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'MagentoSource'
}

For MariaDBSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'MariaDBSource'
}

For MarketoSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'MarketoSource'
}

For MicrosoftAccessSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'MicrosoftAccessSource'
}

For MongoDbAtlasSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  batchSize: any(Azure.Bicep.Types.Concrete.AnyType)
  cursorMethods: {
    limit: any(Azure.Bicep.Types.Concrete.AnyType)
    project: any(Azure.Bicep.Types.Concrete.AnyType)
    skip: any(Azure.Bicep.Types.Concrete.AnyType)
    sort: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  filter: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'MongoDbAtlasSource'
}

For MongoDbSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'MongoDbSource'
}

For MongoDbV2Source, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  batchSize: any(Azure.Bicep.Types.Concrete.AnyType)
  cursorMethods: {
    limit: any(Azure.Bicep.Types.Concrete.AnyType)
    project: any(Azure.Bicep.Types.Concrete.AnyType)
    skip: any(Azure.Bicep.Types.Concrete.AnyType)
    sort: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  filter: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'MongoDbV2Source'
}

For MySqlSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'MySqlSource'
}

For NetezzaSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionOption: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionSettings: {
    partitionColumnName: any(Azure.Bicep.Types.Concrete.AnyType)
    partitionLowerBound: any(Azure.Bicep.Types.Concrete.AnyType)
    partitionUpperBound: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'NetezzaSource'
}

For ODataSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  httpRequestTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'ODataSource'
}

For OdbcSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'OdbcSource'
}

For Office365Source, use:

{
  allowedGroups: any(Azure.Bicep.Types.Concrete.AnyType)
  dateFilterColumn: any(Azure.Bicep.Types.Concrete.AnyType)
  endTime: any(Azure.Bicep.Types.Concrete.AnyType)
  outputColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  startTime: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'Office365Source'
  userScopeFilterUri: any(Azure.Bicep.Types.Concrete.AnyType)
}

For OracleServiceCloudSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'OracleServiceCloudSource'
}

For OracleSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  oracleReaderQuery: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionOption: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionSettings: {
    partitionColumnName: any(Azure.Bicep.Types.Concrete.AnyType)
    partitionLowerBound: any(Azure.Bicep.Types.Concrete.AnyType)
    partitionNames: any(Azure.Bicep.Types.Concrete.AnyType)
    partitionUpperBound: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'OracleSource'
}

For OrcSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  storeSettings: {
    disableMetricsCollection: any(Azure.Bicep.Types.Concrete.AnyType)
    maxConcurrentConnections: any(Azure.Bicep.Types.Concrete.AnyType)
    type: 'string'
    // For remaining properties, see StoreReadSettings objects
  }
  type: 'OrcSource'
}

For ParquetSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  formatSettings: {
    compressionProperties: {
      type: 'string'
      // For remaining properties, see CompressionReadSettings objects
    }
    type: 'string'
  }
  storeSettings: {
    disableMetricsCollection: any(Azure.Bicep.Types.Concrete.AnyType)
    maxConcurrentConnections: any(Azure.Bicep.Types.Concrete.AnyType)
    type: 'string'
    // For remaining properties, see StoreReadSettings objects
  }
  type: 'ParquetSource'
}

For PaypalSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'PaypalSource'
}

For PhoenixSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'PhoenixSource'
}

For PostgreSqlSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'PostgreSqlSource'
}

For PostgreSqlV2Source, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'PostgreSqlV2Source'
}

For PrestoSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'PrestoSource'
}

For QuickBooksSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'QuickBooksSource'
}

For RelationalSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'RelationalSource'
}

For ResponsysSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'ResponsysSource'
}

For RestSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  additionalHeaders: any(Azure.Bicep.Types.Concrete.AnyType)
  httpRequestTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  paginationRules: any(Azure.Bicep.Types.Concrete.AnyType)
  requestBody: any(Azure.Bicep.Types.Concrete.AnyType)
  requestInterval: any(Azure.Bicep.Types.Concrete.AnyType)
  requestMethod: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'RestSource'
}

For SalesforceMarketingCloudSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SalesforceMarketingCloudSource'
}

For SalesforceServiceCloudSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  readBehavior: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SalesforceServiceCloudSource'
}

For SalesforceServiceCloudV2Source, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  includeDeletedObjects: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  SOQLQuery: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SalesforceServiceCloudV2Source'
}

For SalesforceSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  readBehavior: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SalesforceSource'
}

For SalesforceV2Source, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  includeDeletedObjects: any(Azure.Bicep.Types.Concrete.AnyType)
  pageSize: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  SOQLQuery: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SalesforceV2Source'
}

For SapBwSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SapBwSource'
}

For SapCloudForCustomerSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  httpRequestTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SapCloudForCustomerSource'
}

For SapEccSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  httpRequestTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SapEccSource'
}

For SapHanaSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  packetSize: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionOption: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionSettings: {
    partitionColumnName: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SapHanaSource'
}

For SapOdpSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  extractionMode: any(Azure.Bicep.Types.Concrete.AnyType)
  projection: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  selection: any(Azure.Bicep.Types.Concrete.AnyType)
  subscriberProcess: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SapOdpSource'
}

For SapOpenHubSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  baseRequestId: any(Azure.Bicep.Types.Concrete.AnyType)
  customRfcReadTableFunctionModule: any(Azure.Bicep.Types.Concrete.AnyType)
  excludeLastRequest: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  sapDataColumnDelimiter: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SapOpenHubSource'
}

For SapTableSource, use:

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

For ServiceNowSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'ServiceNowSource'
}

For ServiceNowV2Source, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  expression: {
    operands: [
      ...
    ]
    operators: [
      'string'
    ]
    type: 'string'
    value: 'string'
  }
  pageSize: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'ServiceNowV2Source'
}

For SharePointOnlineListSource, use:

{
  httpRequestTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SharePointOnlineListSource'
}

For ShopifySource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'ShopifySource'
}

For SnowflakeSource, use:

{
  exportSettings: {
    additionalCopyOptions: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    additionalFormatOptions: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    storageIntegration: any(Azure.Bicep.Types.Concrete.AnyType)
    type: 'string'
  }
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SnowflakeSource'
}

For SnowflakeV2Source, use:

{
  exportSettings: {
    additionalCopyOptions: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    additionalFormatOptions: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    storageIntegration: any(Azure.Bicep.Types.Concrete.AnyType)
    type: 'string'
  }
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SnowflakeV2Source'
}

For SparkSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SparkSource'
}

For SqlDWSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  isolationLevel: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionOption: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionSettings: {
    partitionColumnName: any(Azure.Bicep.Types.Concrete.AnyType)
    partitionLowerBound: any(Azure.Bicep.Types.Concrete.AnyType)
    partitionUpperBound: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  sqlReaderQuery: any(Azure.Bicep.Types.Concrete.AnyType)
  sqlReaderStoredProcedureName: any(Azure.Bicep.Types.Concrete.AnyType)
  storedProcedureParameters: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SqlDWSource'
}

For SqlMISource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  isolationLevel: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionOption: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionSettings: {
    partitionColumnName: any(Azure.Bicep.Types.Concrete.AnyType)
    partitionLowerBound: any(Azure.Bicep.Types.Concrete.AnyType)
    partitionUpperBound: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  produceAdditionalTypes: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  sqlReaderQuery: any(Azure.Bicep.Types.Concrete.AnyType)
  sqlReaderStoredProcedureName: any(Azure.Bicep.Types.Concrete.AnyType)
  storedProcedureParameters: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SqlMISource'
}

For SqlServerSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  isolationLevel: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionOption: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionSettings: {
    partitionColumnName: any(Azure.Bicep.Types.Concrete.AnyType)
    partitionLowerBound: any(Azure.Bicep.Types.Concrete.AnyType)
    partitionUpperBound: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  produceAdditionalTypes: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  sqlReaderQuery: any(Azure.Bicep.Types.Concrete.AnyType)
  sqlReaderStoredProcedureName: any(Azure.Bicep.Types.Concrete.AnyType)
  storedProcedureParameters: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SqlServerSource'
}

For SqlSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  isolationLevel: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionOption: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionSettings: {
    partitionColumnName: any(Azure.Bicep.Types.Concrete.AnyType)
    partitionLowerBound: any(Azure.Bicep.Types.Concrete.AnyType)
    partitionUpperBound: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  sqlReaderQuery: any(Azure.Bicep.Types.Concrete.AnyType)
  sqlReaderStoredProcedureName: any(Azure.Bicep.Types.Concrete.AnyType)
  storedProcedureParameters: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SqlSource'
}

For SquareSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SquareSource'
}

For SybaseSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'SybaseSource'
}

For TeradataSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionOption: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionSettings: {
    partitionColumnName: any(Azure.Bicep.Types.Concrete.AnyType)
    partitionLowerBound: any(Azure.Bicep.Types.Concrete.AnyType)
    partitionUpperBound: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'TeradataSource'
}

For VerticaSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'VerticaSource'
}

For WarehouseSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  isolationLevel: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionOption: any(Azure.Bicep.Types.Concrete.AnyType)
  partitionSettings: {
    partitionColumnName: any(Azure.Bicep.Types.Concrete.AnyType)
    partitionLowerBound: any(Azure.Bicep.Types.Concrete.AnyType)
    partitionUpperBound: any(Azure.Bicep.Types.Concrete.AnyType)
  }
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  sqlReaderQuery: any(Azure.Bicep.Types.Concrete.AnyType)
  sqlReaderStoredProcedureName: any(Azure.Bicep.Types.Concrete.AnyType)
  storedProcedureParameters: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'WarehouseSource'
}

For XeroSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'XeroSource'
}

For ZohoSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  query: any(Azure.Bicep.Types.Concrete.AnyType)
  queryTimeout: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'ZohoSource'
}

For WebSource, use:

{
  additionalColumns: any(Azure.Bicep.Types.Concrete.AnyType)
  type: 'WebSource'
}

For XmlSource, use:

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

SecretBase objects

Set the type property to specify the type of object.

For AzureKeyVaultSecret, use:

{
  secretName: any(Azure.Bicep.Types.Concrete.AnyType)
  secretVersion: any(Azure.Bicep.Types.Concrete.AnyType)
  store: {
    parameters: {
      {customized property}: any(Azure.Bicep.Types.Concrete.AnyType)
    }
    referenceName: 'string'
    type: 'string'
  }
  type: 'AzureKeyVaultSecret'
}

For SecureString, use:

{
  type: 'SecureString'
  value: 'string'
}

Property values

Activity

Name	Description	Value
dependsOn	Activity depends on condition.	ActivityDependency[]
description	Activity description.	string
name	Activity name.	string (required)
onInactiveMarkAs	Status result of the activity when the state is set to Inactive. This is an optional property and if not provided when the activity is inactive, the status will be Succeeded by default.	'Failed' 'Skipped' 'Succeeded'
state	Activity state. This is an optional property and if not provided, the state will be Active by default.	'Active' 'Inactive'
type	Set to 'AppendVariable' for type AppendVariableActivity. Set to 'AzureDataExplorerCommand' for type AzureDataExplorerCommandActivity. Set to 'AzureFunctionActivity' for type AzureFunctionActivity. Set to 'AzureMLBatchExecution' for type AzureMLBatchExecutionActivity. Set to 'AzureMLExecutePipeline' for type AzureMLExecutePipelineActivity. Set to 'AzureMLUpdateResource' for type AzureMLUpdateResourceActivity. Set to 'ExecutePipeline' for type ExecutePipelineActivity. Set to 'Fail' for type FailActivity. Set to 'Filter' for type FilterActivity. Set to 'ForEach' for type ForEachActivity. Set to 'IfCondition' for type IfConditionActivity. Set to 'SetVariable' for type SetVariableActivity. Set to 'Switch' for type SwitchActivity. Set to 'Until' for type UntilActivity. Set to 'Validation' for type ValidationActivity. Set to 'Wait' for type WaitActivity. Set to 'WebHook' for type WebHookActivity. Set to 'Copy' for type CopyActivity. Set to 'Custom' for type CustomActivity. Set to 'DataLakeAnalyticsU-SQL' for type DataLakeAnalyticsUsqlActivity. Set to 'DatabricksNotebook' for type DatabricksNotebookActivity. Set to 'DatabricksSparkJar' for type DatabricksSparkJarActivity. Set to 'DatabricksSparkPython' for type DatabricksSparkPythonActivity. Set to 'Delete' for type DeleteActivity. Set to 'ExecuteDataFlow' for type ExecuteDataFlowActivity. Set to 'ExecuteSSISPackage' for type ExecuteSsisPackageActivity. Set to 'ExecuteWranglingDataflow' for type ExecuteWranglingDataflowActivity. Set to 'GetMetadata' for type GetMetadataActivity. Set to 'HDInsightHive' for type HDInsightHiveActivity. Set to 'HDInsightMapReduce' for type HDInsightMapReduceActivity. Set to 'HDInsightPig' for type HDInsightPigActivity. Set to 'HDInsightSpark' for type HDInsightSparkActivity. Set to 'HDInsightStreaming' for type HDInsightStreamingActivity. Set to 'Lookup' for type LookupActivity. Set to 'Script' for type ScriptActivity. Set to 'SparkJob' for type SynapseSparkJobDefinitionActivity. Set to 'SqlServerStoredProcedure' for type SqlServerStoredProcedureActivity. Set to 'SynapseNotebook' for type SynapseNotebookActivity. Set to 'WebActivity' for type WebActivity.	'AppendVariable' 'AzureDataExplorerCommand' 'AzureFunctionActivity' 'AzureMLBatchExecution' 'AzureMLExecutePipeline' 'AzureMLUpdateResource' 'Copy' 'Custom' 'DatabricksNotebook' 'DatabricksSparkJar' 'DatabricksSparkPython' 'DataLakeAnalyticsU-SQL' 'Delete' 'ExecuteDataFlow' 'ExecutePipeline' 'ExecuteSSISPackage' 'ExecuteWranglingDataflow' 'Fail' 'Filter' 'ForEach' 'GetMetadata' 'HDInsightHive' 'HDInsightMapReduce' 'HDInsightPig' 'HDInsightSpark' 'HDInsightStreaming' 'IfCondition' 'Lookup' 'Script' 'SetVariable' 'SparkJob' 'SqlServerStoredProcedure' 'Switch' 'SynapseNotebook' 'Until' 'Validation' 'Wait' 'WebActivity' 'WebHook' (required)
userProperties	Activity user properties.	UserProperty[]

ActivityDependency

Name	Description	Value
activity	Activity name.	string (required)
dependencyConditions	Match-Condition for the dependency.	String array containing any of: 'Completed' 'Failed' 'Skipped' 'Succeeded' (required)

ActivityPolicy

Name	Description	Value
retry	Maximum ordinary retry attempts. Default is 0. Type: integer (or Expression with resultType integer), minimum: 0.	any
retryIntervalInSeconds	Interval between each retry attempt (in seconds). The default is 30 sec.	int Constraints: Min value = 30 Max value = 86400
secureInput	When set to true, Input from activity is considered as secure and will not be logged to monitoring.	bool
secureOutput	When set to true, Output from activity is considered as secure and will not be logged to monitoring.	bool
timeout	Specifies the timeout for the activity to run. The default timeout is 7 days. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any

AmazonMWSSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
query	A query to retrieve data from source. Type: string (or Expression with resultType string).	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Copy source type.	'AmazonMWSSource' (required)

AmazonRdsForOraclePartitionSettings

Name	Description	Value
partitionColumnName	The name of the column in integer type that will be used for proceeding range partitioning. Type: string (or Expression with resultType string).	any
partitionLowerBound	The minimum value of column specified in partitionColumnName that will be used for proceeding range partitioning. Type: string (or Expression with resultType string).	any
partitionNames	Names of the physical partitions of AmazonRdsForOracle table.	any
partitionUpperBound	The maximum value of column specified in partitionColumnName that will be used for proceeding range partitioning. Type: string (or Expression with resultType string).	any

AmazonRdsForOracleSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
oracleReaderQuery	AmazonRdsForOracle reader query. Type: string (or Expression with resultType string).	any
partitionOption	The partition mechanism that will be used for AmazonRdsForOracle read in parallel. Type: string (or Expression with resultType string).	any
partitionSettings	The settings that will be leveraged for AmazonRdsForOracle source partitioning.	AmazonRdsForOraclePartitionSettings
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Copy source type.	'AmazonRdsForOracleSource' (required)

AmazonRdsForSqlServerSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
isolationLevel	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).	any
partitionOption	The partition mechanism that will be used for Sql read in parallel. Possible values include: "None", "PhysicalPartitionsOfTable", "DynamicRange".	any
partitionSettings	The settings that will be leveraged for Sql source partitioning.	SqlPartitionSettings
produceAdditionalTypes	Which additional types to produce.	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
sqlReaderQuery	SQL reader query. Type: string (or Expression with resultType string).	any
sqlReaderStoredProcedureName	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).	any
storedProcedureParameters	Value and type setting for stored procedure parameters. Example: "{Parameter1: {value: "1", type: "int"}}".	any
type	Copy source type.	'AmazonRdsForSqlServerSource' (required)

AmazonRedshiftSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
query	Database query. Type: string (or Expression with resultType string).	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
redshiftUnloadSettings	The Amazon S3 settings needed for the interim Amazon S3 when copying from Amazon Redshift with unload. With this, data from Amazon Redshift source will be unloaded into S3 first and then copied into the targeted sink from the interim S3.	RedshiftUnloadSettings
type	Copy source type.	'AmazonRedshiftSource' (required)

AmazonS3CompatibleReadSettings

Name	Description	Value
deleteFilesAfterCompletion	Indicates whether the source files need to be deleted after copy completion. Default is false. Type: boolean (or Expression with resultType boolean).	any
enablePartitionDiscovery	Indicates whether to enable partition discovery. Type: boolean (or Expression with resultType boolean).	any
fileListPath	Point to a text file that lists each file (relative path to the path configured in the dataset) that you want to copy. Type: string (or Expression with resultType string).	any
modifiedDatetimeEnd	The end of file's modified datetime. Type: string (or Expression with resultType string).	any
modifiedDatetimeStart	The start of file's modified datetime. Type: string (or Expression with resultType string).	any
partitionRootPath	Specify the root path where partition discovery starts from. Type: string (or Expression with resultType string).	any
prefix	The prefix filter for the S3 Compatible object name. Type: string (or Expression with resultType string).	any
recursive	If true, files under the folder path will be read recursively. Default is true. Type: boolean (or Expression with resultType boolean).	any
type	The read setting type.	'AmazonS3CompatibleReadSettings' (required)
wildcardFileName	Amazon S3 Compatible wildcardFileName. Type: string (or Expression with resultType string).	any
wildcardFolderPath	Amazon S3 Compatible wildcardFolderPath. Type: string (or Expression with resultType string).	any

AmazonS3ReadSettings

Name	Description	Value
deleteFilesAfterCompletion	Indicates whether the source files need to be deleted after copy completion. Default is false. Type: boolean (or Expression with resultType boolean).	any
enablePartitionDiscovery	Indicates whether to enable partition discovery. Type: boolean (or Expression with resultType boolean).	any
fileListPath	Point to a text file that lists each file (relative path to the path configured in the dataset) that you want to copy. Type: string (or Expression with resultType string).	any
modifiedDatetimeEnd	The end of file's modified datetime. Type: string (or Expression with resultType string).	any
modifiedDatetimeStart	The start of file's modified datetime. Type: string (or Expression with resultType string).	any
partitionRootPath	Specify the root path where partition discovery starts from. Type: string (or Expression with resultType string).	any
prefix	The prefix filter for the S3 object name. Type: string (or Expression with resultType string).	any
recursive	If true, files under the folder path will be read recursively. Default is true. Type: boolean (or Expression with resultType boolean).	any
type	The read setting type.	'AmazonS3ReadSettings' (required)
wildcardFileName	AmazonS3 wildcardFileName. Type: string (or Expression with resultType string).	any
wildcardFolderPath	AmazonS3 wildcardFolderPath. Type: string (or Expression with resultType string).	any

AppendVariableActivity

Name	Description	Value
type	Type of activity.	'AppendVariable' (required)
typeProperties	Append Variable activity properties.	AppendVariableActivityTypeProperties (required)

AppendVariableActivityTypeProperties

Name	Description	Value
value	Value to be appended. Type: could be a static value matching type of the variable item or Expression with resultType matching type of the variable item	any
variableName	Name of the variable whose value needs to be appended to.	string

AvroSink

Name	Description	Value
formatSettings	Avro format settings.	AvroWriteSettings
storeSettings	Avro store settings.	StoreWriteSettings
type	Copy sink type.	'AvroSink' (required)

AvroSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
storeSettings	Avro store settings.	StoreReadSettings
type	Copy source type.	'AvroSource' (required)

AvroWriteSettings

Name	Description	Value
fileNamePrefix	Specifies the file name pattern <fileNamePrefix>_<fileIndex>.<fileExtension> when copy from non-file based store without partitionOptions. Type: string (or Expression with resultType string).	any
maxRowsPerFile	Limit the written file's row count to be smaller than or equal to the specified count. Type: integer (or Expression with resultType integer).	any
recordName	Top level record name in write result, which is required in AVRO spec.	string
recordNamespace	Record namespace in the write result.	string
type	The write setting type.	string (required)

AzureBlobFSReadSettings

Name	Description	Value
deleteFilesAfterCompletion	Indicates whether the source files need to be deleted after copy completion. Default is false. Type: boolean (or Expression with resultType boolean).	any
enablePartitionDiscovery	Indicates whether to enable partition discovery. Type: boolean (or Expression with resultType boolean).	any
fileListPath	Point to a text file that lists each file (relative path to the path configured in the dataset) that you want to copy. Type: string (or Expression with resultType string).	any
modifiedDatetimeEnd	The end of file's modified datetime. Type: string (or Expression with resultType string).	any
modifiedDatetimeStart	The start of file's modified datetime. Type: string (or Expression with resultType string).	any
partitionRootPath	Specify the root path where partition discovery starts from. Type: string (or Expression with resultType string).	any
recursive	If true, files under the folder path will be read recursively. Default is true. Type: boolean (or Expression with resultType boolean).	any
type	The read setting type.	'AzureBlobFSReadSettings' (required)
wildcardFileName	Azure blobFS wildcardFileName. Type: string (or Expression with resultType string).	any
wildcardFolderPath	Azure blobFS wildcardFolderPath. Type: string (or Expression with resultType string).	any

AzureBlobFSSink

Name	Description	Value
copyBehavior	The type of copy behavior for copy sink. Type: string (or Expression with resultType string).	any
metadata	Specify the custom metadata to be added to sink data. Type: array of objects (or Expression with resultType array of objects).	MetadataItem[]
type	Copy sink type.	'AzureBlobFSSink' (required)

AzureBlobFSSource

Name	Description	Value
recursive	If true, files under the folder path will be read recursively. Default is true. Type: boolean (or Expression with resultType boolean).	any
skipHeaderLineCount	Number of header lines to skip from each blob. Type: integer (or Expression with resultType integer).	any
treatEmptyAsNull	Treat empty as null. Type: boolean (or Expression with resultType boolean).	any
type	Copy source type.	'AzureBlobFSSource' (required)

AzureBlobFSWriteSettings

Name	Description	Value
blockSizeInMB	Indicates the block size(MB) when writing data to blob. Type: integer (or Expression with resultType integer).	any
type	The write setting type.	'AzureBlobFSWriteSettings' (required)

AzureBlobStorageReadSettings

Name	Description	Value
deleteFilesAfterCompletion	Indicates whether the source files need to be deleted after copy completion. Default is false. Type: boolean (or Expression with resultType boolean).	any
enablePartitionDiscovery	Indicates whether to enable partition discovery. Type: boolean (or Expression with resultType boolean).	any
fileListPath	Point to a text file that lists each file (relative path to the path configured in the dataset) that you want to copy. Type: string (or Expression with resultType string).	any
modifiedDatetimeEnd	The end of file's modified datetime. Type: string (or Expression with resultType string).	any
modifiedDatetimeStart	The start of file's modified datetime. Type: string (or Expression with resultType string).	any
partitionRootPath	Specify the root path where partition discovery starts from. Type: string (or Expression with resultType string).	any
prefix	The prefix filter for the Azure Blob name. Type: string (or Expression with resultType string).	any
recursive	If true, files under the folder path will be read recursively. Default is true. Type: boolean (or Expression with resultType boolean).	any
type	The read setting type.	'AzureBlobStorageReadSettings' (required)
wildcardFileName	Azure blob wildcardFileName. Type: string (or Expression with resultType string).	any
wildcardFolderPath	Azure blob wildcardFolderPath. Type: string (or Expression with resultType string).	any

AzureBlobStorageWriteSettings

Name	Description	Value
blockSizeInMB	Indicates the block size(MB) when writing data to blob. Type: integer (or Expression with resultType integer).	any
type	The write setting type.	'AzureBlobStorageWriteSettings' (required)

AzureDatabricksDeltaLakeExportCommand

Name	Description	Value
dateFormat	Specify the date format for the csv in Azure Databricks Delta Lake Copy. Type: string (or Expression with resultType string).	any
timestampFormat	Specify the timestamp format for the csv in Azure Databricks Delta Lake Copy. Type: string (or Expression with resultType string).	any
type	The export setting type.	string (required)

AzureDatabricksDeltaLakeImportCommand

Name	Description	Value
dateFormat	Specify the date format for csv in Azure Databricks Delta Lake Copy. Type: string (or Expression with resultType string).	any
timestampFormat	Specify the timestamp format for csv in Azure Databricks Delta Lake Copy. Type: string (or Expression with resultType string).	any
type	The import setting type.	string (required)

AzureDatabricksDeltaLakeSink

Name	Description	Value
importSettings	Azure Databricks Delta Lake import settings.	AzureDatabricksDeltaLakeImportCommand
preCopyScript	SQL pre-copy script. Type: string (or Expression with resultType string).	any
type	Copy sink type.	'AzureDatabricksDeltaLakeSink' (required)

AzureDatabricksDeltaLakeSource

Name	Description	Value
exportSettings	Azure Databricks Delta Lake export settings.	AzureDatabricksDeltaLakeExportCommand
query	Azure Databricks Delta Lake Sql query. Type: string (or Expression with resultType string).	any
type	Copy source type.	'AzureDatabricksDeltaLakeSource' (required)

AzureDataExplorerCommandActivity

Name	Description	Value
linkedServiceName	Linked service reference.	LinkedServiceReference
policy	Activity policy.	ActivityPolicy
type	Type of activity.	'AzureDataExplorerCommand' (required)
typeProperties	Azure Data Explorer command activity properties.	AzureDataExplorerCommandActivityTypeProperties (required)

AzureDataExplorerCommandActivityTypeProperties

Name	Description	Value
command	A control command, according to the Azure Data Explorer command syntax. Type: string (or Expression with resultType string).	any (required)
commandTimeout	Control command timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9]))..)	any

AzureDataExplorerSink

Name	Description	Value
flushImmediately	If set to true, any aggregation will be skipped. Default is false. Type: boolean.	any
ingestionMappingAsJson	An explicit column mapping description provided in a json format. Type: string.	any
ingestionMappingName	A name of a pre-created csv mapping that was defined on the target Kusto table. Type: string.	any
type	Copy sink type.	'AzureDataExplorerSink' (required)

AzureDataExplorerSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
noTruncation	The name of the Boolean option that controls whether truncation is applied to result-sets that go beyond a certain row-count limit.	any
query	Database query. Should be a Kusto Query Language (KQL) query. Type: string (or Expression with resultType string).	any (required)
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9]))..	any
type	Copy source type.	'AzureDataExplorerSource' (required)

AzureDataLakeStoreReadSettings

Name	Description	Value
deleteFilesAfterCompletion	Indicates whether the source files need to be deleted after copy completion. Default is false. Type: boolean (or Expression with resultType boolean).	any
enablePartitionDiscovery	Indicates whether to enable partition discovery. Type: boolean (or Expression with resultType boolean).	any
fileListPath	Point to a text file that lists each file (relative path to the path configured in the dataset) that you want to copy. Type: string (or Expression with resultType string).	any
listAfter	Lists files after the value (exclusive) based on file/folder names’ lexicographical order. Applies under the folderPath in data set, and filter files/sub-folders under the folderPath. Type: string (or Expression with resultType string).	any
listBefore	Lists files before the value (inclusive) based on file/folder names’ lexicographical order. Applies under the folderPath in data set, and filter files/sub-folders under the folderPath. Type: string (or Expression with resultType string).	any
modifiedDatetimeEnd	The end of file's modified datetime. Type: string (or Expression with resultType string).	any
modifiedDatetimeStart	The start of file's modified datetime. Type: string (or Expression with resultType string).	any
partitionRootPath	Specify the root path where partition discovery starts from. Type: string (or Expression with resultType string).	any
recursive	If true, files under the folder path will be read recursively. Default is true. Type: boolean (or Expression with resultType boolean).	any
type	The read setting type.	'AzureDataLakeStoreReadSettings' (required)
wildcardFileName	ADLS wildcardFileName. Type: string (or Expression with resultType string).	any
wildcardFolderPath	ADLS wildcardFolderPath. Type: string (or Expression with resultType string).	any

AzureDataLakeStoreSink

Name	Description	Value
copyBehavior	The type of copy behavior for copy sink. Type: string (or Expression with resultType string).	any
enableAdlsSingleFileParallel	Single File Parallel.	any
type	Copy sink type.	'AzureDataLakeStoreSink' (required)

AzureDataLakeStoreSource

Name	Description	Value
recursive	If true, files under the folder path will be read recursively. Default is true. Type: boolean (or Expression with resultType boolean).	any
type	Copy source type.	'AzureDataLakeStoreSource' (required)

AzureDataLakeStoreWriteSettings

Name	Description	Value
expiryDateTime	Specifies the expiry time of the written files. The time is applied to the UTC time zone in the format of "2018-12-01T05:00:00Z". Default value is NULL. Type: string (or Expression with resultType string).	any
type	The write setting type.	'AzureDataLakeStoreWriteSettings' (required)

AzureFileStorageReadSettings

Name	Description	Value
deleteFilesAfterCompletion	Indicates whether the source files need to be deleted after copy completion. Default is false. Type: boolean (or Expression with resultType boolean).	any
enablePartitionDiscovery	Indicates whether to enable partition discovery. Type: boolean (or Expression with resultType boolean).	any
fileListPath	Point to a text file that lists each file (relative path to the path configured in the dataset) that you want to copy. Type: string (or Expression with resultType string).	any
modifiedDatetimeEnd	The end of file's modified datetime. Type: string (or Expression with resultType string).	any
modifiedDatetimeStart	The start of file's modified datetime. Type: string (or Expression with resultType string).	any
partitionRootPath	Specify the root path where partition discovery starts from. Type: string (or Expression with resultType string).	any
prefix	The prefix filter for the Azure File name starting from root path. Type: string (or Expression with resultType string).	any
recursive	If true, files under the folder path will be read recursively. Default is true. Type: boolean (or Expression with resultType boolean).	any
type	The read setting type.	'AzureFileStorageReadSettings' (required)
wildcardFileName	Azure File Storage wildcardFileName. Type: string (or Expression with resultType string).	any
wildcardFolderPath	Azure File Storage wildcardFolderPath. Type: string (or Expression with resultType string).	any

AzureFileStorageWriteSettings

Name	Description	Value
type	The write setting type.	'AzureFileStorageWriteSettings' (required)

AzureFunctionActivity

Name	Description	Value
linkedServiceName	Linked service reference.	LinkedServiceReference
policy	Activity policy.	ActivityPolicy
type	Type of activity.	'AzureFunctionActivity' (required)
typeProperties	Azure Function activity properties.	AzureFunctionActivityTypeProperties (required)

AzureFunctionActivityTypeProperties

Name	Description	Value
body	Represents the payload that will be sent to the endpoint. Required for POST/PUT method, not allowed for GET method Type: string (or Expression with resultType string).	any
functionName	Name of the Function that the Azure Function Activity will call. Type: string (or Expression with resultType string)	any (required)
headers	Represents the headers that will be sent to the request. For example, to set the language and type on a request: "headers" : { "Accept-Language": "en-us", "Content-Type": "application/json" }. Type: string (or Expression with resultType string).	AzureFunctionActivityTypePropertiesHeaders
method	Rest API method for target endpoint.	'DELETE' 'GET' 'HEAD' 'OPTIONS' 'POST' 'PUT' 'TRACE' (required)

AzureFunctionActivityTypePropertiesHeaders

Name	Description	Value

AzureKeyVaultSecretReference

Name	Description	Value
secretName	The name of the secret in Azure Key Vault. Type: string (or Expression with resultType string).	any (required)
secretVersion	The version of the secret in Azure Key Vault. The default value is the latest version of the secret. Type: string (or Expression with resultType string).	any
store	The Azure Key Vault linked service reference.	LinkedServiceReference (required)
type	Type of the secret.	'AzureKeyVaultSecret' (required)

AzureMariaDBSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
query	A query to retrieve data from source. Type: string (or Expression with resultType string).	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Copy source type.	'AzureMariaDBSource' (required)

AzureMLBatchExecutionActivity

Name	Description	Value
linkedServiceName	Linked service reference.	LinkedServiceReference
policy	Activity policy.	ActivityPolicy
type	Type of activity.	'AzureMLBatchExecution' (required)
typeProperties	Azure ML Batch Execution activity properties.	AzureMLBatchExecutionActivityTypeProperties (required)

AzureMLBatchExecutionActivityTypeProperties

Name	Description	Value
globalParameters	Key,Value pairs to be passed to the Azure ML Batch Execution Service endpoint. Keys must match the names of web service parameters defined in the published Azure ML web service. Values will be passed in the GlobalParameters property of the Azure ML batch execution request.	AzureMLBatchExecutionActivityTypePropertiesGlobalParameters
webServiceInputs	Key,Value pairs, mapping the names of Azure ML endpoint's Web Service Inputs to AzureMLWebServiceFile objects specifying the input Blob locations.. This information will be passed in the WebServiceInputs property of the Azure ML batch execution request.	AzureMLBatchExecutionActivityTypePropertiesWebServiceInputs
webServiceOutputs	Key,Value pairs, mapping the names of Azure ML endpoint's Web Service Outputs to AzureMLWebServiceFile objects specifying the output Blob locations. This information will be passed in the WebServiceOutputs property of the Azure ML batch execution request.	AzureMLBatchExecutionActivityTypePropertiesWebServiceOutputs

AzureMLBatchExecutionActivityTypePropertiesGlobalParameters

Name	Description	Value

AzureMLBatchExecutionActivityTypePropertiesWebServiceInputs

Name	Description	Value

AzureMLBatchExecutionActivityTypePropertiesWebServiceOutputs

Name	Description	Value

AzureMLExecutePipelineActivity

Name	Description	Value
linkedServiceName	Linked service reference.	LinkedServiceReference
policy	Activity policy.	ActivityPolicy
type	Type of activity.	'AzureMLExecutePipeline' (required)
typeProperties	Azure ML Execute Pipeline activity properties.	AzureMLExecutePipelineActivityTypeProperties (required)

AzureMLExecutePipelineActivityTypeProperties

Name	Description	Value
continueOnStepFailure	Whether to continue execution of other steps in the PipelineRun if a step fails. This information will be passed in the continueOnStepFailure property of the published pipeline execution request. Type: boolean (or Expression with resultType boolean).	any
dataPathAssignments	Dictionary used for changing data path assignments without retraining. Values will be passed in the dataPathAssignments property of the published pipeline execution request. Type: object (or Expression with resultType object).	any
experimentName	Run history experiment name of the pipeline run. This information will be passed in the ExperimentName property of the published pipeline execution request. Type: string (or Expression with resultType string).	any
mlParentRunId	The parent Azure ML Service pipeline run id. This information will be passed in the ParentRunId property of the published pipeline execution request. Type: string (or Expression with resultType string).	any
mlPipelineEndpointId	ID of the published Azure ML pipeline endpoint. Type: string (or Expression with resultType string).	any
mlPipelineId	ID of the published Azure ML pipeline. Type: string (or Expression with resultType string).	any
mlPipelineParameters	Key,Value pairs to be passed to the published Azure ML pipeline endpoint. Keys must match the names of pipeline parameters defined in the published pipeline. Values will be passed in the ParameterAssignments property of the published pipeline execution request. Type: object with key value pairs (or Expression with resultType object).	any
version	Version of the published Azure ML pipeline endpoint. Type: string (or Expression with resultType string).	any

AzureMLUpdateResourceActivity

Name	Description	Value
linkedServiceName	Linked service reference.	LinkedServiceReference
policy	Activity policy.	ActivityPolicy
type	Type of activity.	'AzureMLUpdateResource' (required)
typeProperties	Azure ML Update Resource management activity properties.	AzureMLUpdateResourceActivityTypeProperties (required)

AzureMLUpdateResourceActivityTypeProperties

Name	Description	Value
trainedModelFilePath	The relative file path in trainedModelLinkedService to represent the .ilearner file that will be uploaded by the update operation. Type: string (or Expression with resultType string).	any (required)
trainedModelLinkedServiceName	Name of Azure Storage linked service holding the .ilearner file that will be uploaded by the update operation.	LinkedServiceReference (required)
trainedModelName	Name of the Trained Model module in the Web Service experiment to be updated. Type: string (or Expression with resultType string).	any (required)

AzureMLWebServiceFile

Name	Description	Value
filePath	The relative file path, including container name, in the Azure Blob Storage specified by the LinkedService. Type: string (or Expression with resultType string).	any (required)
linkedServiceName	Reference to an Azure Storage LinkedService, where Azure ML WebService Input/Output file located.	LinkedServiceReference (required)

AzureMySqlSink

Name	Description	Value
preCopyScript	A query to execute before starting the copy. Type: string (or Expression with resultType string).	any
type	Copy sink type.	'AzureMySqlSink' (required)

AzureMySqlSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
query	Database query. Type: string (or Expression with resultType string).	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Copy source type.	'AzureMySqlSource' (required)

AzurePostgreSqlSink

Name	Description	Value
preCopyScript	A query to execute before starting the copy. Type: string (or Expression with resultType string).	any
type	Copy sink type.	'AzurePostgreSqlSink' (required)

AzurePostgreSqlSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
query	A query to retrieve data from source. Type: string (or Expression with resultType string).	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Copy source type.	'AzurePostgreSqlSource' (required)

AzureQueueSink

Name	Description	Value
type	Copy sink type.	'AzureQueueSink' (required)

AzureSearchIndexSink

Name	Description	Value
type	Copy sink type.	'AzureSearchIndexSink' (required)
writeBehavior	Specify the write behavior when upserting documents into Azure Search Index.	'Merge' 'Upload'

AzureSqlSink

Name	Description	Value
preCopyScript	SQL pre-copy script. Type: string (or Expression with resultType string).	any
sqlWriterStoredProcedureName	SQL writer stored procedure name. Type: string (or Expression with resultType string).	any
sqlWriterTableType	SQL writer table type. Type: string (or Expression with resultType string).	any
sqlWriterUseTableLock	Whether to use table lock during bulk copy. Type: boolean (or Expression with resultType boolean).	any
storedProcedureParameters	SQL stored procedure parameters.	any
storedProcedureTableTypeParameterName	The stored procedure parameter name of the table type. Type: string (or Expression with resultType string).	any
tableOption	The option to handle sink table, such as autoCreate. For now only 'autoCreate' value is supported. Type: string (or Expression with resultType string).	any
type	Copy sink type.	'AzureSqlSink' (required)
upsertSettings	SQL upsert settings.	SqlUpsertSettings
writeBehavior	Write behavior when copying data into Azure SQL. Type: SqlWriteBehaviorEnum (or Expression with resultType SqlWriteBehaviorEnum)	any

AzureSqlSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
isolationLevel	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).	any
partitionOption	The partition mechanism that will be used for Sql read in parallel. Possible values include: "None", "PhysicalPartitionsOfTable", "DynamicRange". Type: string (or Expression with resultType string).	any
partitionSettings	The settings that will be leveraged for Sql source partitioning.	SqlPartitionSettings
produceAdditionalTypes	Which additional types to produce.	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
sqlReaderQuery	SQL reader query. Type: string (or Expression with resultType string).	any
sqlReaderStoredProcedureName	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).	any
storedProcedureParameters	Value and type setting for stored procedure parameters. Example: "{Parameter1: {value: "1", type: "int"}}".	any
type	Copy source type.	'AzureSqlSource' (required)

AzureTableSink

Name	Description	Value
azureTableDefaultPartitionKeyValue	Azure Table default partition key value. Type: string (or Expression with resultType string).	any
azureTableInsertType	Azure Table insert type. Type: string (or Expression with resultType string).	any
azureTablePartitionKeyName	Azure Table partition key name. Type: string (or Expression with resultType string).	any
azureTableRowKeyName	Azure Table row key name. Type: string (or Expression with resultType string).	any
type	Copy sink type.	'AzureTableSink' (required)

AzureTableSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
azureTableSourceIgnoreTableNotFound	Azure Table source ignore table not found. Type: boolean (or Expression with resultType boolean).	any
azureTableSourceQuery	Azure Table source query. Type: string (or Expression with resultType string).	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Copy source type.	'AzureTableSource' (required)

BigDataPoolParametrizationReference

Name	Description	Value
referenceName	Reference big data pool name. Type: string (or Expression with resultType string).	any (required)
type	Big data pool reference type.	'BigDataPoolReference' (required)

BinaryReadSettings

Name	Description	Value
compressionProperties	Compression settings.	CompressionReadSettings
type	The read setting type.	'BinaryReadSettings' (required)

BinaryReadSettings

Name	Description	Value
compressionProperties	Compression settings.	CompressionReadSettings
type	The read setting type.	string (required)

BinarySink

Name	Description	Value
storeSettings	Binary store settings.	StoreWriteSettings
type	Copy sink type.	'BinarySink' (required)

BinarySource

Name	Description	Value
formatSettings	Binary format settings.	BinaryReadSettings
storeSettings	Binary store settings.	StoreReadSettings
type	Copy source type.	'BinarySource' (required)

BlobSink

Name	Description	Value
blobWriterAddHeader	Blob writer add header. Type: boolean (or Expression with resultType boolean).	any
blobWriterDateTimeFormat	Blob writer date time format. Type: string (or Expression with resultType string).	any
blobWriterOverwriteFiles	Blob writer overwrite files. Type: boolean (or Expression with resultType boolean).	any
copyBehavior	The type of copy behavior for copy sink.	any
metadata	Specify the custom metadata to be added to sink data. Type: array of objects (or Expression with resultType array of objects).	MetadataItem[]
type	Copy sink type.	'BlobSink' (required)

BlobSource

Name	Description	Value
recursive	If true, files under the folder path will be read recursively. Default is true. Type: boolean (or Expression with resultType boolean).	any
skipHeaderLineCount	Number of header lines to skip from each blob. Type: integer (or Expression with resultType integer).	any
treatEmptyAsNull	Treat empty as null. Type: boolean (or Expression with resultType boolean).	any
type	Copy source type.	'BlobSource' (required)

CassandraSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
consistencyLevel	The consistency level specifies how many Cassandra servers must respond to a read request before returning data to the client application. Cassandra checks the specified number of Cassandra servers for data to satisfy the read request. Must be one of cassandraSourceReadConsistencyLevels. The default value is 'ONE'. It is case-insensitive.	'ALL' 'EACH_QUORUM' 'LOCAL_ONE' 'LOCAL_QUORUM' 'LOCAL_SERIAL' 'ONE' 'QUORUM' 'SERIAL' 'THREE' 'TWO'
query	Database query. Should be a SQL-92 query expression or Cassandra Query Language (CQL) command. Type: string (or Expression with resultType string).	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Copy source type.	'CassandraSource' (required)

CommonDataServiceForAppsSink

Name	Description	Value
alternateKeyName	The logical name of the alternate key which will be used when upserting records. Type: string (or Expression with resultType string).	any
ignoreNullValues	The flag indicating whether to ignore null values from input dataset (except key fields) during write operation. Default is false. Type: boolean (or Expression with resultType boolean).	any
type	Copy sink type.	'CommonDataServiceForAppsSink' (required)
writeBehavior	The write behavior for the operation.	'Upsert' (required)

CommonDataServiceForAppsSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
query	FetchXML is a proprietary query language that is used in Microsoft Common Data Service for Apps (online & on-premises). Type: string (or Expression with resultType string).	any
type	Copy source type.	'CommonDataServiceForAppsSource' (required)

CompressionReadSettings

Name	Description	Value
type	Set to 'TarGZipReadSettings' for type TarGZipReadSettings. Set to 'TarReadSettings' for type TarReadSettings. Set to 'ZipDeflateReadSettings' for type ZipDeflateReadSettings.	'TarGZipReadSettings' 'TarReadSettings' 'ZipDeflateReadSettings' (required)

ConcurSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
query	A query to retrieve data from source. Type: string (or Expression with resultType string).	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Copy source type.	'ConcurSource' (required)

ContinuationSettingsReference

Name	Description	Value
continuationTtlInMinutes	Continuation TTL in minutes.	any
customizedCheckpointKey	Customized checkpoint key.	any
idleCondition	Idle condition.	any

CopyActivity

Name	Description	Value
inputs	List of inputs for the activity.	DatasetReference[]
linkedServiceName	Linked service reference.	LinkedServiceReference
outputs	List of outputs for the activity.	DatasetReference[]
policy	Activity policy.	ActivityPolicy
type	Type of activity.	'Copy' (required)
typeProperties	Copy activity properties.	CopyActivityTypeProperties (required)

CopyActivityLogSettings

Name	Description	Value
enableReliableLogging	Specifies whether to enable reliable logging. Type: boolean (or Expression with resultType boolean).	any
logLevel	Gets or sets the log level, support: Info, Warning. Type: string (or Expression with resultType string).	any

CopyActivityTypeProperties

Name	Description	Value
dataIntegrationUnits	Maximum number of data integration units that can be used to perform this data movement. Type: integer (or Expression with resultType integer), minimum: 0.	any
enableSkipIncompatibleRow	Whether to skip incompatible row. Default value is false. Type: boolean (or Expression with resultType boolean).	any
enableStaging	Specifies whether to copy data via an interim staging. Default value is false. Type: boolean (or Expression with resultType boolean).	any
logSettings	Log settings customer needs provide when enabling log.	LogSettings
logStorageSettings	(Deprecated. Please use LogSettings) Log storage settings customer need to provide when enabling session log.	LogStorageSettings
parallelCopies	Maximum number of concurrent sessions opened on the source or sink to avoid overloading the data store. Type: integer (or Expression with resultType integer), minimum: 0.	any
preserve	Preserve rules.	any[]
preserveRules	Preserve Rules.	any[]
redirectIncompatibleRowSettings	Redirect incompatible row settings when EnableSkipIncompatibleRow is true.	RedirectIncompatibleRowSettings
sink	Copy activity sink.	CopySink (required)
skipErrorFile	Specify the fault tolerance for data consistency.	SkipErrorFile
source	Copy activity source.	CopySource (required)
stagingSettings	Specifies interim staging settings when EnableStaging is true.	StagingSettings
translator	Copy activity translator. If not specified, tabular translator is used.	any
validateDataConsistency	Whether to enable Data Consistency validation. Type: boolean (or Expression with resultType boolean).	any

CopySink

Name	Description	Value
disableMetricsCollection	If true, disable data store metrics collection. Default is false. Type: boolean (or Expression with resultType boolean).	any
maxConcurrentConnections	The maximum concurrent connection count for the sink data store. Type: integer (or Expression with resultType integer).	any
sinkRetryCount	Sink retry count. Type: integer (or Expression with resultType integer).	any
sinkRetryWait	Sink retry wait. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Set to 'AvroSink' for type AvroSink. Set to 'AzureBlobFSSink' for type AzureBlobFSSink. Set to 'AzureDataExplorerSink' for type AzureDataExplorerSink. Set to 'AzureDataLakeStoreSink' for type AzureDataLakeStoreSink. Set to 'AzureDatabricksDeltaLakeSink' for type AzureDatabricksDeltaLakeSink. Set to 'AzureMySqlSink' for type AzureMySqlSink. Set to 'AzurePostgreSqlSink' for type AzurePostgreSqlSink. Set to 'AzureQueueSink' for type AzureQueueSink. Set to 'AzureSearchIndexSink' for type AzureSearchIndexSink. Set to 'AzureSqlSink' for type AzureSqlSink. Set to 'AzureTableSink' for type AzureTableSink. Set to 'BinarySink' for type BinarySink. Set to 'BlobSink' for type BlobSink. Set to 'CommonDataServiceForAppsSink' for type CommonDataServiceForAppsSink. Set to 'CosmosDbMongoDbApiSink' for type CosmosDbMongoDbApiSink. Set to 'CosmosDbSqlApiSink' for type CosmosDbSqlApiSink. Set to 'DelimitedTextSink' for type DelimitedTextSink. Set to 'DocumentDbCollectionSink' for type DocumentDbCollectionSink. Set to 'DynamicsCrmSink' for type DynamicsCrmSink. Set to 'DynamicsSink' for type DynamicsSink. Set to 'FileSystemSink' for type FileSystemSink. Set to 'IcebergSink' for type IcebergSink. Set to 'InformixSink' for type InformixSink. Set to 'JsonSink' for type JsonSink. Set to 'LakeHouseTableSink' for type LakeHouseTableSink. Set to 'MicrosoftAccessSink' for type MicrosoftAccessSink. Set to 'MongoDbAtlasSink' for type MongoDbAtlasSink. Set to 'MongoDbV2Sink' for type MongoDbV2Sink. Set to 'OdbcSink' for type OdbcSink. Set to 'OracleSink' for type OracleSink. Set to 'OrcSink' for type OrcSink. Set to 'ParquetSink' for type ParquetSink. Set to 'RestSink' for type RestSink. Set to 'SalesforceServiceCloudSink' for type SalesforceServiceCloudSink. Set to 'SalesforceServiceCloudV2Sink' for type SalesforceServiceCloudV2Sink. Set to 'SalesforceSink' for type SalesforceSink. Set to 'SalesforceV2Sink' for type SalesforceV2Sink. Set to 'SapCloudForCustomerSink' for type SapCloudForCustomerSink. Set to 'SnowflakeSink' for type SnowflakeSink. Set to 'SnowflakeV2Sink' for type SnowflakeV2Sink. Set to 'SqlDWSink' for type SqlDWSink. Set to 'SqlMISink' for type SqlMISink. Set to 'SqlServerSink' for type SqlServerSink. Set to 'SqlSink' for type SqlSink. Set to 'WarehouseSink' for type WarehouseSink.	'AvroSink' 'AzureBlobFSSink' 'AzureDatabricksDeltaLakeSink' 'AzureDataExplorerSink' 'AzureDataLakeStoreSink' 'AzureMySqlSink' 'AzurePostgreSqlSink' 'AzureQueueSink' 'AzureSearchIndexSink' 'AzureSqlSink' 'AzureTableSink' 'BinarySink' 'BlobSink' 'CommonDataServiceForAppsSink' 'CosmosDbMongoDbApiSink' 'CosmosDbSqlApiSink' 'DelimitedTextSink' 'DocumentDbCollectionSink' 'DynamicsCrmSink' 'DynamicsSink' 'FileSystemSink' 'IcebergSink' 'InformixSink' 'JsonSink' 'LakeHouseTableSink' 'MicrosoftAccessSink' 'MongoDbAtlasSink' 'MongoDbV2Sink' 'OdbcSink' 'OracleSink' 'OrcSink' 'ParquetSink' 'RestSink' 'SalesforceServiceCloudSink' 'SalesforceServiceCloudV2Sink' 'SalesforceSink' 'SalesforceV2Sink' 'SapCloudForCustomerSink' 'SnowflakeSink' 'SnowflakeV2Sink' 'SqlDWSink' 'SqlMISink' 'SqlServerSink' 'SqlSink' 'WarehouseSink' (required)
writeBatchSize	Write batch size. Type: integer (or Expression with resultType integer), minimum: 0.	any
writeBatchTimeout	Write batch timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any

CopySource

Name	Description	Value
disableMetricsCollection	If true, disable data store metrics collection. Default is false. Type: boolean (or Expression with resultType boolean).	any
maxConcurrentConnections	The maximum concurrent connection count for the source data store. Type: integer (or Expression with resultType integer).	any
sourceRetryCount	Source retry count. Type: integer (or Expression with resultType integer).	any
sourceRetryWait	Source retry wait. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Set to 'AmazonMWSSource' for type AmazonMWSSource. Set to 'AmazonRdsForOracleSource' for type AmazonRdsForOracleSource. Set to 'AmazonRdsForSqlServerSource' for type AmazonRdsForSqlServerSource. Set to 'AmazonRedshiftSource' for type AmazonRedshiftSource. Set to 'AvroSource' for type AvroSource. Set to 'AzureBlobFSSource' for type AzureBlobFSSource. Set to 'AzureDataExplorerSource' for type AzureDataExplorerSource. Set to 'AzureDataLakeStoreSource' for type AzureDataLakeStoreSource. Set to 'AzureDatabricksDeltaLakeSource' for type AzureDatabricksDeltaLakeSource. Set to 'AzureMariaDBSource' for type AzureMariaDBSource. Set to 'AzureMySqlSource' for type AzureMySqlSource. Set to 'AzurePostgreSqlSource' for type AzurePostgreSqlSource. Set to 'AzureSqlSource' for type AzureSqlSource. Set to 'AzureTableSource' for type AzureTableSource. Set to 'BinarySource' for type BinarySource. Set to 'BlobSource' for type BlobSource. Set to 'CassandraSource' for type CassandraSource. Set to 'CommonDataServiceForAppsSource' for type CommonDataServiceForAppsSource. Set to 'ConcurSource' for type ConcurSource. Set to 'CosmosDbMongoDbApiSource' for type CosmosDbMongoDbApiSource. Set to 'CosmosDbSqlApiSource' for type CosmosDbSqlApiSource. Set to 'CouchbaseSource' for type CouchbaseSource. Set to 'Db2Source' for type Db2Source. Set to 'DelimitedTextSource' for type DelimitedTextSource. Set to 'DocumentDbCollectionSource' for type DocumentDbCollectionSource. Set to 'DrillSource' for type DrillSource. Set to 'DynamicsAXSource' for type DynamicsAXSource. Set to 'DynamicsCrmSource' for type DynamicsCrmSource. Set to 'DynamicsSource' for type DynamicsSource. Set to 'EloquaSource' for type EloquaSource. Set to 'ExcelSource' for type ExcelSource. Set to 'FileSystemSource' for type FileSystemSource. Set to 'GoogleAdWordsSource' for type GoogleAdWordsSource. Set to 'GoogleBigQuerySource' for type GoogleBigQuerySource. Set to 'GoogleBigQueryV2Source' for type GoogleBigQueryV2Source. Set to 'GreenplumSource' for type GreenplumSource. Set to 'HBaseSource' for type HBaseSource. Set to 'HdfsSource' for type HdfsSource. Set to 'HiveSource' for type HiveSource. Set to 'HttpSource' for type HttpSource. Set to 'HubspotSource' for type HubspotSource. Set to 'ImpalaSource' for type ImpalaSource. Set to 'InformixSource' for type InformixSource. Set to 'JiraSource' for type JiraSource. Set to 'JsonSource' for type JsonSource. Set to 'LakeHouseTableSource' for type LakeHouseTableSource. Set to 'MagentoSource' for type MagentoSource. Set to 'MariaDBSource' for type MariaDBSource. Set to 'MarketoSource' for type MarketoSource. Set to 'MicrosoftAccessSource' for type MicrosoftAccessSource. Set to 'MongoDbAtlasSource' for type MongoDbAtlasSource. Set to 'MongoDbSource' for type MongoDbSource. Set to 'MongoDbV2Source' for type MongoDbV2Source. Set to 'MySqlSource' for type MySqlSource. Set to 'NetezzaSource' for type NetezzaSource. Set to 'ODataSource' for type ODataSource. Set to 'OdbcSource' for type OdbcSource. Set to 'Office365Source' for type Office365Source. Set to 'OracleServiceCloudSource' for type OracleServiceCloudSource. Set to 'OracleSource' for type OracleSource. Set to 'OrcSource' for type OrcSource. Set to 'ParquetSource' for type ParquetSource. Set to 'PaypalSource' for type PaypalSource. Set to 'PhoenixSource' for type PhoenixSource. Set to 'PostgreSqlSource' for type PostgreSqlSource. Set to 'PostgreSqlV2Source' for type PostgreSqlV2Source. Set to 'PrestoSource' for type PrestoSource. Set to 'QuickBooksSource' for type QuickBooksSource. Set to 'RelationalSource' for type RelationalSource. Set to 'ResponsysSource' for type ResponsysSource. Set to 'RestSource' for type RestSource. Set to 'SalesforceMarketingCloudSource' for type SalesforceMarketingCloudSource. Set to 'SalesforceServiceCloudSource' for type SalesforceServiceCloudSource. Set to 'SalesforceServiceCloudV2Source' for type SalesforceServiceCloudV2Source. Set to 'SalesforceSource' for type SalesforceSource. Set to 'SalesforceV2Source' for type SalesforceV2Source. Set to 'SapBwSource' for type SapBwSource. Set to 'SapCloudForCustomerSource' for type SapCloudForCustomerSource. Set to 'SapEccSource' for type SapEccSource. Set to 'SapHanaSource' for type SapHanaSource. Set to 'SapOdpSource' for type SapOdpSource. Set to 'SapOpenHubSource' for type SapOpenHubSource. Set to 'SapTableSource' for type SapTableSource. Set to 'ServiceNowSource' for type ServiceNowSource. Set to 'ServiceNowV2Source' for type ServiceNowV2Source. Set to 'SharePointOnlineListSource' for type SharePointOnlineListSource. Set to 'ShopifySource' for type ShopifySource. Set to 'SnowflakeSource' for type SnowflakeSource. Set to 'SnowflakeV2Source' for type SnowflakeV2Source. Set to 'SparkSource' for type SparkSource. Set to 'SqlDWSource' for type SqlDWSource. Set to 'SqlMISource' for type SqlMISource. Set to 'SqlServerSource' for type SqlServerSource. Set to 'SqlSource' for type SqlSource. Set to 'SquareSource' for type SquareSource. Set to 'SybaseSource' for type SybaseSource. Set to 'TeradataSource' for type TeradataSource. Set to 'VerticaSource' for type VerticaSource. Set to 'WarehouseSource' for type WarehouseSource. Set to 'XeroSource' for type XeroSource. Set to 'ZohoSource' for type ZohoSource. Set to 'WebSource' for type WebSource. Set to 'XmlSource' for type XmlSource.	'AmazonMWSSource' 'AmazonRdsForOracleSource' 'AmazonRdsForSqlServerSource' 'AmazonRedshiftSource' 'AvroSource' 'AzureBlobFSSource' 'AzureDatabricksDeltaLakeSource' 'AzureDataExplorerSource' 'AzureDataLakeStoreSource' 'AzureMariaDBSource' 'AzureMySqlSource' 'AzurePostgreSqlSource' 'AzureSqlSource' 'AzureTableSource' 'BinarySource' 'BlobSource' 'CassandraSource' 'CommonDataServiceForAppsSource' 'ConcurSource' 'CosmosDbMongoDbApiSource' 'CosmosDbSqlApiSource' 'CouchbaseSource' 'Db2Source' 'DelimitedTextSource' 'DocumentDbCollectionSource' 'DrillSource' 'DynamicsAXSource' 'DynamicsCrmSource' 'DynamicsSource' 'EloquaSource' 'ExcelSource' 'FileSystemSource' 'GoogleAdWordsSource' 'GoogleBigQuerySource' 'GoogleBigQueryV2Source' 'GreenplumSource' 'HBaseSource' 'HdfsSource' 'HiveSource' 'HttpSource' 'HubspotSource' 'ImpalaSource' 'InformixSource' 'JiraSource' 'JsonSource' 'LakeHouseTableSource' 'MagentoSource' 'MariaDBSource' 'MarketoSource' 'MicrosoftAccessSource' 'MongoDbAtlasSource' 'MongoDbSource' 'MongoDbV2Source' 'MySqlSource' 'NetezzaSource' 'ODataSource' 'OdbcSource' 'Office365Source' 'OracleServiceCloudSource' 'OracleSource' 'OrcSource' 'ParquetSource' 'PaypalSource' 'PhoenixSource' 'PostgreSqlSource' 'PostgreSqlV2Source' 'PrestoSource' 'QuickBooksSource' 'RelationalSource' 'ResponsysSource' 'RestSource' 'SalesforceMarketingCloudSource' 'SalesforceServiceCloudSource' 'SalesforceServiceCloudV2Source' 'SalesforceSource' 'SalesforceV2Source' 'SapBwSource' 'SapCloudForCustomerSource' 'SapEccSource' 'SapHanaSource' 'SapOdpSource' 'SapOpenHubSource' 'SapTableSource' 'ServiceNowSource' 'ServiceNowV2Source' 'SharePointOnlineListSource' 'ShopifySource' 'SnowflakeSource' 'SnowflakeV2Source' 'SparkSource' 'SqlDWSource' 'SqlMISource' 'SqlServerSource' 'SqlSource' 'SquareSource' 'SybaseSource' 'TeradataSource' 'VerticaSource' 'WarehouseSource' 'WebSource' 'XeroSource' 'XmlSource' 'ZohoSource' (required)

CosmosDbMongoDbApiSink

Name	Description	Value
type	Copy sink type.	'CosmosDbMongoDbApiSink' (required)
writeBehavior	Specifies whether the document with same key to be overwritten (upsert) rather than throw exception (insert). The default value is "insert". Type: string (or Expression with resultType string). Type: string (or Expression with resultType string).	any

CosmosDbMongoDbApiSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
batchSize	Specifies the number of documents to return in each batch of the response from MongoDB instance. In most cases, modifying the batch size will not affect the user or the application. This property's main purpose is to avoid hit the limitation of response size. Type: integer (or Expression with resultType integer).	any
cursorMethods	Cursor methods for Mongodb query.	MongoDbCursorMethodsProperties
filter	Specifies selection filter using query operators. To return all documents in a collection, omit this parameter or pass an empty document ({}). Type: string (or Expression with resultType string).	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Copy source type.	'CosmosDbMongoDbApiSource' (required)

CosmosDbSqlApiSink

Name	Description	Value
type	Copy sink type.	'CosmosDbSqlApiSink' (required)
writeBehavior	Describes how to write data to Azure Cosmos DB. Type: string (or Expression with resultType string). Allowed values: insert and upsert.	any

CosmosDbSqlApiSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
detectDatetime	Whether detect primitive values as datetime values. Type: boolean (or Expression with resultType boolean).	any
pageSize	Page size of the result. Type: integer (or Expression with resultType integer).	any
preferredRegions	Preferred regions. Type: array of strings (or Expression with resultType array of strings).	any
query	SQL API query. Type: string (or Expression with resultType string).	any
type	Copy source type.	'CosmosDbSqlApiSource' (required)

CouchbaseSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
query	A query to retrieve data from source. Type: string (or Expression with resultType string).	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Copy source type.	'CouchbaseSource' (required)

CredentialReference

Name	Description	Value
referenceName	Reference credential name.	string (required)
type	Credential reference type.	'CredentialReference' (required)

CustomActivity

Name	Description	Value
linkedServiceName	Linked service reference.	LinkedServiceReference
policy	Activity policy.	ActivityPolicy
type	Type of activity.	'Custom' (required)
typeProperties	Custom activity properties.	CustomActivityTypeProperties (required)

CustomActivityReferenceObject

Name	Description	Value
datasets	Dataset references.	DatasetReference[]
linkedServices	Linked service references.	LinkedServiceReference[]

CustomActivityTypeProperties

Name	Description	Value
autoUserSpecification	Elevation level and scope for the user, default is nonadmin task. Type: string (or Expression with resultType double).	any
command	Command for custom activity Type: string (or Expression with resultType string).	any (required)
extendedProperties	User defined property bag. There is no restriction on the keys or values that can be used. The user specified custom activity has the full responsibility to consume and interpret the content defined.	CustomActivityTypePropertiesExtendedProperties
folderPath	Folder path for resource files Type: string (or Expression with resultType string).	any
referenceObjects	Reference objects	CustomActivityReferenceObject
resourceLinkedService	Resource linked service reference.	LinkedServiceReference
retentionTimeInDays	The retention time for the files submitted for custom activity. Type: double (or Expression with resultType double).	any

CustomActivityTypePropertiesExtendedProperties

Name	Description	Value

DatabricksNotebookActivity

Name	Description	Value
linkedServiceName	Linked service reference.	LinkedServiceReference
policy	Activity policy.	ActivityPolicy
type	Type of activity.	'DatabricksNotebook' (required)
typeProperties	Databricks Notebook activity properties.	DatabricksNotebookActivityTypeProperties (required)

DatabricksNotebookActivityTypeProperties

Name	Description	Value
baseParameters	Base parameters to be used for each run of this job.If the notebook takes a parameter that is not specified, the default value from the notebook will be used.	DatabricksNotebookActivityTypePropertiesBaseParameters
libraries	A list of libraries to be installed on the cluster that will execute the job.	DatabricksNotebookActivityTypePropertiesLibrariesItem[]
notebookPath	The absolute path of the notebook to be run in the Databricks Workspace. This path must begin with a slash. Type: string (or Expression with resultType string).	any (required)

DatabricksNotebookActivityTypePropertiesBaseParameters

Name	Description	Value

DatabricksNotebookActivityTypePropertiesLibrariesItem

Name	Description	Value

DatabricksSparkJarActivity

Name	Description	Value
linkedServiceName	Linked service reference.	LinkedServiceReference
policy	Activity policy.	ActivityPolicy
type	Type of activity.	'DatabricksSparkJar' (required)
typeProperties	Databricks SparkJar activity properties.	DatabricksSparkJarActivityTypeProperties (required)

DatabricksSparkJarActivityTypeProperties

Name	Description	Value
libraries	A list of libraries to be installed on the cluster that will execute the job.	DatabricksSparkJarActivityTypePropertiesLibrariesItem[]
mainClassName	The full name of the class containing the main method to be executed. This class must be contained in a JAR provided as a library. Type: string (or Expression with resultType string).	any (required)
parameters	Parameters that will be passed to the main method.	any[]

DatabricksSparkJarActivityTypePropertiesLibrariesItem

Name	Description	Value

DatabricksSparkPythonActivity

Name	Description	Value
linkedServiceName	Linked service reference.	LinkedServiceReference
policy	Activity policy.	ActivityPolicy
type	Type of activity.	'DatabricksSparkPython' (required)
typeProperties	Databricks SparkPython activity properties.	DatabricksSparkPythonActivityTypeProperties (required)

DatabricksSparkPythonActivityTypeProperties

Name	Description	Value
libraries	A list of libraries to be installed on the cluster that will execute the job.	DatabricksSparkPythonActivityTypePropertiesLibrariesItem[]
parameters	Command line parameters that will be passed to the Python file.	any[]
pythonFile	The URI of the Python file to be executed. DBFS paths are supported. Type: string (or Expression with resultType string).	any (required)

DatabricksSparkPythonActivityTypePropertiesLibrariesItem

Name	Description	Value

DataFlowReference

Name	Description	Value
datasetParameters	Reference data flow parameters from dataset.	any
parameters	Data flow parameters	ParameterValueSpecification
referenceName	Reference data flow name.	string (required)
type	Data flow reference type.	'DataFlowReference' (required)

DataFlowStagingInfo

Name	Description	Value
folderPath	Folder path for staging blob. Type: string (or Expression with resultType string)	any
linkedService	Staging linked service reference.	LinkedServiceReference

DataLakeAnalyticsUsqlActivity

Name	Description	Value
linkedServiceName	Linked service reference.	LinkedServiceReference
policy	Activity policy.	ActivityPolicy
type	Type of activity.	'DataLakeAnalyticsU-SQL' (required)
typeProperties	Data Lake Analytics U-SQL activity properties.	DataLakeAnalyticsUsqlActivityTypeProperties (required)

DataLakeAnalyticsUsqlActivityTypeProperties

Name	Description	Value
compilationMode	Compilation mode of U-SQL. Must be one of these values : Semantic, Full and SingleBox. Type: string (or Expression with resultType string).	any
degreeOfParallelism	The maximum number of nodes simultaneously used to run the job. Default value is 1. Type: integer (or Expression with resultType integer), minimum: 1.	any
parameters	Parameters for U-SQL job request.	DataLakeAnalyticsUsqlActivityTypePropertiesParameters
priority	Determines which jobs out of all that are queued should be selected to run first. The lower the number, the higher the priority. Default value is 1000. Type: integer (or Expression with resultType integer), minimum: 1.	any
runtimeVersion	Runtime version of the U-SQL engine to use. Type: string (or Expression with resultType string).	any
scriptLinkedService	Script linked service reference.	LinkedServiceReference (required)
scriptPath	Case-sensitive path to folder that contains the U-SQL script. Type: string (or Expression with resultType string).	any (required)

DataLakeAnalyticsUsqlActivityTypePropertiesParameters

Name	Description	Value

DatasetReference

Name	Description	Value
parameters	Arguments for dataset.	ParameterValueSpecification
referenceName	Reference dataset name.	string (required)
type	Dataset reference type.	'DatasetReference' (required)

Db2Source

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
query	Database query. Type: string (or Expression with resultType string).	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Copy source type.	'Db2Source' (required)

DeleteActivity

Name	Description	Value
linkedServiceName	Linked service reference.	LinkedServiceReference
policy	Activity policy.	ActivityPolicy
type	Type of activity.	'Delete' (required)
typeProperties	Delete activity properties.	DeleteActivityTypeProperties (required)

DeleteActivityTypeProperties

Name	Description	Value
dataset	Delete activity dataset reference.	DatasetReference (required)
enableLogging	Whether to record detailed logs of delete-activity execution. Default value is false. Type: boolean (or Expression with resultType boolean).	any
logStorageSettings	Log storage settings customer need to provide when enableLogging is true.	LogStorageSettings
maxConcurrentConnections	The max concurrent connections to connect data source at the same time.	int Constraints: Min value = 1
recursive	If true, files or sub-folders under current folder path will be deleted recursively. Default is false. Type: boolean (or Expression with resultType boolean).	any
storeSettings	Delete activity store settings.	StoreReadSettings

DelimitedTextReadSettings

Name	Description	Value
compressionProperties	Compression settings.	CompressionReadSettings
skipLineCount	Indicates the number of non-empty rows to skip when reading data from input files. Type: integer (or Expression with resultType integer).	any
type	The read setting type.	'DelimitedTextReadSettings' (required)

DelimitedTextReadSettings

Name	Description	Value
compressionProperties	Compression settings.	CompressionReadSettings
skipLineCount	Indicates the number of non-empty rows to skip when reading data from input files. Type: integer (or Expression with resultType integer).	any
type	The read setting type.	string (required)

DelimitedTextSink

Name	Description	Value
formatSettings	DelimitedText format settings.	DelimitedTextWriteSettings
storeSettings	DelimitedText store settings.	StoreWriteSettings
type	Copy sink type.	'DelimitedTextSink' (required)

DelimitedTextSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
formatSettings	DelimitedText format settings.	DelimitedTextReadSettings
storeSettings	DelimitedText store settings.	StoreReadSettings
type	Copy source type.	'DelimitedTextSource' (required)

DelimitedTextWriteSettings

Name	Description	Value
fileExtension	The file extension used to create the files. Type: string (or Expression with resultType string).	any (required)
fileNamePrefix	Specifies the file name pattern <fileNamePrefix>_<fileIndex>.<fileExtension> when copy from non-file based store without partitionOptions. Type: string (or Expression with resultType string).	any
maxRowsPerFile	Limit the written file's row count to be smaller than or equal to the specified count. Type: integer (or Expression with resultType integer).	any
quoteAllText	Indicates whether string values should always be enclosed with quotes. Type: boolean (or Expression with resultType boolean).	any
type	The write setting type.	string (required)

DistcpSettings

Name	Description	Value
distcpOptions	Specifies the Distcp options. Type: string (or Expression with resultType string).	any
resourceManagerEndpoint	Specifies the Yarn ResourceManager endpoint. Type: string (or Expression with resultType string).	any (required)
tempScriptPath	Specifies an existing folder path which will be used to store temp Distcp command script. The script file is generated by ADF and will be removed after Copy job finished. Type: string (or Expression with resultType string).	any (required)

DocumentDbCollectionSink

Name	Description	Value
nestingSeparator	Nested properties separator. Default is . (dot). Type: string (or Expression with resultType string).	any
type	Copy sink type.	'DocumentDbCollectionSink' (required)
writeBehavior	Describes how to write data to Azure Cosmos DB. Type: string (or Expression with resultType string). Allowed values: insert and upsert.	any

DocumentDbCollectionSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
nestingSeparator	Nested properties separator. Type: string (or Expression with resultType string).	any
query	Documents query. Type: string (or Expression with resultType string).	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Copy source type.	'DocumentDbCollectionSource' (required)

DrillSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
query	A query to retrieve data from source. Type: string (or Expression with resultType string).	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Copy source type.	'DrillSource' (required)

DWCopyCommandDefaultValue

Name	Description	Value
columnName	Column name. Type: object (or Expression with resultType string).	any
defaultValue	The default value of the column. Type: object (or Expression with resultType string).	any

DWCopyCommandSettings

Name	Description	Value
additionalOptions	Additional options directly passed to SQL DW in Copy Command. Type: key value pairs (value should be string type) (or Expression with resultType object). Example: "additionalOptions": { "MAXERRORS": "1000", "DATEFORMAT": "'ymd'" }	DWCopyCommandSettingsAdditionalOptions
defaultValues	Specifies the default values for each target column in SQL DW. The default values in the property overwrite the DEFAULT constraint set in the DB, and identity column cannot have a default value. Type: array of objects (or Expression with resultType array of objects).	DWCopyCommandDefaultValue[]

DWCopyCommandSettingsAdditionalOptions

Name	Description	Value

DynamicsAXSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
httpRequestTimeout	The timeout (TimeSpan) to get an HTTP response. It is the timeout to get a response, not the timeout to read response data. Default value: 00:05:00. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
query	A query to retrieve data from source. Type: string (or Expression with resultType string).	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Copy source type.	'DynamicsAXSource' (required)

DynamicsCrmSink

Name	Description	Value
alternateKeyName	The logical name of the alternate key which will be used when upserting records. Type: string (or Expression with resultType string).	any
ignoreNullValues	The flag indicating whether to ignore null values from input dataset (except key fields) during write operation. Default is false. Type: boolean (or Expression with resultType boolean).	any
type	Copy sink type.	'DynamicsCrmSink' (required)
writeBehavior	The write behavior for the operation.	'Upsert' (required)

DynamicsCrmSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
query	FetchXML is a proprietary query language that is used in Microsoft Dynamics CRM (online & on-premises). Type: string (or Expression with resultType string).	any
type	Copy source type.	'DynamicsCrmSource' (required)

DynamicsSink

Name	Description	Value
alternateKeyName	The logical name of the alternate key which will be used when upserting records. Type: string (or Expression with resultType string).	any
ignoreNullValues	The flag indicating whether ignore null values from input dataset (except key fields) during write operation. Default is false. Type: boolean (or Expression with resultType boolean).	any
type	Copy sink type.	'DynamicsSink' (required)
writeBehavior	The write behavior for the operation.	'Upsert' (required)

DynamicsSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
query	FetchXML is a proprietary query language that is used in Microsoft Dynamics (online & on-premises). Type: string (or Expression with resultType string).	any
type	Copy source type.	'DynamicsSource' (required)

EloquaSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
query	A query to retrieve data from source. Type: string (or Expression with resultType string).	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Copy source type.	'EloquaSource' (required)

ExcelSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
storeSettings	Excel store settings.	StoreReadSettings
type	Copy source type.	'ExcelSource' (required)

ExecuteDataFlowActivity

Name	Description	Value
linkedServiceName	Linked service reference.	LinkedServiceReference
policy	Activity policy.	ActivityPolicy
type	Type of activity.	'ExecuteDataFlow' (required)
typeProperties	Execute data flow activity properties.	ExecuteDataFlowActivityTypeProperties (required)

ExecuteDataFlowActivityTypeProperties

Name	Description	Value
compute	Compute properties for data flow activity.	ExecuteDataFlowActivityTypePropertiesCompute
continuationSettings	Continuation settings for execute data flow activity.	ContinuationSettingsReference
continueOnError	Continue on error setting used for data flow execution. Enables processing to continue if a sink fails. Type: boolean (or Expression with resultType boolean)	any
dataFlow	Data flow reference.	DataFlowReference (required)
integrationRuntime	The integration runtime reference.	IntegrationRuntimeReference
runConcurrently	Concurrent run setting used for data flow execution. Allows sinks with the same save order to be processed concurrently. Type: boolean (or Expression with resultType boolean)	any
sourceStagingConcurrency	Specify number of parallel staging for sources applicable to the sink. Type: integer (or Expression with resultType integer)	any
staging	Staging info for execute data flow activity.	DataFlowStagingInfo
traceLevel	Trace level setting used for data flow monitoring output. Supported values are: 'coarse', 'fine', and 'none'. Type: string (or Expression with resultType string)	any

ExecuteDataFlowActivityTypePropertiesCompute

Name	Description	Value
computeType	Compute type of the cluster which will execute data flow job. Possible values include: 'General', 'MemoryOptimized', 'ComputeOptimized'. Type: string (or Expression with resultType string)	any
coreCount	Core count of the cluster which will execute data flow job. Supported values are: 8, 16, 32, 48, 80, 144 and 272. Type: integer (or Expression with resultType integer)	any

ExecutePipelineActivity

Name	Description	Value
policy	Execute pipeline activity policy.	ExecutePipelineActivityPolicy
type	Type of activity.	'ExecutePipeline' (required)
typeProperties	Execute pipeline activity properties.	ExecutePipelineActivityTypeProperties (required)

ExecutePipelineActivityPolicy

Name	Description	Value
secureInput	When set to true, Input from activity is considered as secure and will not be logged to monitoring.	bool

ExecutePipelineActivityTypeProperties

Name	Description	Value
parameters	Pipeline parameters.	ParameterValueSpecification
pipeline	Pipeline reference.	PipelineReference (required)
waitOnCompletion	Defines whether activity execution will wait for the dependent pipeline execution to finish. Default is false.	bool

ExecutePowerQueryActivityTypeProperties

Name	Description	Value
compute	Compute properties for data flow activity.	ExecuteDataFlowActivityTypePropertiesCompute
continuationSettings	Continuation settings for execute data flow activity.	ContinuationSettingsReference
continueOnError	Continue on error setting used for data flow execution. Enables processing to continue if a sink fails. Type: boolean (or Expression with resultType boolean)	any
dataFlow	Data flow reference.	DataFlowReference (required)
integrationRuntime	The integration runtime reference.	IntegrationRuntimeReference
queries	List of mapping for Power Query mashup query to sink dataset(s).	PowerQuerySinkMapping[]
runConcurrently	Concurrent run setting used for data flow execution. Allows sinks with the same save order to be processed concurrently. Type: boolean (or Expression with resultType boolean)	any
sinks	(Deprecated. Please use Queries). List of Power Query activity sinks mapped to a queryName.	ExecutePowerQueryActivityTypePropertiesSinks
sourceStagingConcurrency	Specify number of parallel staging for sources applicable to the sink. Type: integer (or Expression with resultType integer)	any
staging	Staging info for execute data flow activity.	DataFlowStagingInfo
traceLevel	Trace level setting used for data flow monitoring output. Supported values are: 'coarse', 'fine', and 'none'. Type: string (or Expression with resultType string)	any

ExecutePowerQueryActivityTypePropertiesSinks

Name	Description	Value

ExecuteSsisPackageActivity

Name	Description	Value
linkedServiceName	Linked service reference.	LinkedServiceReference
policy	Activity policy.	ActivityPolicy
type	Type of activity.	'ExecuteSSISPackage' (required)
typeProperties	Execute SSIS package activity properties.	ExecuteSsisPackageActivityTypeProperties (required)

ExecuteSsisPackageActivityTypeProperties

Name	Description	Value
connectVia	The integration runtime reference.	IntegrationRuntimeReference (required)
environmentPath	The environment path to execute the SSIS package. Type: string (or Expression with resultType string).	any
executionCredential	The package execution credential.	SsisExecutionCredential
loggingLevel	The logging level of SSIS package execution. Type: string (or Expression with resultType string).	any
logLocation	SSIS package execution log location.	SsisLogLocation
packageConnectionManagers	The package level connection managers to execute the SSIS package.	ExecuteSsisPackageActivityTypePropertiesPackageConnectionManagers
packageLocation	SSIS package location.	SsisPackageLocation (required)
packageParameters	The package level parameters to execute the SSIS package.	ExecuteSsisPackageActivityTypePropertiesPackageParameters
projectConnectionManagers	The project level connection managers to execute the SSIS package.	ExecuteSsisPackageActivityTypePropertiesProjectConnectionManagers
projectParameters	The project level parameters to execute the SSIS package.	ExecuteSsisPackageActivityTypePropertiesProjectParameters
propertyOverrides	The property overrides to execute the SSIS package.	ExecuteSsisPackageActivityTypePropertiesPropertyOverrides
runtime	Specifies the runtime to execute SSIS package. The value should be "x86" or "x64". Type: string (or Expression with resultType string).	any

ExecuteSsisPackageActivityTypePropertiesPackageConnectionManagers

Name	Description	Value

ExecuteSsisPackageActivityTypePropertiesPackageParameters

Name	Description	Value

ExecuteSsisPackageActivityTypePropertiesProjectConnectionManagers

Name	Description	Value

ExecuteSsisPackageActivityTypePropertiesProjectParameters

Name	Description	Value

ExecuteSsisPackageActivityTypePropertiesPropertyOverrides

Name	Description	Value

ExecuteWranglingDataflowActivity

Name	Description	Value
policy	Activity policy.	ActivityPolicy
type	Type of activity.	'ExecuteWranglingDataflow' (required)
typeProperties	Execute power query activity properties.	ExecutePowerQueryActivityTypeProperties (required)

Expression

Name	Description	Value
type	Expression type.	'Expression' (required)
value	Expression value.	string (required)

ExpressionV2

Name	Description	Value
operands	List of nested expressions.	ExpressionV2[]
operators	Expression operator value Type: list of strings.	string[]
type	Type of expressions supported by the system. Type: string.	'Binary' 'Constant' 'Field' 'NAry' 'Unary'
value	Value for Constant/Field Type: string.	string

FailActivity

Name	Description	Value
type	Type of activity.	'Fail' (required)
typeProperties	Fail activity properties.	FailActivityTypeProperties (required)

FailActivityTypeProperties

Name	Description	Value
errorCode	The error code that categorizes the error type of the Fail activity. It can be dynamic content that's evaluated to a non empty/blank string at runtime. Type: string (or Expression with resultType string).	any (required)
message	The error message that surfaced in the Fail activity. It can be dynamic content that's evaluated to a non empty/blank string at runtime. Type: string (or Expression with resultType string).	any (required)

FileServerReadSettings

Name	Description	Value
deleteFilesAfterCompletion	Indicates whether the source files need to be deleted after copy completion. Default is false. Type: boolean (or Expression with resultType boolean).	any
enablePartitionDiscovery	Indicates whether to enable partition discovery. Type: boolean (or Expression with resultType boolean).	any
fileFilter	Specify a filter to be used to select a subset of files in the folderPath rather than all files. Type: string (or Expression with resultType string).	any
fileListPath	Point to a text file that lists each file (relative path to the path configured in the dataset) that you want to copy. Type: string (or Expression with resultType string).	any
modifiedDatetimeEnd	The end of file's modified datetime. Type: string (or Expression with resultType string).	any
modifiedDatetimeStart	The start of file's modified datetime. Type: string (or Expression with resultType string).	any
partitionRootPath	Specify the root path where partition discovery starts from. Type: string (or Expression with resultType string).	any
recursive	If true, files under the folder path will be read recursively. Default is true. Type: boolean (or Expression with resultType boolean).	any
type	The read setting type.	'FileServerReadSettings' (required)
wildcardFileName	FileServer wildcardFileName. Type: string (or Expression with resultType string).	any
wildcardFolderPath	FileServer wildcardFolderPath. Type: string (or Expression with resultType string).	any

FileServerWriteSettings

Name	Description	Value
type	The write setting type.	'FileServerWriteSettings' (required)

FileSystemSink

Name	Description	Value
copyBehavior	The type of copy behavior for copy sink.	any
type	Copy sink type.	'FileSystemSink' (required)

FileSystemSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
recursive	If true, files under the folder path will be read recursively. Default is true. Type: boolean (or Expression with resultType boolean).	any
type	Copy source type.	'FileSystemSource' (required)

FilterActivity

Name	Description	Value
type	Type of activity.	'Filter' (required)
typeProperties	Filter activity properties.	FilterActivityTypeProperties (required)

FilterActivityTypeProperties

Name	Description	Value
condition	Condition to be used for filtering the input.	Expression (required)
items	Input array on which filter should be applied.	Expression (required)

ForEachActivity

Name	Description	Value
type	Type of activity.	'ForEach' (required)
typeProperties	ForEach activity properties.	ForEachActivityTypeProperties (required)

ForEachActivityTypeProperties

Name	Description	Value
activities	List of activities to execute .	Activity[] (required)
batchCount	Batch count to be used for controlling the number of parallel execution (when isSequential is set to false).	int Constraints: Max value = 50
isSequential	Should the loop be executed in sequence or in parallel (max 50)	bool
items	Collection to iterate.	Expression (required)

FormatReadSettings

Name	Description	Value
type	Set to 'BinaryReadSettings' for type BinaryReadSettings. Set to 'DelimitedTextReadSettings' for type DelimitedTextReadSettings. Set to 'JsonReadSettings' for type JsonReadSettings. Set to 'ParquetReadSettings' for type ParquetReadSettings. Set to 'XmlReadSettings' for type XmlReadSettings.	'BinaryReadSettings' 'DelimitedTextReadSettings' 'JsonReadSettings' 'ParquetReadSettings' 'XmlReadSettings' (required)

FtpReadSettings

Name	Description	Value
deleteFilesAfterCompletion	Indicates whether the source files need to be deleted after copy completion. Default is false. Type: boolean (or Expression with resultType boolean).	any
disableChunking	If true, disable parallel reading within each file. Default is false. Type: boolean (or Expression with resultType boolean).	any
enablePartitionDiscovery	Indicates whether to enable partition discovery. Type: boolean (or Expression with resultType boolean).	any
fileListPath	Point to a text file that lists each file (relative path to the path configured in the dataset) that you want to copy. Type: string (or Expression with resultType string).	any
partitionRootPath	Specify the root path where partition discovery starts from. Type: string (or Expression with resultType string).	any
recursive	If true, files under the folder path will be read recursively. Default is true. Type: boolean (or Expression with resultType boolean).	any
type	The read setting type.	'FtpReadSettings' (required)
useBinaryTransfer	Specify whether to use binary transfer mode for FTP stores. Type: boolean (or Expression with resultType boolean).	any
wildcardFileName	Ftp wildcardFileName. Type: string (or Expression with resultType string).	any
wildcardFolderPath	Ftp wildcardFolderPath. Type: string (or Expression with resultType string).	any

GetMetadataActivity

Name	Description	Value
linkedServiceName	Linked service reference.	LinkedServiceReference
policy	Activity policy.	ActivityPolicy
type	Type of activity.	'GetMetadata' (required)
typeProperties	GetMetadata activity properties.	GetMetadataActivityTypeProperties (required)

GetMetadataActivityTypeProperties

Name	Description	Value
dataset	GetMetadata activity dataset reference.	DatasetReference (required)
fieldList	Fields of metadata to get from dataset.	any[]
formatSettings	GetMetadata activity format settings.	FormatReadSettings
storeSettings	GetMetadata activity store settings.	StoreReadSettings

GoogleAdWordsSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
query	A query to retrieve data from source. Type: string (or Expression with resultType string).	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Copy source type.	'GoogleAdWordsSource' (required)

GoogleBigQuerySource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
query	A query to retrieve data from source. Type: string (or Expression with resultType string).	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Copy source type.	'GoogleBigQuerySource' (required)

GoogleBigQueryV2Source

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
query	A query to retrieve data from source. Type: string (or Expression with resultType string).	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Copy source type.	'GoogleBigQueryV2Source' (required)

GoogleCloudStorageReadSettings

Name	Description	Value
deleteFilesAfterCompletion	Indicates whether the source files need to be deleted after copy completion. Default is false. Type: boolean (or Expression with resultType boolean).	any
enablePartitionDiscovery	Indicates whether to enable partition discovery. Type: boolean (or Expression with resultType boolean).	any
fileListPath	Point to a text file that lists each file (relative path to the path configured in the dataset) that you want to copy. Type: string (or Expression with resultType string).	any
modifiedDatetimeEnd	The end of file's modified datetime. Type: string (or Expression with resultType string).	any
modifiedDatetimeStart	The start of file's modified datetime. Type: string (or Expression with resultType string).	any
partitionRootPath	Specify the root path where partition discovery starts from. Type: string (or Expression with resultType string).	any
prefix	The prefix filter for the Google Cloud Storage object name. Type: string (or Expression with resultType string).	any
recursive	If true, files under the folder path will be read recursively. Default is true. Type: boolean (or Expression with resultType boolean).	any
type	The read setting type.	'GoogleCloudStorageReadSettings' (required)
wildcardFileName	Google Cloud Storage wildcardFileName. Type: string (or Expression with resultType string).	any
wildcardFolderPath	Google Cloud Storage wildcardFolderPath. Type: string (or Expression with resultType string).	any

GreenplumSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
query	A query to retrieve data from source. Type: string (or Expression with resultType string).	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Copy source type.	'GreenplumSource' (required)

HBaseSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
query	A query to retrieve data from source. Type: string (or Expression with resultType string).	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Copy source type.	'HBaseSource' (required)

HdfsReadSettings

Name	Description	Value
deleteFilesAfterCompletion	Indicates whether the source files need to be deleted after copy completion. Default is false. Type: boolean (or Expression with resultType boolean).	any
distcpSettings	Specifies Distcp-related settings.	DistcpSettings
enablePartitionDiscovery	Indicates whether to enable partition discovery. Type: boolean (or Expression with resultType boolean).	any
fileListPath	Point to a text file that lists each file (relative path to the path configured in the dataset) that you want to copy. Type: string (or Expression with resultType string).	any
modifiedDatetimeEnd	The end of file's modified datetime. Type: string (or Expression with resultType string).	any
modifiedDatetimeStart	The start of file's modified datetime. Type: string (or Expression with resultType string).	any
partitionRootPath	Specify the root path where partition discovery starts from. Type: string (or Expression with resultType string).	any
recursive	If true, files under the folder path will be read recursively. Default is true. Type: boolean (or Expression with resultType boolean).	any
type	The read setting type.	'HdfsReadSettings' (required)
wildcardFileName	HDFS wildcardFileName. Type: string (or Expression with resultType string).	any
wildcardFolderPath	HDFS wildcardFolderPath. Type: string (or Expression with resultType string).	any

HdfsSource

Name	Description	Value
distcpSettings	Specifies Distcp-related settings.	DistcpSettings
recursive	If true, files under the folder path will be read recursively. Default is true. Type: boolean (or Expression with resultType boolean).	any
type	Copy source type.	'HdfsSource' (required)

HDInsightHiveActivity

Name	Description	Value
linkedServiceName	Linked service reference.	LinkedServiceReference
policy	Activity policy.	ActivityPolicy
type	Type of activity.	'HDInsightHive' (required)
typeProperties	HDInsight Hive activity properties.	HDInsightHiveActivityTypeProperties (required)

HDInsightHiveActivityTypeProperties

Name	Description	Value
arguments	User specified arguments to HDInsightActivity.	any[]
defines	Allows user to specify defines for Hive job request.	HDInsightHiveActivityTypePropertiesDefines
getDebugInfo	Debug info option.	'Always' 'Failure' 'None'
queryTimeout	Query timeout value (in minutes). Effective when the HDInsight cluster is with ESP (Enterprise Security Package)	int
scriptLinkedService	Script linked service reference.	LinkedServiceReference
scriptPath	Script path. Type: string (or Expression with resultType string).	any
storageLinkedServices	Storage linked service references.	LinkedServiceReference[]
variables	User specified arguments under hivevar namespace.	HDInsightHiveActivityTypePropertiesVariables

HDInsightHiveActivityTypePropertiesDefines

Name	Description	Value

HDInsightHiveActivityTypePropertiesVariables

Name	Description	Value

HDInsightMapReduceActivity

Name	Description	Value
linkedServiceName	Linked service reference.	LinkedServiceReference
policy	Activity policy.	ActivityPolicy
type	Type of activity.	'HDInsightMapReduce' (required)
typeProperties	HDInsight MapReduce activity properties.	HDInsightMapReduceActivityTypeProperties (required)

HDInsightMapReduceActivityTypeProperties

Name	Description	Value
arguments	User specified arguments to HDInsightActivity.	any[]
className	Class name. Type: string (or Expression with resultType string).	any (required)
defines	Allows user to specify defines for the MapReduce job request.	HDInsightMapReduceActivityTypePropertiesDefines
getDebugInfo	Debug info option.	'Always' 'Failure' 'None'
jarFilePath	Jar path. Type: string (or Expression with resultType string).	any (required)
jarLibs	Jar libs.	any[]
jarLinkedService	Jar linked service reference.	LinkedServiceReference
storageLinkedServices	Storage linked service references.	LinkedServiceReference[]

HDInsightMapReduceActivityTypePropertiesDefines

Name	Description	Value

HDInsightPigActivity

Name	Description	Value
linkedServiceName	Linked service reference.	LinkedServiceReference
policy	Activity policy.	ActivityPolicy
type	Type of activity.	'HDInsightPig' (required)
typeProperties	HDInsight Pig activity properties.	HDInsightPigActivityTypeProperties (required)

HDInsightPigActivityTypeProperties

Name	Description	Value
arguments	User specified arguments to HDInsightActivity. Type: array (or Expression with resultType array).	any
defines	Allows user to specify defines for Pig job request.	HDInsightPigActivityTypePropertiesDefines
getDebugInfo	Debug info option.	'Always' 'Failure' 'None'
scriptLinkedService	Script linked service reference.	LinkedServiceReference
scriptPath	Script path. Type: string (or Expression with resultType string).	any
storageLinkedServices	Storage linked service references.	LinkedServiceReference[]

HDInsightPigActivityTypePropertiesDefines

Name	Description	Value

HDInsightSparkActivity

Name	Description	Value
linkedServiceName	Linked service reference.	LinkedServiceReference
policy	Activity policy.	ActivityPolicy
type	Type of activity.	'HDInsightSpark' (required)
typeProperties	HDInsight spark activity properties.	HDInsightSparkActivityTypeProperties (required)

HDInsightSparkActivityTypeProperties

Name	Description	Value
arguments	The user-specified arguments to HDInsightSparkActivity.	any[]
className	The application's Java/Spark main class.	string
entryFilePath	The relative path to the root folder of the code/package to be executed. Type: string (or Expression with resultType string).	any (required)
getDebugInfo	Debug info option.	'Always' 'Failure' 'None'
proxyUser	The user to impersonate that will execute the job. Type: string (or Expression with resultType string).	any
rootPath	The root path in 'sparkJobLinkedService' for all the job’s files. Type: string (or Expression with resultType string).	any (required)
sparkConfig	Spark configuration property.	HDInsightSparkActivityTypePropertiesSparkConfig
sparkJobLinkedService	The storage linked service for uploading the entry file and dependencies, and for receiving logs.	LinkedServiceReference

HDInsightSparkActivityTypePropertiesSparkConfig

Name	Description	Value

HDInsightStreamingActivity

Name	Description	Value
linkedServiceName	Linked service reference.	LinkedServiceReference
policy	Activity policy.	ActivityPolicy
type	Type of activity.	'HDInsightStreaming' (required)
typeProperties	HDInsight streaming activity properties.	HDInsightStreamingActivityTypeProperties (required)

HDInsightStreamingActivityTypeProperties

Name	Description	Value
arguments	User specified arguments to HDInsightActivity.	any[]
combiner	Combiner executable name. Type: string (or Expression with resultType string).	any
commandEnvironment	Command line environment values.	any[]
defines	Allows user to specify defines for streaming job request.	HDInsightStreamingActivityTypePropertiesDefines
fileLinkedService	Linked service reference where the files are located.	LinkedServiceReference
filePaths	Paths to streaming job files. Can be directories.	any[] (required)
getDebugInfo	Debug info option.	'Always' 'Failure' 'None'
input	Input blob path. Type: string (or Expression with resultType string).	any (required)
mapper	Mapper executable name. Type: string (or Expression with resultType string).	any (required)
output	Output blob path. Type: string (or Expression with resultType string).	any (required)
reducer	Reducer executable name. Type: string (or Expression with resultType string).	any (required)
storageLinkedServices	Storage linked service references.	LinkedServiceReference[]

HDInsightStreamingActivityTypePropertiesDefines

Name	Description	Value

HiveSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
query	A query to retrieve data from source. Type: string (or Expression with resultType string).	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Copy source type.	'HiveSource' (required)

HttpReadSettings

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
additionalHeaders	The additional HTTP headers in the request to the RESTful API. Type: string (or Expression with resultType string).	any
requestBody	The HTTP request body to the RESTful API if requestMethod is POST. Type: string (or Expression with resultType string).	any
requestMethod	The HTTP method used to call the RESTful API. The default is GET. Type: string (or Expression with resultType string).	any
requestTimeout	Specifies the timeout for a HTTP client to get HTTP response from HTTP server. Type: string (or Expression with resultType string).	any
type	The read setting type.	'HttpReadSettings' (required)

HttpSource

Name	Description	Value
httpRequestTimeout	Specifies the timeout for a HTTP client to get HTTP response from HTTP server. The default value is equivalent to System.Net.HttpWebRequest.Timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Copy source type.	'HttpSource' (required)

HubspotSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
query	A query to retrieve data from source. Type: string (or Expression with resultType string).	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Copy source type.	'HubspotSource' (required)

IcebergSink

Name	Description	Value
formatSettings	Iceberg format settings.	IcebergWriteSettings
storeSettings	Iceberg store settings.	StoreWriteSettings
type	Copy sink type.	'IcebergSink' (required)

IcebergWriteSettings

Name	Description	Value
type	The write setting type.	string (required)

IfConditionActivity

Name	Description	Value
type	Type of activity.	'IfCondition' (required)
typeProperties	IfCondition activity properties.	IfConditionActivityTypeProperties (required)

IfConditionActivityTypeProperties

Name	Description	Value
expression	An expression that would evaluate to Boolean. This is used to determine the block of activities (ifTrueActivities or ifFalseActivities) that will be executed.	Expression (required)
ifFalseActivities	List of activities to execute if expression is evaluated to false. This is an optional property and if not provided, the activity will exit without any action.	Activity[]
ifTrueActivities	List of activities to execute if expression is evaluated to true. This is an optional property and if not provided, the activity will exit without any action.	Activity[]

ImpalaSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
query	A query to retrieve data from source. Type: string (or Expression with resultType string).	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Copy source type.	'ImpalaSource' (required)

InformixSink

Name	Description	Value
preCopyScript	A query to execute before starting the copy. Type: string (or Expression with resultType string).	any
type	Copy sink type.	'InformixSink' (required)

InformixSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
query	Database query. Type: string (or Expression with resultType string).	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Copy source type.	'InformixSource' (required)

IntegrationRuntimeReference

Name	Description	Value
parameters	Arguments for integration runtime.	ParameterValueSpecification
referenceName	Reference integration runtime name.	string (required)
type	Type of integration runtime.	'IntegrationRuntimeReference' (required)

JiraSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
query	A query to retrieve data from source. Type: string (or Expression with resultType string).	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Copy source type.	'JiraSource' (required)

JsonReadSettings

Name	Description	Value
compressionProperties	Compression settings.	CompressionReadSettings
type	The read setting type.	'JsonReadSettings' (required)

JsonReadSettings

Name	Description	Value
compressionProperties	Compression settings.	CompressionReadSettings
type	The read setting type.	string (required)

JsonSink

Name	Description	Value
formatSettings	Json format settings.	JsonWriteSettings
storeSettings	Json store settings.	StoreWriteSettings
type	Copy sink type.	'JsonSink' (required)

JsonSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
formatSettings	Json format settings.	JsonReadSettings
storeSettings	Json store settings.	StoreReadSettings
type	Copy source type.	'JsonSource' (required)

JsonWriteSettings

Name	Description	Value
filePattern	File pattern of JSON. This setting controls the way a collection of JSON objects will be treated. The default value is 'setOfObjects'. It is case-sensitive.	any
type	The write setting type.	string (required)

LakeHouseReadSettings

Name	Description	Value
deleteFilesAfterCompletion	Indicates whether the source files need to be deleted after copy completion. Default is false. Type: boolean (or Expression with resultType boolean).	any
enablePartitionDiscovery	Indicates whether to enable partition discovery. Type: boolean (or Expression with resultType boolean).	any
fileListPath	Point to a text file that lists each file (relative path to the path configured in the dataset) that you want to copy. Type: string (or Expression with resultType string).	any
modifiedDatetimeEnd	The end of file's modified datetime. Type: string (or Expression with resultType string).	any
modifiedDatetimeStart	The start of file's modified datetime. Type: string (or Expression with resultType string).	any
partitionRootPath	Specify the root path where partition discovery starts from. Type: string (or Expression with resultType string).	any
recursive	If true, files under the folder path will be read recursively. Default is true. Type: boolean (or Expression with resultType boolean).	any
type	The read setting type.	'LakeHouseReadSettings' (required)
wildcardFileName	Microsoft Fabric LakeHouse Files wildcardFileName. Type: string (or Expression with resultType string).	any
wildcardFolderPath	Microsoft Fabric LakeHouse Files wildcardFolderPath. Type: string (or Expression with resultType string).	any

LakeHouseTableSink

Name	Description	Value
partitionNameList	Specify the partition column names from sink columns. Type: array of objects (or Expression with resultType array of objects).	any
partitionOption	Create partitions in folder structure based on one or multiple columns. Each distinct column value (pair) will be a new partition. Possible values include: "None", "PartitionByKey".	any
tableActionOption	The type of table action for LakeHouse Table sink. Possible values include: "None", "Append", "Overwrite".	any
type	Copy sink type.	'LakeHouseTableSink' (required)

LakeHouseTableSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
timestampAsOf	Query an older snapshot by timestamp. Type: string (or Expression with resultType string).	any
type	Copy source type.	'LakeHouseTableSource' (required)
versionAsOf	Query an older snapshot by version. Type: integer (or Expression with resultType integer).	any

LakeHouseWriteSettings

Name	Description	Value
type	The write setting type.	'LakeHouseWriteSettings' (required)

LinkedServiceReference

Name	Description	Value
parameters	Arguments for LinkedService.	ParameterValueSpecification
referenceName	Reference LinkedService name.	string (required)
type	Linked service reference type.	'LinkedServiceReference' (required)

LogLocationSettings

Name	Description	Value
linkedServiceName	Log storage linked service reference.	LinkedServiceReference (required)
path	The path to storage for storing detailed logs of activity execution. Type: string (or Expression with resultType string).	any

LogSettings

Name	Description	Value
copyActivityLogSettings	Specifies settings for copy activity log.	CopyActivityLogSettings
enableCopyActivityLog	Specifies whether to enable copy activity log. Type: boolean (or Expression with resultType boolean).	any
logLocationSettings	Log location settings customer needs to provide when enabling log.	LogLocationSettings (required)

LogStorageSettings

Name	Description	Value
enableReliableLogging	Specifies whether to enable reliable logging. Type: boolean (or Expression with resultType boolean).	any
linkedServiceName	Log storage linked service reference.	LinkedServiceReference (required)
logLevel	Gets or sets the log level, support: Info, Warning. Type: string (or Expression with resultType string).	any
path	The path to storage for storing detailed logs of activity execution. Type: string (or Expression with resultType string).	any

LookupActivity

Name	Description	Value
linkedServiceName	Linked service reference.	LinkedServiceReference
policy	Activity policy.	ActivityPolicy
type	Type of activity.	'Lookup' (required)
typeProperties	Lookup activity properties.	LookupActivityTypeProperties (required)

LookupActivityTypeProperties

Name	Description	Value
dataset	Lookup activity dataset reference.	DatasetReference (required)
firstRowOnly	Whether to return first row or all rows. Default value is true. Type: boolean (or Expression with resultType boolean).	any
source	Dataset-specific source properties, same as copy activity source.	CopySource (required)

MagentoSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
query	A query to retrieve data from source. Type: string (or Expression with resultType string).	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Copy source type.	'MagentoSource' (required)

MariaDBSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
query	A query to retrieve data from source. Type: string (or Expression with resultType string).	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Copy source type.	'MariaDBSource' (required)

MarketoSource

Name	Description	Value
additionalColumns	Specifies the additional columns to be added to source data. Type: array of objects(AdditionalColumns) (or Expression with resultType array of objects).	any
query	A query to retrieve data from source. Type: string (or Expression with resultType string).	any
queryTimeout	Query timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60	([0-5][0-9])):(60	([0-5][0-9])).	any
type	Copy source type.	'MarketoSource' (required)

MetadataItem

Name	Description	Value
name	Metadata item key name. Type: string (or Expression with resultType string).	any
value	Metadata item value. Type: string (or Expression with resultType string).	any