Microsoft.DataFactory factories/datasets

The factories/datasets resource type can be deployed to: Resource groups.

To learn about resource group deployments, see Bicep or ARM template.

Template format

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

resource symbolicname 'Microsoft.DataFactory/factories/datasets@2018-06-01' = {
  name: 'string'
  properties: {
    annotations: [ any ]
    description: 'string'
    folder: {
      name: 'string'
    }
    linkedServiceName: {
      parameters: {}
      referenceName: 'string'
      type: 'LinkedServiceReference'
    }
    parameters: {}
    schema: any()
    structure: any()
    type: 'string'
    // For remaining properties, see Dataset objects
  }
}

Dataset objects

Set the type property to specify the type of object.

For AmazonMWSObject, use:

  type: 'AmazonMWSObject'
  typeProperties: {
    tableName: any()
  }

For AmazonRedshiftTable, use:

  type: 'AmazonRedshiftTable'
  typeProperties: {
    schema: any()
    table: any()
    tableName: any()
  }

For AmazonS3Object, use:

  type: 'AmazonS3Object'
  typeProperties: {
    bucketName: any()
    compression: {
      type: 'string'
      // For remaining properties, see DatasetCompression objects
    }
    format: {
      deserializer: any()
      serializer: any()
      type: 'string'
      // For remaining properties, see DatasetStorageFormat objects
    }
    key: any()
    modifiedDatetimeEnd: any()
    modifiedDatetimeStart: any()
    prefix: any()
    version: any()
  }

For Avro, use:

  type: 'Avro'
  typeProperties: {
    avroCompressionCodec: any()
    avroCompressionLevel: int
    location: {
      fileName: any()
      folderPath: any()
      type: 'string'
      // For remaining properties, see DatasetLocation objects
    }
  }

For AzureBlob, use:

  type: 'AzureBlob'
  typeProperties: {
    compression: {
      type: 'string'
      // For remaining properties, see DatasetCompression objects
    }
    fileName: any()
    folderPath: any()
    format: {
      deserializer: any()
      serializer: any()
      type: 'string'
      // For remaining properties, see DatasetStorageFormat objects
    }
    modifiedDatetimeEnd: any()
    modifiedDatetimeStart: any()
    tableRootLocation: any()
  }

For AzureBlobFSFile, use:

  type: 'AzureBlobFSFile'
  typeProperties: {
    compression: {
      type: 'string'
      // For remaining properties, see DatasetCompression objects
    }
    fileName: any()
    folderPath: any()
    format: {
      deserializer: any()
      serializer: any()
      type: 'string'
      // For remaining properties, see DatasetStorageFormat objects
    }
  }

For AzureDatabricksDeltaLakeDataset, use:

  type: 'AzureDatabricksDeltaLakeDataset'
  typeProperties: {
    database: any()
    table: any()
  }

For AzureDataExplorerTable, use:

  type: 'AzureDataExplorerTable'
  typeProperties: {
    table: any()
  }

For AzureDataLakeStoreFile, use:

  type: 'AzureDataLakeStoreFile'
  typeProperties: {
    compression: {
      type: 'string'
      // For remaining properties, see DatasetCompression objects
    }
    fileName: any()
    folderPath: any()
    format: {
      deserializer: any()
      serializer: any()
      type: 'string'
      // For remaining properties, see DatasetStorageFormat objects
    }
  }

For AzureMariaDBTable, use:

  type: 'AzureMariaDBTable'
  typeProperties: {
    tableName: any()
  }

For AzureMySqlTable, use:

  type: 'AzureMySqlTable'
  typeProperties: {
    table: any()
    tableName: any()
  }

For AzurePostgreSqlTable, use:

  type: 'AzurePostgreSqlTable'
  typeProperties: {
    schema: any()
    table: any()
    tableName: any()
  }

For AzureSearchIndex, use:

  type: 'AzureSearchIndex'
  typeProperties: {
    indexName: any()
  }

For AzureSqlDWTable, use:

  type: 'AzureSqlDWTable'
  typeProperties: {
    schema: any()
    table: any()
    tableName: any()
  }

For AzureSqlMITable, use:

  type: 'AzureSqlMITable'
  typeProperties: {
    schema: any()
    table: any()
    tableName: any()
  }

For AzureSqlTable, use:

  type: 'AzureSqlTable'
  typeProperties: {
    schema: any()
    table: any()
    tableName: any()
  }

For AzureTable, use:

  type: 'AzureTable'
  typeProperties: {
    tableName: any()
  }

For Binary, use:

  type: 'Binary'
  typeProperties: {
    compression: {
      type: 'string'
      // For remaining properties, see DatasetCompression objects
    }
    location: {
      fileName: any()
      folderPath: any()
      type: 'string'
      // For remaining properties, see DatasetLocation objects
    }
  }

For CassandraTable, use:

  type: 'CassandraTable'
  typeProperties: {
    keyspace: any()
    tableName: any()
  }

For CommonDataServiceForAppsEntity, use:

  type: 'CommonDataServiceForAppsEntity'
  typeProperties: {
    entityName: any()
  }

For ConcurObject, use:

  type: 'ConcurObject'
  typeProperties: {
    tableName: any()
  }

For CosmosDbMongoDbApiCollection, use:

  type: 'CosmosDbMongoDbApiCollection'
  typeProperties: {
    collection: any()
  }

For CosmosDbSqlApiCollection, use:

  type: 'CosmosDbSqlApiCollection'
  typeProperties: {
    collectionName: any()
  }

For CouchbaseTable, use:

  type: 'CouchbaseTable'
  typeProperties: {
    tableName: any()
  }

For CustomDataset, use:

  type: 'CustomDataset'
  typeProperties: any()

For Db2Table, use:

  type: 'Db2Table'
  typeProperties: {
    schema: any()
    table: any()
    tableName: any()
  }

For DelimitedText, use:

  type: 'DelimitedText'
  typeProperties: {
    columnDelimiter: any()
    compressionCodec: any()
    compressionLevel: any()
    encodingName: any()
    escapeChar: any()
    firstRowAsHeader: any()
    location: {
      fileName: any()
      folderPath: any()
      type: 'string'
      // For remaining properties, see DatasetLocation objects
    }
    nullValue: any()
    quoteChar: any()
    rowDelimiter: any()
  }

For DocumentDbCollection, use:

  type: 'DocumentDbCollection'
  typeProperties: {
    collectionName: any()
  }

For DrillTable, use:

  type: 'DrillTable'
  typeProperties: {
    schema: any()
    table: any()
    tableName: any()
  }

For DynamicsAXResource, use:

  type: 'DynamicsAXResource'
  typeProperties: {
    path: any()
  }

For DynamicsCrmEntity, use:

  type: 'DynamicsCrmEntity'
  typeProperties: {
    entityName: any()
  }

For DynamicsEntity, use:

  type: 'DynamicsEntity'
  typeProperties: {
    entityName: any()
  }

For EloquaObject, use:

  type: 'EloquaObject'
  typeProperties: {
    tableName: any()
  }

For Excel, use:

  type: 'Excel'
  typeProperties: {
    compression: {
      type: 'string'
      // For remaining properties, see DatasetCompression objects
    }
    firstRowAsHeader: any()
    location: {
      fileName: any()
      folderPath: any()
      type: 'string'
      // For remaining properties, see DatasetLocation objects
    }
    nullValue: any()
    range: any()
    sheetIndex: any()
    sheetName: any()
  }

