Microsoft.DataFactory factories/datasets template reference

Template format

To create a Microsoft.DataFactory/factories/datasets resource, add the following JSON to the resources section of your template.

{
  "name": "string",
  "type": "Microsoft.DataFactory/factories/datasets",
  "apiVersion": "2018-06-01",
  "properties": {
    "additionalProperties": {},
    "description": "string",
    "structure": {},
    "schema": {},
    "linkedServiceName": {
      "type": "LinkedServiceReference",
      "referenceName": "string",
      "parameters": {}
    },
    "parameters": {},
    "annotations": [
      {}
    ],
    "folder": {
      "name": "string"
    },
    "type": "string"
  }
}

Property values

The following tables describe the values you need to set in the schema.

Microsoft.DataFactory/factories/datasets object

Name Type Required Value
name string Yes The dataset name.
type enum Yes datasets
-or-
Microsoft.DataFactory/factories/datasets

See Set name and type for child resources.
apiVersion enum Yes 2018-06-01
properties object Yes Dataset properties. - Dataset object

Dataset object

Name Type Required Value
additionalProperties object No Unmatched properties from the message are deserialized this collection
description string No Dataset description.
structure object No Columns that define the structure of the dataset. Type: array (or Expression with resultType array), itemType: DatasetDataElement.
schema object No Columns that define the physical type schema of the dataset. Type: array (or Expression with resultType array), itemType: DatasetSchemaDataElement.
linkedServiceName object Yes Linked service reference. - LinkedServiceReference object
parameters object No Parameters for dataset.
annotations array No List of tags that can be used for describing the Dataset. - object
folder object No The folder that this Dataset is in. If not specified, Dataset will appear at the root level. - DatasetFolder object
type string Yes GoogleAdWordsObjectDataset, AzureDataExplorerTableDataset, OracleServiceCloudObjectDataset, DynamicsAXResourceDataset, ResponsysObjectDataset, SalesforceMarketingCloudObjectDataset, VerticaTableDataset, NetezzaTableDataset, ZohoObjectDataset, XeroObjectDataset, SquareObjectDataset, SparkObjectDataset, ShopifyObjectDataset, ServiceNowObjectDataset, QuickBooksObjectDataset, PrestoObjectDataset, PhoenixObjectDataset, PaypalObjectDataset, MarketoObjectDataset, MariaDBTableDataset, MagentoObjectDataset, JiraObjectDataset, ImpalaObjectDataset, HubspotObjectDataset, HiveObjectDataset, HBaseObjectDataset, GreenplumTableDataset, GoogleBigQueryObjectDataset, EloquaObjectDataset, DrillTableDataset, CouchbaseTableDataset, ConcurObjectDataset, AzurePostgreSqlTableDataset, AmazonMWSObjectDataset, HttpDataset, AzureSearchIndexDataset, WebTableDataset, SqlServerTableDataset, SapOpenHubTableDataset, SapEccResourceDataset, SapCloudForCustomerResourceDataset, SalesforceObjectDataset, RelationalTableDataset, AzureMySqlTableDataset, OracleTableDataset, ODataResourceDataset, CosmosDbMongoDbApiCollectionDataset, MongoDbV2CollectionDataset, MongoDbCollectionDataset, FileShareDataset, Office365Dataset, AzureBlobFSDataset, AzureDataLakeStoreDataset, DynamicsEntityDataset, DocumentDbCollectionDataset, CassandraTableDataset, AzureSqlDWTableDataset, AzureSqlTableDataset, AzureTableDataset, AzureBlobDataset, SapHanaTableDataset, SapTableResourceDataset, TeradataTableDataset, DelimitedTextDataset, ParquetDataset, AmazonS3Dataset,AzureMariaDBTableDataset, RestResourceDataset, SapBwCubeDataset, SybaseTableDataset, SalesforceServiceCloudObjectDataset,
MicrosoftAccessTableDataset, PostgreSqlTableDataset, MySqlTableDataset, OdbcTableDataset, InformixTableDataset, Db2TableDataset, AmazonRedshiftTableDataset, CommonDataServiceForAppsEntityDataset, DynamicsCrmEntityDataset, CosmosDbSqlApiCollectionDataset, AzureSqlMITableDataset, BinaryDataset, OrcDataset, JsonDataset, AvroDataset

LinkedServiceReference object

Name Type Required Value
type enum Yes Linked service reference type. - LinkedServiceReference
referenceName string Yes Reference LinkedService name.
parameters object No Arguments for LinkedService.

DatasetFolder object

Name Type Required Value
name string No The name of the folder that this Dataset is in.

Quickstart templates

The following quickstart templates deploy this resource type.

Template Description
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
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.