Azure 数据工厂中带分隔符的文本格式Delimited text format in Azure Data Factory

• 10/19/2020
• • 

适用于： Azure 数据工厂 Azure Synapse Analytics（预览版）

若要 分析带分隔符的文本文件或以带分隔符的文本格式写入数据 ，请遵循此文章中的说明。Follow this article when you want to parse the delimited text files or write the data into delimited text format .

以下连接器支持带分隔符的文本格式：Amazon S3、Azure Blob、Azure Data Lake Storage Gen2、Azure 文件存储、文件系统、FTP、Google 云存储、HDFS、HTTP 和 SFTP。Delimited text format is supported for the following connectors: Amazon S3, Azure Blob, Azure Data Lake Storage Gen2, Azure File Storage, File System, FTP, Google Cloud Storage, HDFS, HTTP, and SFTP.

数据集属性Dataset properties

有关可用于定义数据集的各部分和属性的完整列表，请参阅数据集一文。For a full list of sections and properties available for defining datasets, see the Datasets article. 本部分提供带分隔符的文本数据集支持的属性列表。This section provides a list of properties supported by the delimited text dataset.

下面是 Azure Blob 存储上的带分隔符的文本数据集的示例：Below is an example of delimited text dataset on Azure Blob Storage:

{
    "name": "DelimitedTextDataset",
    "properties": {
        "type": "DelimitedText",
        "linkedServiceName": {
            "referenceName": "<Azure Blob Storage linked service name>",
            "type": "LinkedServiceReference"
        },
        "schema": [ < physical schema, optional, retrievable during authoring > ],
        "typeProperties": {
            "location": {
                "type": "AzureBlobStorageLocation",
                "container": "containername",
                "folderPath": "folder/subfolder",
            },
            "columnDelimiter": ",",
            "quoteChar": "\"",
            "escapeChar": "\"",
            "firstRowAsHeader": true,
            "compressionCodec": "gzip"
        }
    }
}

复制活动属性Copy activity properties

有关可用于定义活动的各部分和属性的完整列表，请参阅管道一文。For a full list of sections and properties available for defining activities, see the Pipelines article. 本部分提供带分隔符的文本源和接收器支持的属性列表。This section provides a list of properties supported by the delimited text source and sink.

带分隔符的文本作为源Delimited text as source

复制活动的 *source* 节支持以下属性。The following properties are supported in the copy activity *source* section.

formatSettings 下支持的 带分隔符的文本读取设置 ：Supported delimited text read settings under formatSettings:

"activities": [
    {
        "name": "CopyFromDelimitedText",
        "type": "Copy",
        "typeProperties": {
            "source": {
                "type": "DelimitedTextSource",
                "storeSettings": {
                    "type": "AzureBlobStorageReadSettings",
                    "recursive": true
                },
                "formatSettings": {
                    "type": "DelimitedTextReadSettings",
                    "skipLineCount": 3,
                    "compressionProperties": {
                        "type": "ZipDeflateReadSettings",
                        "preserveZipFileNameAsFolder": false
                    }
                }
            },
            ...
        }
        ...
    }
]

带分隔符的文本作为接收器Delimited text as sink

复制活动的 *sink* 节支持以下属性。The following properties are supported in the copy activity *sink* section.

formatSettings 下支持的 带分隔符的文本写入设置 ：Supported delimited text write settings under formatSettings:

后续步骤Next steps

• 复制活动概述Copy activity overview
• Lookup 活动Lookup activity
• GetMetadata 活动GetMetadata activity