For FileShare, use:

  type: 'FileShare'
  typeProperties: {
    compression: {
      type: 'string'
      // For remaining properties, see DatasetCompression objects
    }
    fileFilter: any()
    fileName: any()
    folderPath: any()
    format: {
      deserializer: any()
      serializer: any()
      type: 'string'
      // For remaining properties, see DatasetStorageFormat objects
    }
    modifiedDatetimeEnd: any()
    modifiedDatetimeStart: any()
  }

For GoogleAdWordsObject, use:

  type: 'GoogleAdWordsObject'
  typeProperties: {
    tableName: any()
  }

For GoogleBigQueryObject, use:

  type: 'GoogleBigQueryObject'
  typeProperties: {
    dataset: any()
    table: any()
    tableName: any()
  }

For GreenplumTable, use:

  type: 'GreenplumTable'
  typeProperties: {
    schema: any()
    table: any()
    tableName: any()
  }

For HBaseObject, use:

  type: 'HBaseObject'
  typeProperties: {
    tableName: any()
  }

For HiveObject, use:

  type: 'HiveObject'
  typeProperties: {
    schema: any()
    table: any()
    tableName: any()
  }

For HttpFile, use:

  type: 'HttpFile'
  typeProperties: {
    additionalHeaders: any()
    compression: {
      type: 'string'
      // For remaining properties, see DatasetCompression objects
    }
    format: {
      deserializer: any()
      serializer: any()
      type: 'string'
      // For remaining properties, see DatasetStorageFormat objects
    }
    relativeUrl: any()
    requestBody: any()
    requestMethod: any()
  }

For HubspotObject, use:

  type: 'HubspotObject'
  typeProperties: {
    tableName: any()
  }

For ImpalaObject, use:

  type: 'ImpalaObject'
  typeProperties: {
    schema: any()
    table: any()
    tableName: any()
  }

For InformixTable, use:

  type: 'InformixTable'
  typeProperties: {
    tableName: any()
  }

For JiraObject, use:

  type: 'JiraObject'
  typeProperties: {
    tableName: any()
  }

For Json, use:

  type: 'Json'
  typeProperties: {
    compression: {
      type: 'string'
      // For remaining properties, see DatasetCompression objects
    }
    encodingName: any()
    location: {
      fileName: any()
      folderPath: any()
      type: 'string'
      // For remaining properties, see DatasetLocation objects
    }
  }

For MagentoObject, use:

  type: 'MagentoObject'
  typeProperties: {
    tableName: any()
  }

For MariaDBTable, use:

  type: 'MariaDBTable'
  typeProperties: {
    tableName: any()
  }

For MarketoObject, use:

  type: 'MarketoObject'
  typeProperties: {
    tableName: any()
  }

For MicrosoftAccessTable, use:

  type: 'MicrosoftAccessTable'
  typeProperties: {
    tableName: any()
  }

For MongoDbAtlasCollection, use:

  type: 'MongoDbAtlasCollection'
  typeProperties: {
    collection: any()
  }

For MongoDbCollection, use:

  type: 'MongoDbCollection'
  typeProperties: {
    collectionName: any()
  }

For MongoDbV2Collection, use:

  type: 'MongoDbV2Collection'
  typeProperties: {
    collection: any()
  }

For MySqlTable, use:

  type: 'MySqlTable'
  typeProperties: {
    tableName: any()
  }

For NetezzaTable, use:

  type: 'NetezzaTable'
  typeProperties: {
    schema: any()
    table: any()
    tableName: any()
  }

For ODataResource, use:

  type: 'ODataResource'
  typeProperties: {
    path: any()
  }

For OdbcTable, use:

  type: 'OdbcTable'
  typeProperties: {
    tableName: any()
  }

For Office365Table, use:

  type: 'Office365Table'
  typeProperties: {
    predicate: any()
    tableName: any()
  }

For OracleServiceCloudObject, use:

  type: 'OracleServiceCloudObject'
  typeProperties: {
    tableName: any()
  }

For OracleTable, use:

  type: 'OracleTable'
  typeProperties: {
    schema: any()
    table: any()
    tableName: any()
  }

For Orc, use:

  type: 'Orc'
  typeProperties: {
    location: {
      fileName: any()
      folderPath: any()
      type: 'string'
      // For remaining properties, see DatasetLocation objects
    }
    orcCompressionCodec: any()
  }

For Parquet, use:

  type: 'Parquet'
  typeProperties: {
    compressionCodec: any()
    location: {
      fileName: any()
      folderPath: any()
      type: 'string'
      // For remaining properties, see DatasetLocation objects
    }
  }

For PaypalObject, use:

  type: 'PaypalObject'
  typeProperties: {
    tableName: any()
  }

For PhoenixObject, use:

  type: 'PhoenixObject'
  typeProperties: {
    schema: any()
    table: any()
    tableName: any()
  }

For PostgreSqlTable, use:

  type: 'PostgreSqlTable'
  typeProperties: {
    schema: any()
    table: any()
    tableName: any()
  }

For PrestoObject, use:

  type: 'PrestoObject'
  typeProperties: {
    schema: any()
    table: any()
    tableName: any()
  }

For QuickBooksObject, use:

  type: 'QuickBooksObject'
  typeProperties: {
    tableName: any()
  }

For RelationalTable, use:

  type: 'RelationalTable'
  typeProperties: {
    tableName: any()
  }

For ResponsysObject, use:

  type: 'ResponsysObject'
  typeProperties: {
    tableName: any()
  }

For RestResource, use:

  type: 'RestResource'
  typeProperties: {
    additionalHeaders: any()
    paginationRules: any()
    relativeUrl: any()
    requestBody: any()
    requestMethod: any()
  }

For SalesforceMarketingCloudObject, use:

  type: 'SalesforceMarketingCloudObject'
  typeProperties: {
    tableName: any()
  }

For SalesforceObject, use:

  type: 'SalesforceObject'
  typeProperties: {
    objectApiName: any()
  }

For SalesforceServiceCloudObject, use:

  type: 'SalesforceServiceCloudObject'
  typeProperties: {
    objectApiName: any()
  }

For SapBwCube, use:

  type: 'SapBwCube'

For SapCloudForCustomerResource, use:

  type: 'SapCloudForCustomerResource'
  typeProperties: {
    path: any()
  }

For SapEccResource, use:

  type: 'SapEccResource'
  typeProperties: {
    path: any()
  }

For SapHanaTable, use:

  type: 'SapHanaTable'
  typeProperties: {
    schema: any()
    table: any()
  }

For SapOpenHubTable, use:

  type: 'SapOpenHubTable'
  typeProperties: {
    baseRequestId: any()
    excludeLastRequest: any()
    openHubDestinationName: any()
  }

For SapTableResource, use:

  type: 'SapTableResource'
  typeProperties: {
    tableName: any()
  }

For ServiceNowObject, use:

  type: 'ServiceNowObject'
  typeProperties: {
    tableName: any()
  }

For SharePointOnlineListResource, use:

  type: 'SharePointOnlineListResource'
  typeProperties: {
    listName: any()
  }

For ShopifyObject, use:

  type: 'ShopifyObject'
  typeProperties: {
    tableName: any()
  }

For SnowflakeTable, use:

  type: 'SnowflakeTable'
  typeProperties: {
    schema: any()
    table: any()
  }

