本文共 1465 字,大约阅读时间需要 4 分钟。
好吧,如果此问题与默认超时配置有关,您可以在管道设置中的 "activities" 中添加这些脚本,将 timeout 设置为1小时:
"Policy": {
"concurrency": 1,
"timeout": "01:00:00"
}
---------- ----------更新
管道配置的整个JSON如下:
{
"name": "ADFTutorialPipelineOnPrem",
"properties": {
"description": "This pipeline has one Copy activity that copies data from an on-prem SQL to Azure blob",
"activities": [
{
"name": "CopyFromSQLtoBlob",
"description": "Copy data from on-prem SQL server to blob",
"type": "Copy",
"inputs": [
{
"name": "EmpOnPremSQLTable"
}
],
"outputs": [
{
"name": "OutputBlobTable"
}
],
"typeProperties": {
"source": {
"type": "SqlSource",
"sqlReaderQuery": "select * from emp"
},
"sink": {
"type": "BlobSink"
}
},
"Policy": {
"concurrency": 1,
"executionPriorityOrder": "NewestFirst",
"style": "StartOfInterval",
"retry": 0,
"timeout": "01:00:00"
}
}
],
"start": "2016-07-05T00:00:00Z",
"end": "2016-07-06T00:00:00Z",
"isPaused": false
}
}
下面的示例假设您在MySQL中创建了一个表“MyTable”,它包含一个名为“timestampcolumn”的列,用于时间序列数据 . 设置“external”:“true”通知Data Factory服务该表是数据工厂外部的并且不是由数据工厂中的活动生成的:
{
"name": "MySqlDataSet",
"properties": {
"published": false,
"type": "RelationalTable",
"linkedServiceName": "OnPremMySqlLinkedService",
"typeProperties": {},
"availability": {
"frequency": "Hour",
"interval": 1
},
"external": true,
"policy": {
"externalData": {
"retryInterval": "00:01:00",
"retryTimeout": "01:00:00",
"maximumRetry": 3
}
}
}
}
有关如何为Azure数据工厂创建管道的更多详细信息,请参阅this document
有关将数据从内部部署MySQL移动到Azure数据工厂的整个教程的更多信息,请参阅this link .
转载地址:http://cxfkp.baihongyu.com/