Create a Data Factory account, Blob source, SQL sink and Copy Activity Pipeline
{"type": "microsoft.datafactory/factories", "apiversion": "2018-06-01", "name": "[parameters('datafactoryname')]", "location": "[parameters('location')]", "identity": {"type": "systemassigned"}}{"type": "microsoft.datafactory/factories/linkedservices", "apiversion": "2018-06-01", "name": "[format('{0}/{1}", parameters('datafactoryname'), variables('datafactorylinkedservicename'))]", "properties": {"type": "azureblobstorage", "typeproperties": {"connectionstring": "[format('defaultendpointsprotocol=https;accountname={0};accountkey={1}", parameters('storageaccountname'), listkeys(resourceid('microsoft.storage/storageaccounts", parameters('storageaccountname')), "2021-04-01').keys[0].value)]"}}, "dependson": ["[resourceid('microsoft.datafactory/factories", parameters('datafactoryname'))]", "[resourceid('microsoft.storage/storageaccounts", parameters('storageaccountname'))]"]}{"type": "microsoft.datafactory/factories/datasets", "apiversion": "2018-06-01", "name": "[format('{0}/{1}", parameters('datafactoryname'), variables('datafactorydatasetinname'))]", "properties": {"linkedservicename": {"referencename": "[variables('datafactorylinkedservicename')]", "type": "linkedservicereference"}, "type": "binary", "typeproperties": {"location": {"type": "azureblobstoragelocation", "container": "[format('{0}/default/{1}", parameters('storageaccountname'), parameters('blobcontainername'))]", "folderpath": "input", "filename": "emp.txt"}}}, "dependson": ["[resourceid('microsoft.storage/storageaccounts/blobservices/containers", split(format('{0}/default/{1}", parameters('storageaccountname'), parameters('blobcontainername')), "/')[0], split(format('{0}/default/{1}", parameters('storageaccountname'), parameters('blobcontainername')), "/')[1], split(format('{0}/default/{1}", parameters('storageaccountname'), parameters('blobcontainername')), "/')[2])]", "[resourceid('microsoft.datafactory/factories", parameters('datafactoryname'))]", "[resourceid('microsoft.datafactory/factories/linkedservices", parameters('datafactoryname'), variables('datafactorylinkedservicename'))]"]}{"type": "microsoft.datafactory/factories/datasets", "apiversion": "2018-06-01", "name": "[format('{0}/{1}", parameters('datafactoryname'), variables('datafactorydatasetoutname'))]", "properties": {"linkedservicename": {"referencename": "[variables('datafactorylinkedservicename')]", "type": "linkedservicereference"}, "type": "binary", "typeproperties": {"location": {"type": "azureblobstoragelocation", "container": "[format('{0}/default/{1}", parameters('storageaccountname'), parameters('blobcontainername'))]", "folderpath": "output"}}}, "dependson": ["[resourceid('microsoft.storage/storageaccounts/blobservices/containers", split(format('{0}/default/{1}", parameters('storageaccountname'), parameters('blobcontainername')), "/')[0], split(format('{0}/default/{1}", parameters('storageaccountname'), parameters('blobcontainername')), "/')[1], split(format('{0}/default/{1}", parameters('storageaccountname'), parameters('blobcontainername')), "/')[2])]", "[resourceid('microsoft.datafactory/factories", parameters('datafactoryname'))]", "[resourceid('microsoft.datafactory/factories/linkedservices", parameters('datafactoryname'), variables('datafactorylinkedservicename'))]"]}{"type": "microsoft.datafactory/factories/pipelines", "apiversion": "2018-06-01", "name": "[format('{0}/{1}", parameters('datafactoryname'), variables('pipelinename'))]", "properties": {"activities": [{"name": "mycopyactivity", "type": "copy", "policy": {"timeout": "7.00:00:00", "retry": 0, "retryintervalinseconds": 30, "secureoutput": false, "secureinput": false}, "typeproperties": {"source": {"type": "binarysource", "storesettings": {"type": "azureblobstoragereadsettings", "recursive": true}}, "sink": {"type": "binarysink", "storesettings": {"type": "azureblobstoragewritersettings"}}, "enablestaging": false}, "inputs": [{"referencename": "[variables('datafactorydatasetinname')]", "type": "datasetreference"}], "outputs": [{"referencename": "[variables('datafactorydatasetoutname')]", "type": "datasetreference"}]}]}, "dependson": ["[resourceid('microsoft.datafactory/factories", parameters('datafactoryname'))]", "[resourceid('microsoft.datafactory/factories/datasets", parameters('datafactoryname'), variables('datafactorydatasetinname'))]", "[resourceid('microsoft.datafactory/factories/datasets", parameters('datafactoryname'), variables('datafactorydatasetoutname'))]"]} 