For SparkObject, use:

  type: 'SparkObject'
  typeProperties: {
    schema: any()
    table: any()
    tableName: any()
  }

For SqlServerTable, use:

  type: 'SqlServerTable'
  typeProperties: {
    schema: any()
    table: any()
    tableName: any()
  }

For SquareObject, use:

  type: 'SquareObject'
  typeProperties: {
    tableName: any()
  }

For SybaseTable, use:

  type: 'SybaseTable'
  typeProperties: {
    tableName: any()
  }

For TeradataTable, use:

  type: 'TeradataTable'
  typeProperties: {
    database: any()
    table: any()
  }

For VerticaTable, use:

  type: 'VerticaTable'
  typeProperties: {
    schema: any()
    table: any()
    tableName: any()
  }

For WebTable, use:

  type: 'WebTable'
  typeProperties: {
    index: any()
    path: any()
  }

For XeroObject, use:

  type: 'XeroObject'
  typeProperties: {
    tableName: any()
  }

For Xml, use:

  type: 'Xml'
  typeProperties: {
    compression: {
      type: 'string'
      // For remaining properties, see DatasetCompression objects
    }
    encodingName: any()
    location: {
      fileName: any()
      folderPath: any()
      type: 'string'
      // For remaining properties, see DatasetLocation objects
    }
    nullValue: any()
  }

For ZohoObject, use:

  type: 'ZohoObject'
  typeProperties: {
    tableName: any()
  }

DatasetCompression objects

Set the type property to specify the type of object.

For BZip2, use:

  type: 'BZip2'

For Deflate, use:

  type: 'Deflate'
  level: any()

For GZip, use:

  type: 'GZip'
  level: any()

For Tar, use:

  type: 'Tar'

For TarGZip, use:

  type: 'TarGZip'
  level: any()

For ZipDeflate, use:

  type: 'ZipDeflate'
  level: any()

DatasetStorageFormat objects

Set the type property to specify the type of object.

For AvroFormat, use:

  type: 'AvroFormat'

For JsonFormat, use:

  type: 'JsonFormat'
  encodingName: any()
  filePattern: any()
  jsonNodeReference: any()
  jsonPathDefinition: any()
  nestingSeparator: any()

For OrcFormat, use:

  type: 'OrcFormat'

For ParquetFormat, use:

  type: 'ParquetFormat'

For TextFormat, use:

  type: 'TextFormat'
  columnDelimiter: any()
  encodingName: any()
  escapeChar: any()
  firstRowAsHeader: any()
  nullValue: any()
  quoteChar: any()
  rowDelimiter: any()
  skipLineCount: any()
  treatEmptyAsNull: any()

DatasetLocation objects

Set the type property to specify the type of object.

For AmazonS3CompatibleLocation, use:

  type: 'AmazonS3CompatibleLocation'
  bucketName: any()
  version: any()

For AmazonS3Location, use:

  type: 'AmazonS3Location'
  bucketName: any()
  version: any()

For AzureBlobFSLocation, use:

  type: 'AzureBlobFSLocation'
  fileSystem: any()

For AzureBlobStorageLocation, use:

  type: 'AzureBlobStorageLocation'
  container: any()

For AzureDataLakeStoreLocation, use:

  type: 'AzureDataLakeStoreLocation'

For AzureFileStorageLocation, use:

  type: 'AzureFileStorageLocation'

For FileServerLocation, use:

  type: 'FileServerLocation'

For FtpServerLocation, use:

  type: 'FtpServerLocation'

For GoogleCloudStorageLocation, use:

  type: 'GoogleCloudStorageLocation'
  bucketName: any()
  version: any()

For HdfsLocation, use:

  type: 'HdfsLocation'

For HttpServerLocation, use:

  type: 'HttpServerLocation'
  relativeUrl: any()

For OracleCloudStorageLocation, use:

  type: 'OracleCloudStorageLocation'
  bucketName: any()
  version: any()

For SftpLocation, use:

  type: 'SftpLocation'

Property values

factories/datasets

Name Description Value
type The resource type

For Bicep, set this value in the resource declaration.
'Microsoft.DataFactory/factories/datasets'
apiVersion The resource api version

For Bicep, set this value in the resource declaration.
'2018-06-01'
name The resource name

See how to set names and types for child resources in Bicep or JSON ARM templates.
string (required)
properties The Azure Data Factory nested object which identifies data within different data stores, such as tables, files, folders, and documents. Dataset (required)

Dataset

Name Description Value
annotations List of tags that can be used for describing the Dataset. any[]
description Dataset description. string
folder The folder that this Dataset is in. If not specified, Dataset will appear at the root level. DatasetFolder
linkedServiceName Linked service reference type. LinkedServiceReference (required)
parameters Definition of all parameters for an entity. object
schema Any object For Bicep, you can use the any() function.
structure Any object For Bicep, you can use the any() function.
type Set the object type AmazonMWSObject
AmazonRedshiftTable
AmazonS3Object
Avro
AzureBlob
AzureBlobFSFile
AzureDatabricksDeltaLakeDataset
AzureDataExplorerTable
AzureDataLakeStoreFile
AzureMariaDBTable
AzureMySqlTable
AzurePostgreSqlTable
AzureSearchIndex
AzureSqlDWTable
AzureSqlMITable
AzureSqlTable
AzureTable
Binary
CassandraTable
CommonDataServiceForAppsEntity
ConcurObject
CosmosDbMongoDbApiCollection
CosmosDbSqlApiCollection
CouchbaseTable
CustomDataset
Db2Table
DelimitedText
DocumentDbCollection
DrillTable
DynamicsAXResource
DynamicsCrmEntity
DynamicsEntity
EloquaObject
Excel
FileShare
GoogleAdWordsObject
GoogleBigQueryObject
GreenplumTable
HBaseObject
HiveObject
HttpFile
HubspotObject
ImpalaObject
InformixTable
JiraObject
Json
MagentoObject
MariaDBTable
MarketoObject
MicrosoftAccessTable
MongoDbAtlasCollection
MongoDbCollection
MongoDbV2Collection
MySqlTable
NetezzaTable
ODataResource
OdbcTable
Office365Table
OracleServiceCloudObject
OracleTable
Orc
Parquet
PaypalObject
PhoenixObject
PostgreSqlTable
PrestoObject
QuickBooksObject
RelationalTable
ResponsysObject
RestResource
SalesforceMarketingCloudObject
SalesforceObject
SalesforceServiceCloudObject
SapBwCube
SapCloudForCustomerResource
SapEccResource
SapHanaTable
SapOpenHubTable
SapTableResource
ServiceNowObject
SharePointOnlineListResource
ShopifyObject
SnowflakeTable
SparkObject
SqlServerTable
SquareObject
SybaseTable
TeradataTable
VerticaTable
WebTable
XeroObject
Xml
ZohoObject

DatasetFolder

Name Description Value
name The name of the folder that this Dataset is in. string

LinkedServiceReference

Name Description Value
parameters An object mapping parameter names to argument values. object
referenceName Reference LinkedService name. string (required)
type Linked service reference type. 'LinkedServiceReference'

AmazonMWSObjectDataset

Name Description Value
type Type of dataset. 'AmazonMWSObject'
typeProperties Properties specific to this dataset type. GenericDatasetTypeProperties

GenericDatasetTypeProperties

Name Description Value
tableName Any object For Bicep, you can use the any() function.

