Answer: Linked services link data stores to an Azure data factory. Datasets represent data structures with in the data stores.
E.g
The below is a linked service created for a AzureSqlDatabase
{
"name": "AzureSqlLinkedService",
"properties": {
"hubName": "rnadf_hub",
"type": "AzureSqlDatabase",
"typeProperties": {
"connectionString": "Data Source=tcp:xxxx.database.windows.net,1433;Initial Catalog=xxxx;Integrated Security=False;User ID=xxx@yyyy;Password=**********;Connect Timeout=30;Encrypt=True"
}
}
}
The corresponding DataSet for an AzureSQLTable will be
{
"name": "InsertStudentDS",
"properties": {
"published": false,
"type": "AzureSqlTable",
"linkedServiceName": "AzureSqlLinkedService",
"typeProperties": {
"tableName": "tblStudent"
},
"availability": {
"frequency": "Hour",
"interval": 1
}
}
}
We can figure out that the Dataset picks up the information from the Linked Service from the property
"linkedServiceName": "AzureSqlLinkedService"
Asked In: Many Interviews |
Alert Moderator