AmazonRedshiftTableDataset

Name Description Value
type Type of dataset. 'AmazonRedshiftTable'
typeProperties Amazon Redshift table dataset properties. AmazonRedshiftTableDatasetTypeProperties

AmazonRedshiftTableDatasetTypeProperties

Name Description Value
schema Any object For Bicep, you can use the any() function.
table Any object For Bicep, you can use the any() function.
tableName Any object For Bicep, you can use the any() function.

AmazonS3Dataset

Name Description Value
type Type of dataset. 'AmazonS3Object'
typeProperties Amazon S3 dataset properties. AmazonS3DatasetTypeProperties (required)

AmazonS3DatasetTypeProperties

Name Description Value
bucketName Any object For Bicep, you can use the any() function.(required)
compression The compression method used on a dataset. DatasetCompression
format The format definition of a storage. DatasetStorageFormat
key Any object For Bicep, you can use the any() function.
modifiedDatetimeEnd Any object For Bicep, you can use the any() function.
modifiedDatetimeStart Any object For Bicep, you can use the any() function.
prefix Any object For Bicep, you can use the any() function.
version Any object For Bicep, you can use the any() function.

DatasetCompression

Name Description Value
type Set the object type BZip2
Deflate
GZip
Tar
TarGZip
ZipDeflate

DatasetBZip2Compression

Name Description Value
type Type of dataset compression. Type: string (or Expression with resultType string). 'BZip2'

DatasetDeflateCompression

Name Description Value
type Type of dataset compression. Type: string (or Expression with resultType string). 'Deflate'
level Any object For Bicep, you can use the any() function.

DatasetGZipCompression

Name Description Value
type Type of dataset compression. Type: string (or Expression with resultType string). 'GZip'
level Any object For Bicep, you can use the any() function.

DatasetTarCompression

Name Description Value
type Type of dataset compression. Type: string (or Expression with resultType string). 'Tar'

DatasetTarGZipCompression

Name Description Value
type Type of dataset compression. Type: string (or Expression with resultType string). 'TarGZip'
level Any object For Bicep, you can use the any() function.

DatasetZipDeflateCompression

Name Description Value
type Type of dataset compression. Type: string (or Expression with resultType string). 'ZipDeflate'
level Any object For Bicep, you can use the any() function.

DatasetStorageFormat

Name Description Value
deserializer Any object For Bicep, you can use the any() function.
serializer Any object For Bicep, you can use the any() function.
type Set the object type AvroFormat
JsonFormat
OrcFormat
ParquetFormat
TextFormat

AvroFormat

Name Description Value
type Type of dataset storage format. 'AvroFormat'

JsonFormat

Name Description Value
type Type of dataset storage format. 'JsonFormat'
encodingName Any object For Bicep, you can use the any() function.
filePattern Any object For Bicep, you can use the any() function.
jsonNodeReference Any object For Bicep, you can use the any() function.
jsonPathDefinition Any object For Bicep, you can use the any() function.
nestingSeparator Any object For Bicep, you can use the any() function.

OrcFormat

Name Description Value
type Type of dataset storage format. 'OrcFormat'

ParquetFormat

Name Description Value
type Type of dataset storage format. 'ParquetFormat'

TextFormat

Name Description Value
type Type of dataset storage format. 'TextFormat'
columnDelimiter Any object For Bicep, you can use the any() function.
encodingName Any object For Bicep, you can use the any() function.
escapeChar Any object For Bicep, you can use the any() function.
firstRowAsHeader Any object For Bicep, you can use the any() function.
nullValue Any object For Bicep, you can use the any() function.
quoteChar Any object For Bicep, you can use the any() function.
rowDelimiter Any object For Bicep, you can use the any() function.
skipLineCount Any object For Bicep, you can use the any() function.
treatEmptyAsNull Any object For Bicep, you can use the any() function.

AvroDataset

Name Description Value
type Type of dataset. 'Avro'
typeProperties Avro dataset properties. AvroDatasetTypeProperties

AvroDatasetTypeProperties

Name Description Value
avroCompressionCodec Any object For Bicep, you can use the any() function.
avroCompressionLevel int
location Dataset location. DatasetLocation (required)

DatasetLocation

Name Description Value
fileName Any object For Bicep, you can use the any() function.
folderPath Any object For Bicep, you can use the any() function.
type Set the object type AmazonS3CompatibleLocation
AmazonS3Location
AzureBlobFSLocation
AzureBlobStorageLocation
AzureDataLakeStoreLocation
AzureFileStorageLocation
FileServerLocation
FtpServerLocation
GoogleCloudStorageLocation
HdfsLocation
HttpServerLocation
OracleCloudStorageLocation
SftpLocation

AmazonS3CompatibleLocation

Name Description Value
type Type of dataset storage location. 'AmazonS3CompatibleLocation'
bucketName Any object For Bicep, you can use the any() function.
version Any object For Bicep, you can use the any() function.

AmazonS3Location

Name Description Value
type Type of dataset storage location. 'AmazonS3Location'
bucketName Any object For Bicep, you can use the any() function.
version Any object For Bicep, you can use the any() function.

AzureBlobFSLocation

Name Description Value
type Type of dataset storage location. 'AzureBlobFSLocation'
fileSystem Any object For Bicep, you can use the any() function.

AzureBlobStorageLocation

Name Description Value
type Type of dataset storage location. 'AzureBlobStorageLocation'
container Any object For Bicep, you can use the any() function.

AzureDataLakeStoreLocation

Name Description Value
type Type of dataset storage location. 'AzureDataLakeStoreLocation'

AzureFileStorageLocation

Name Description Value
type Type of dataset storage location. 'AzureFileStorageLocation'

FileServerLocation

Name Description Value
type Type of dataset storage location. 'FileServerLocation'

FtpServerLocation

Name Description Value
type Type of dataset storage location. 'FtpServerLocation'

GoogleCloudStorageLocation

Name Description Value
type Type of dataset storage location. 'GoogleCloudStorageLocation'
bucketName Any object For Bicep, you can use the any() function.
version Any object For Bicep, you can use the any() function.

HdfsLocation

Name Description Value
type Type of dataset storage location. 'HdfsLocation'

HttpServerLocation

Name Description Value
type Type of dataset storage location. 'HttpServerLocation'
relativeUrl Any object For Bicep, you can use the any() function.

OracleCloudStorageLocation

Name Description Value
type Type of dataset storage location. 'OracleCloudStorageLocation'
bucketName Any object For Bicep, you can use the any() function.
version Any object For Bicep, you can use the any() function.

SftpLocation

Name Description Value
type Type of dataset storage location. 'SftpLocation'

AzureBlobDataset

Name Description Value
type Type of dataset. 'AzureBlob'
typeProperties Azure Blob dataset properties. AzureBlobDatasetTypeProperties

AzureBlobDatasetTypeProperties

Name Description Value
compression The compression method used on a dataset. DatasetCompression
fileName Any object For Bicep, you can use the any() function.
folderPath Any object For Bicep, you can use the any() function.
format The format definition of a storage. DatasetStorageFormat
modifiedDatetimeEnd Any object For Bicep, you can use the any() function.
modifiedDatetimeStart Any object For Bicep, you can use the any() function.
tableRootLocation Any object For Bicep, you can use the any() function.

AzureBlobFSDataset

Name Description Value
type Type of dataset. 'AzureBlobFSFile'
typeProperties Azure Data Lake Storage Gen2 dataset properties. AzureBlobFSDatasetTypeProperties

AzureBlobFSDatasetTypeProperties

Name Description Value
compression The compression method used on a dataset. DatasetCompression
fileName Any object For Bicep, you can use the any() function.
folderPath Any object For Bicep, you can use the any() function.
format The format definition of a storage. DatasetStorageFormat

AzureDatabricksDeltaLakeDataset

Name Description Value
type Type of dataset. 'AzureDatabricksDeltaLakeDataset'
typeProperties Azure Databricks Delta Lake Dataset Properties AzureDatabricksDeltaLakeDatasetTypeProperties

AzureDatabricksDeltaLakeDatasetTypeProperties

Name Description Value
database Any object For Bicep, you can use the any() function.
table Any object For Bicep, you can use the any() function.

AzureDataExplorerTableDataset

Name Description Value
type Type of dataset. 'AzureDataExplorerTable'
typeProperties Azure Data Explorer (Kusto) dataset properties. AzureDataExplorerDatasetTypeProperties (required)

AzureDataExplorerDatasetTypeProperties

Name Description Value
table Any object For Bicep, you can use the any() function.

AzureDataLakeStoreDataset

Name Description Value
type Type of dataset. 'AzureDataLakeStoreFile'
typeProperties Azure Data Lake Store dataset properties. AzureDataLakeStoreDatasetTypeProperties

AzureDataLakeStoreDatasetTypeProperties

Name Description Value
compression The compression method used on a dataset. DatasetCompression
fileName Any object For Bicep, you can use the any() function.
folderPath Any object For Bicep, you can use the any() function.
format The format definition of a storage. DatasetStorageFormat

AzureMariaDBTableDataset

Name Description Value
type Type of dataset. 'AzureMariaDBTable'
typeProperties Properties specific to this dataset type. GenericDatasetTypeProperties

AzureMySqlTableDataset

Name Description Value
type Type of dataset. 'AzureMySqlTable'
typeProperties Azure MySQL database dataset properties. AzureMySqlTableDatasetTypeProperties (required)

AzureMySqlTableDatasetTypeProperties

Name Description Value
table Any object For Bicep, you can use the any() function.
tableName Any object For Bicep, you can use the any() function.

AzurePostgreSqlTableDataset

Name Description Value
type Type of dataset. 'AzurePostgreSqlTable'
typeProperties Azure PostgreSQL dataset properties. AzurePostgreSqlTableDatasetTypeProperties

AzurePostgreSqlTableDatasetTypeProperties

Name Description Value
schema Any object For Bicep, you can use the any() function.
table Any object For Bicep, you can use the any() function.
tableName Any object For Bicep, you can use the any() function.

AzureSearchIndexDataset

Name Description Value
type Type of dataset. 'AzureSearchIndex'
typeProperties Properties specific to this dataset type. AzureSearchIndexDatasetTypeProperties (required)

AzureSearchIndexDatasetTypeProperties

Name Description Value
indexName Any object For Bicep, you can use the any() function.(required)

AzureSqlDWTableDataset

Name Description Value
type Type of dataset. 'AzureSqlDWTable'
typeProperties Azure SQL Data Warehouse dataset properties. AzureSqlDWTableDatasetTypeProperties

AzureSqlDWTableDatasetTypeProperties

Name Description Value
schema Any object For Bicep, you can use the any() function.
table Any object For Bicep, you can use the any() function.
tableName Any object For Bicep, you can use the any() function.

AzureSqlMITableDataset

Name Description Value
type Type of dataset. 'AzureSqlMITable'
typeProperties Azure SQL Managed Instance dataset properties. AzureSqlMITableDatasetTypeProperties

AzureSqlMITableDatasetTypeProperties

Name Description Value
schema Any object For Bicep, you can use the any() function.
table Any object For Bicep, you can use the any() function.
tableName Any object For Bicep, you can use the any() function.

AzureSqlTableDataset

Name Description Value
type Type of dataset. 'AzureSqlTable'
typeProperties Azure SQL dataset properties. AzureSqlTableDatasetTypeProperties

AzureSqlTableDatasetTypeProperties

Name Description Value
schema Any object For Bicep, you can use the any() function.
table Any object For Bicep, you can use the any() function.
tableName Any object For Bicep, you can use the any() function.

AzureTableDataset

Name Description Value
type Type of dataset. 'AzureTable'
typeProperties Azure Table dataset properties. AzureTableDatasetTypeProperties (required)

AzureTableDatasetTypeProperties

Name Description Value
tableName Any object For Bicep, you can use the any() function.(required)

BinaryDataset

Name Description Value
type Type of dataset. 'Binary'
typeProperties Binary dataset properties. BinaryDatasetTypeProperties

BinaryDatasetTypeProperties

Name Description Value
compression The compression method used on a dataset. DatasetCompression
location Dataset location. DatasetLocation (required)

CassandraTableDataset

Name Description Value
type Type of dataset. 'CassandraTable'
typeProperties Cassandra dataset properties. CassandraTableDatasetTypeProperties

CassandraTableDatasetTypeProperties

Name Description Value
keyspace Any object For Bicep, you can use the any() function.
tableName Any object For Bicep, you can use the any() function.

CommonDataServiceForAppsEntityDataset

Name Description Value
type Type of dataset. 'CommonDataServiceForAppsEntity'
typeProperties Common Data Service for Apps entity dataset properties. CommonDataServiceForAppsEntityDatasetTypeProperties

CommonDataServiceForAppsEntityDatasetTypeProperties

Name Description Value
entityName Any object For Bicep, you can use the any() function.

ConcurObjectDataset

Name Description Value
type Type of dataset. 'ConcurObject'
typeProperties Properties specific to this dataset type. GenericDatasetTypeProperties

CosmosDbMongoDbApiCollectionDataset

Name Description Value
type Type of dataset. 'CosmosDbMongoDbApiCollection'
typeProperties CosmosDB (MongoDB API) database dataset properties. CosmosDbMongoDbApiCollectionDatasetTypeProperties (required)

CosmosDbMongoDbApiCollectionDatasetTypeProperties

Name Description Value
collection Any object For Bicep, you can use the any() function.(required)

CosmosDbSqlApiCollectionDataset

Name Description Value
type Type of dataset. 'CosmosDbSqlApiCollection'
typeProperties CosmosDB (SQL API) Collection dataset properties. CosmosDbSqlApiCollectionDatasetTypeProperties (required)

CosmosDbSqlApiCollectionDatasetTypeProperties

Name Description Value
collectionName Any object For Bicep, you can use the any() function.(required)

CouchbaseTableDataset

Name Description Value
type Type of dataset. 'CouchbaseTable'
typeProperties Properties specific to this dataset type. GenericDatasetTypeProperties

CustomDataset

Name Description Value
type Type of dataset. 'CustomDataset'
typeProperties Any object For Bicep, you can use the any() function.

Db2TableDataset

Name Description Value
type Type of dataset. 'Db2Table'
typeProperties Db2 table dataset properties. Db2TableDatasetTypeProperties

Db2TableDatasetTypeProperties

Name Description Value
schema Any object For Bicep, you can use the any() function.
table Any object For Bicep, you can use the any() function.
tableName Any object For Bicep, you can use the any() function.

DelimitedTextDataset

Name Description Value
type Type of dataset. 'DelimitedText'
typeProperties DelimitedText dataset properties. DelimitedTextDatasetTypeProperties

DelimitedTextDatasetTypeProperties

Name Description Value
columnDelimiter Any object For Bicep, you can use the any() function.
compressionCodec Any object For Bicep, you can use the any() function.
compressionLevel Any object For Bicep, you can use the any() function.
encodingName Any object For Bicep, you can use the any() function.
escapeChar Any object For Bicep, you can use the any() function.
firstRowAsHeader Any object For Bicep, you can use the any() function.
location Dataset location. DatasetLocation (required)
nullValue Any object For Bicep, you can use the any() function.
quoteChar Any object For Bicep, you can use the any() function.
rowDelimiter Any object For Bicep, you can use the any() function.

DocumentDbCollectionDataset

Name Description Value
type Type of dataset. 'DocumentDbCollection'
typeProperties DocumentDB Collection dataset properties. DocumentDbCollectionDatasetTypeProperties (required)

DocumentDbCollectionDatasetTypeProperties

Name Description Value
collectionName Any object For Bicep, you can use the any() function.(required)

DrillTableDataset

Name Description Value
type Type of dataset. 'DrillTable'
typeProperties Drill Dataset Properties DrillDatasetTypeProperties

DrillDatasetTypeProperties

Name Description Value
schema Any object For Bicep, you can use the any() function.
table Any object For Bicep, you can use the any() function.
tableName Any object For Bicep, you can use the any() function.

DynamicsAXResourceDataset

Name Description Value
type Type of dataset. 'DynamicsAXResource'
typeProperties Dynamics AX OData resource dataset properties. DynamicsAXResourceDatasetTypeProperties (required)

DynamicsAXResourceDatasetTypeProperties

Name Description Value
path Any object For Bicep, you can use the any() function.(required)

DynamicsCrmEntityDataset

Name Description Value
type Type of dataset. 'DynamicsCrmEntity'
typeProperties Dynamics CRM entity dataset properties. DynamicsCrmEntityDatasetTypeProperties

DynamicsCrmEntityDatasetTypeProperties

Name Description Value
entityName Any object For Bicep, you can use the any() function.

DynamicsEntityDataset

Name Description Value
type Type of dataset. 'DynamicsEntity'
typeProperties Dynamics entity dataset properties. DynamicsEntityDatasetTypeProperties

DynamicsEntityDatasetTypeProperties

Name Description Value
entityName Any object For Bicep, you can use the any() function.

EloquaObjectDataset

Name Description Value
type Type of dataset. 'EloquaObject'
typeProperties Properties specific to this dataset type. GenericDatasetTypeProperties

ExcelDataset

Name Description Value
type Type of dataset. 'Excel'
typeProperties Excel dataset properties. ExcelDatasetTypeProperties

ExcelDatasetTypeProperties

Name Description Value
compression The compression method used on a dataset. DatasetCompression
firstRowAsHeader Any object For Bicep, you can use the any() function.
location Dataset location. DatasetLocation (required)
nullValue Any object For Bicep, you can use the any() function.
range Any object For Bicep, you can use the any() function.
sheetIndex Any object For Bicep, you can use the any() function.
sheetName Any object For Bicep, you can use the any() function.

FileShareDataset

Name Description Value
type Type of dataset. 'FileShare'
typeProperties On-premises file system dataset properties. FileShareDatasetTypeProperties

FileShareDatasetTypeProperties

Name Description Value
compression The compression method used on a dataset. DatasetCompression
fileFilter Any object For Bicep, you can use the any() function.
fileName Any object For Bicep, you can use the any() function.
folderPath Any object For Bicep, you can use the any() function.
format The format definition of a storage. DatasetStorageFormat
modifiedDatetimeEnd Any object For Bicep, you can use the any() function.
modifiedDatetimeStart Any object For Bicep, you can use the any() function.

GoogleAdWordsObjectDataset

Name Description Value
type Type of dataset. 'GoogleAdWordsObject'
typeProperties Properties specific to this dataset type. GenericDatasetTypeProperties

GoogleBigQueryObjectDataset

Name Description Value
type Type of dataset. 'GoogleBigQueryObject'
typeProperties Google BigQuery Dataset Properties GoogleBigQueryDatasetTypeProperties

GoogleBigQueryDatasetTypeProperties

Name Description Value
dataset Any object For Bicep, you can use the any() function.
table Any object For Bicep, you can use the any() function.
tableName Any object For Bicep, you can use the any() function.

GreenplumTableDataset

Name Description Value
type Type of dataset. 'GreenplumTable'
typeProperties Greenplum Dataset Properties GreenplumDatasetTypeProperties

GreenplumDatasetTypeProperties

Name Description Value
schema Any object For Bicep, you can use the any() function.
table Any object For Bicep, you can use the any() function.
tableName Any object For Bicep, you can use the any() function.

HBaseObjectDataset

Name Description Value
type Type of dataset. 'HBaseObject'
typeProperties Properties specific to this dataset type. GenericDatasetTypeProperties

HiveObjectDataset

Name Description Value
type Type of dataset. 'HiveObject'
typeProperties Hive Properties HiveDatasetTypeProperties

HiveDatasetTypeProperties

Name Description Value
schema Any object For Bicep, you can use the any() function.
table Any object For Bicep, you can use the any() function.
tableName Any object For Bicep, you can use the any() function.

HttpDataset

Name Description Value
type Type of dataset. 'HttpFile'
typeProperties Properties specific to this dataset type. HttpDatasetTypeProperties

HttpDatasetTypeProperties

Name Description Value
additionalHeaders Any object For Bicep, you can use the any() function.
compression The compression method used on a dataset. DatasetCompression
format The format definition of a storage. DatasetStorageFormat
relativeUrl Any object For Bicep, you can use the any() function.
requestBody Any object For Bicep, you can use the any() function.
requestMethod Any object For Bicep, you can use the any() function.

HubspotObjectDataset

Name Description Value
type Type of dataset. 'HubspotObject'
typeProperties Properties specific to this dataset type. GenericDatasetTypeProperties

ImpalaObjectDataset

Name Description Value
type Type of dataset. 'ImpalaObject'
typeProperties Impala Dataset Properties ImpalaDatasetTypeProperties

ImpalaDatasetTypeProperties

Name Description Value
schema Any object For Bicep, you can use the any() function.
table Any object For Bicep, you can use the any() function.
tableName Any object For Bicep, you can use the any() function.

InformixTableDataset

Name Description Value
type Type of dataset. 'InformixTable'
typeProperties Informix table dataset properties. InformixTableDatasetTypeProperties

InformixTableDatasetTypeProperties

Name Description Value
tableName Any object For Bicep, you can use the any() function.

JiraObjectDataset

Name Description Value
type Type of dataset. 'JiraObject'
typeProperties Properties specific to this dataset type. GenericDatasetTypeProperties

JsonDataset

Name Description Value
type Type of dataset. 'Json'
typeProperties Json dataset properties. JsonDatasetTypeProperties

JsonDatasetTypeProperties

Name Description Value
compression The compression method used on a dataset. DatasetCompression
encodingName Any object For Bicep, you can use the any() function.
location Dataset location. DatasetLocation (required)

MagentoObjectDataset

Name Description Value
type Type of dataset. 'MagentoObject'
typeProperties Properties specific to this dataset type. GenericDatasetTypeProperties

MariaDBTableDataset

Name Description Value
type Type of dataset. 'MariaDBTable'
typeProperties Properties specific to this dataset type. GenericDatasetTypeProperties

MarketoObjectDataset

Name Description Value
type Type of dataset. 'MarketoObject'
typeProperties Properties specific to this dataset type. GenericDatasetTypeProperties

MicrosoftAccessTableDataset

Name Description Value
type Type of dataset. 'MicrosoftAccessTable'
typeProperties Microsoft Access table dataset properties. MicrosoftAccessTableDatasetTypeProperties

MicrosoftAccessTableDatasetTypeProperties

Name Description Value
tableName Any object For Bicep, you can use the any() function.

MongoDbAtlasCollectionDataset

Name Description Value
type Type of dataset. 'MongoDbAtlasCollection'
typeProperties MongoDB Atlas database dataset properties. MongoDbAtlasCollectionDatasetTypeProperties (required)

MongoDbAtlasCollectionDatasetTypeProperties

Name Description Value
collection Any object For Bicep, you can use the any() function.(required)

MongoDbCollectionDataset

Name Description Value
type Type of dataset. 'MongoDbCollection'
typeProperties MongoDB database dataset properties. MongoDbCollectionDatasetTypeProperties (required)

MongoDbCollectionDatasetTypeProperties

Name Description Value
collectionName Any object For Bicep, you can use the any() function.(required)

MongoDbV2CollectionDataset

Name Description Value
type Type of dataset. 'MongoDbV2Collection'
typeProperties MongoDB database dataset properties. MongoDbV2CollectionDatasetTypeProperties (required)

MongoDbV2CollectionDatasetTypeProperties

Name Description Value
collection Any object For Bicep, you can use the any() function.(required)

MySqlTableDataset

Name Description Value
type Type of dataset. 'MySqlTable'
typeProperties MySql table dataset properties. MySqlTableDatasetTypeProperties

MySqlTableDatasetTypeProperties

Name Description Value
tableName Any object For Bicep, you can use the any() function.

NetezzaTableDataset

Name Description Value
type Type of dataset. 'NetezzaTable'
typeProperties Netezza dataset properties. NetezzaTableDatasetTypeProperties

NetezzaTableDatasetTypeProperties

Name Description Value
schema Any object For Bicep, you can use the any() function.
table Any object For Bicep, you can use the any() function.
tableName Any object For Bicep, you can use the any() function.

ODataResourceDataset

Name Description Value
type Type of dataset. 'ODataResource'
typeProperties OData dataset properties. ODataResourceDatasetTypeProperties

ODataResourceDatasetTypeProperties

Name Description Value
path Any object For Bicep, you can use the any() function.

OdbcTableDataset

Name Description Value
type Type of dataset. 'OdbcTable'
typeProperties ODBC table dataset properties. OdbcTableDatasetTypeProperties

OdbcTableDatasetTypeProperties

Name Description Value
tableName Any object For Bicep, you can use the any() function.

Office365Dataset

Name Description Value
type Type of dataset. 'Office365Table'
typeProperties Office365 dataset properties. Office365DatasetTypeProperties (required)

Office365DatasetTypeProperties

Name Description Value
predicate Any object For Bicep, you can use the any() function.
tableName Any object For Bicep, you can use the any() function.(required)

OracleServiceCloudObjectDataset

Name Description Value
type Type of dataset. 'OracleServiceCloudObject'
typeProperties Properties specific to this dataset type. GenericDatasetTypeProperties

OracleTableDataset

Name Description Value
type Type of dataset. 'OracleTable'
typeProperties On-premises Oracle dataset properties. OracleTableDatasetTypeProperties

OracleTableDatasetTypeProperties

Name Description Value
schema Any object For Bicep, you can use the any() function.
table Any object For Bicep, you can use the any() function.
tableName Any object For Bicep, you can use the any() function.

OrcDataset

Name Description Value
type Type of dataset. 'Orc'
typeProperties ORC dataset properties. OrcDatasetTypeProperties

OrcDatasetTypeProperties

Name Description Value
location Dataset location. DatasetLocation (required)
orcCompressionCodec Any object For Bicep, you can use the any() function.

ParquetDataset

Name Description Value
type Type of dataset. 'Parquet'
typeProperties Parquet dataset properties. ParquetDatasetTypeProperties

ParquetDatasetTypeProperties

Name Description Value
compressionCodec Any object For Bicep, you can use the any() function.
location Dataset location. DatasetLocation (required)

PaypalObjectDataset

Name Description Value
type Type of dataset. 'PaypalObject'
typeProperties Properties specific to this dataset type. GenericDatasetTypeProperties

PhoenixObjectDataset

Name Description Value
type Type of dataset. 'PhoenixObject'
typeProperties Phoenix Dataset Properties PhoenixDatasetTypeProperties

PhoenixDatasetTypeProperties

Name Description Value
schema Any object For Bicep, you can use the any() function.
table Any object For Bicep, you can use the any() function.
tableName Any object For Bicep, you can use the any() function.

PostgreSqlTableDataset

Name Description Value
type Type of dataset. 'PostgreSqlTable'
typeProperties PostgreSQL table dataset properties. PostgreSqlTableDatasetTypeProperties

PostgreSqlTableDatasetTypeProperties

Name Description Value
schema Any object For Bicep, you can use the any() function.
table Any object For Bicep, you can use the any() function.
tableName Any object For Bicep, you can use the any() function.

PrestoObjectDataset

Name Description Value
type Type of dataset. 'PrestoObject'
typeProperties Presto Dataset Properties PrestoDatasetTypeProperties

PrestoDatasetTypeProperties

Name Description Value
schema Any object For Bicep, you can use the any() function.
table Any object For Bicep, you can use the any() function.
tableName Any object For Bicep, you can use the any() function.

QuickBooksObjectDataset

Name Description Value
type Type of dataset. 'QuickBooksObject'
typeProperties Properties specific to this dataset type. GenericDatasetTypeProperties

RelationalTableDataset

Name Description Value
type Type of dataset. 'RelationalTable'
typeProperties Relational table dataset properties. RelationalTableDatasetTypeProperties

RelationalTableDatasetTypeProperties

Name Description Value
tableName Any object For Bicep, you can use the any() function.

ResponsysObjectDataset

Name Description Value
type Type of dataset. 'ResponsysObject'
typeProperties Properties specific to this dataset type. GenericDatasetTypeProperties

RestResourceDataset

Name Description Value
type Type of dataset. 'RestResource'
typeProperties Properties specific to this dataset type. RestResourceDatasetTypeProperties

RestResourceDatasetTypeProperties

Name Description Value
additionalHeaders Any object For Bicep, you can use the any() function.
paginationRules Any object For Bicep, you can use the any() function.
relativeUrl Any object For Bicep, you can use the any() function.
requestBody Any object For Bicep, you can use the any() function.
requestMethod Any object For Bicep, you can use the any() function.

SalesforceMarketingCloudObjectDataset

Name Description Value
type Type of dataset. 'SalesforceMarketingCloudObject'
typeProperties Properties specific to this dataset type. GenericDatasetTypeProperties

SalesforceObjectDataset

Name Description Value
type Type of dataset. 'SalesforceObject'
typeProperties Salesforce object dataset properties. SalesforceObjectDatasetTypeProperties

SalesforceObjectDatasetTypeProperties

Name Description Value
objectApiName Any object For Bicep, you can use the any() function.

SalesforceServiceCloudObjectDataset

Name Description Value
type Type of dataset. 'SalesforceServiceCloudObject'
typeProperties Salesforce Service Cloud object dataset properties. SalesforceServiceCloudObjectDatasetTypeProperties

SalesforceServiceCloudObjectDatasetTypeProperties

Name Description Value
objectApiName Any object For Bicep, you can use the any() function.

SapBwCubeDataset

Name Description Value
type Type of dataset. 'SapBwCube'

SapCloudForCustomerResourceDataset

Name Description Value
type Type of dataset. 'SapCloudForCustomerResource'
typeProperties Sap Cloud For Customer OData resource dataset properties. SapCloudForCustomerResourceDatasetTypeProperties (required)

SapCloudForCustomerResourceDatasetTypeProperties

Name Description Value
path Any object For Bicep, you can use the any() function.(required)

SapEccResourceDataset

Name Description Value
type Type of dataset. 'SapEccResource'
typeProperties Sap ECC OData resource dataset properties. SapEccResourceDatasetTypeProperties (required)

SapEccResourceDatasetTypeProperties

Name Description Value
path Any object For Bicep, you can use the any() function.(required)

SapHanaTableDataset

Name Description Value
type Type of dataset. 'SapHanaTable'
typeProperties SAP HANA Table properties. SapHanaTableDatasetTypeProperties

SapHanaTableDatasetTypeProperties

Name Description Value
schema Any object For Bicep, you can use the any() function.
table Any object For Bicep, you can use the any() function.

SapOpenHubTableDataset

Name Description Value
type Type of dataset. 'SapOpenHubTable'
typeProperties Sap Business Warehouse Open Hub Destination Table properties. SapOpenHubTableDatasetTypeProperties (required)

SapOpenHubTableDatasetTypeProperties

Name Description Value
baseRequestId Any object For Bicep, you can use the any() function.
excludeLastRequest Any object For Bicep, you can use the any() function.
openHubDestinationName Any object For Bicep, you can use the any() function.(required)

SapTableResourceDataset

Name Description Value
type Type of dataset. 'SapTableResource'
typeProperties SAP Table Resource properties. SapTableResourceDatasetTypeProperties (required)

SapTableResourceDatasetTypeProperties

Name Description Value
tableName Any object For Bicep, you can use the any() function.(required)

ServiceNowObjectDataset

Name Description Value
type Type of dataset. 'ServiceNowObject'
typeProperties Properties specific to this dataset type. GenericDatasetTypeProperties

SharePointOnlineListResourceDataset

Name Description Value
type Type of dataset. 'SharePointOnlineListResource'
typeProperties Sharepoint online list dataset properties. SharePointOnlineListDatasetTypeProperties

SharePointOnlineListDatasetTypeProperties

Name Description Value
listName Any object For Bicep, you can use the any() function.

ShopifyObjectDataset

Name Description Value
type Type of dataset. 'ShopifyObject'
typeProperties Properties specific to this dataset type. GenericDatasetTypeProperties

SnowflakeDataset

Name Description Value
type Type of dataset. 'SnowflakeTable'
typeProperties Snowflake dataset properties. SnowflakeDatasetTypeProperties (required)

SnowflakeDatasetTypeProperties

Name Description Value
schema Any object For Bicep, you can use the any() function.
table Any object For Bicep, you can use the any() function.

SparkObjectDataset

Name Description Value
type Type of dataset. 'SparkObject'
typeProperties Spark Properties SparkDatasetTypeProperties

SparkDatasetTypeProperties

Name Description Value
schema Any object For Bicep, you can use the any() function.
table Any object For Bicep, you can use the any() function.
tableName Any object For Bicep, you can use the any() function.

SqlServerTableDataset

Name Description Value
type Type of dataset. 'SqlServerTable'
typeProperties On-premises SQL Server dataset properties. SqlServerTableDatasetTypeProperties

SqlServerTableDatasetTypeProperties

Name Description Value
schema Any object For Bicep, you can use the any() function.
table Any object For Bicep, you can use the any() function.
tableName Any object For Bicep, you can use the any() function.

SquareObjectDataset

Name Description Value
type Type of dataset. 'SquareObject'
typeProperties Properties specific to this dataset type. GenericDatasetTypeProperties

SybaseTableDataset

Name Description Value
type Type of dataset. 'SybaseTable'
typeProperties Sybase table dataset properties. SybaseTableDatasetTypeProperties

SybaseTableDatasetTypeProperties

Name Description Value
tableName Any object For Bicep, you can use the any() function.

TeradataTableDataset

Name Description Value
type Type of dataset. 'TeradataTable'
typeProperties Teradata dataset properties. TeradataTableDatasetTypeProperties

TeradataTableDatasetTypeProperties

Name Description Value
database Any object For Bicep, you can use the any() function.
table Any object For Bicep, you can use the any() function.

VerticaTableDataset

Name Description Value
type Type of dataset. 'VerticaTable'
typeProperties Vertica Properties VerticaDatasetTypeProperties

VerticaDatasetTypeProperties

Name Description Value
schema Any object For Bicep, you can use the any() function.
table Any object For Bicep, you can use the any() function.
tableName Any object For Bicep, you can use the any() function.

WebTableDataset

Name Description Value
type Type of dataset. 'WebTable'
typeProperties Web table dataset properties. WebTableDatasetTypeProperties (required)

WebTableDatasetTypeProperties

Name Description Value
index Any object For Bicep, you can use the any() function.(required)
path Any object For Bicep, you can use the any() function.

XeroObjectDataset

Name Description Value
type Type of dataset. 'XeroObject'
typeProperties Properties specific to this dataset type. GenericDatasetTypeProperties

XmlDataset

Name Description Value
type Type of dataset. 'Xml'
typeProperties Xml dataset properties. XmlDatasetTypeProperties

XmlDatasetTypeProperties

Name Description Value
compression The compression method used on a dataset. DatasetCompression
encodingName Any object For Bicep, you can use the any() function.
location Dataset location. DatasetLocation (required)
nullValue Any object For Bicep, you can use the any() function.

ZohoObjectDataset

Name Description Value
type Type of dataset. 'ZohoObject'
typeProperties Properties specific to this dataset type. GenericDatasetTypeProperties

Quickstart templates

The following quickstart templates deploy this resource type.

Template Description
Create a Data Factory, copy from Salesforce to Blob

Deploy to Azure
This template uses Azure Data Factory to perform data movement from Salesforce to Azure Blobs
Bulk copy using Azure Data Factory

Deploy to Azure
This template creates a V2 data factory that copies data in bulk an Azure SQL database to an Azure SQL data warehouse.
Create a V2 data factory

Deploy to Azure
This template creates a V2 data factory that copies data from a folder in an Azure Blob Storage to another folder in the storage.
Create a V2 data factory

Deploy to Azure
This template creates a V2 data factory that copies data from a folder in an Azure Blob Storage to a table in an Azure Database for MySQL.
Create a V2 data factory

Deploy to Azure
This template creates a V2 data factory that copies data from a folder in an Azure Blob Storage to a table in an Azure Database for PostgreSQL.
Create a V2 data factory

Deploy to Azure
This template creates a V2 data factory that copies data from a folder in an Azure Blob Storage to a table in an Azure SQL database.
Create a V2 data factory

Deploy to Azure
This template creates a V2 data factory that copies data from an on-premises SQL Server to an Azure blob storage