您现在访问的是微软AZURE全球版技术文档网站,若需要访问由世纪互联运营的MICROSOFT AZURE中国区技术文档网站,请访问 https://docs.azure.cn.

什么是一键式引入?What is one-click ingestion?

一键式引入使数据引入过程简单、快速和直观。One-click ingestion makes the data ingestion process easy, fast, and intuitive. 一键式引入可帮助你快速开始引入数据、创建数据库表、映射结构。One-click ingestion helps you ramp-up quickly to start ingesting data, creating database tables, mapping structures. 从不同类型的源中选择不同数据类型的数据,可以是一次性引入过程,也可以是连续引入过程。Select data from different kinds of sources in different data formats, either as a one-time or continuous ingestion process.

一键式引入提供以下实用功能:The following features make one-click ingestion so useful:

  • 引入向导引导的直观体验Intuitive experience guided by the ingestion wizard
  • 几分钟内即可引入数据Ingest data in a matter of minutes
  • 从不同类型的源引入数据:本地文件、blob 和容器(最多 10,000 个 blob)Ingest data from different kinds of sources: local file, blobs, and containers (up to 10,000 blobs)
  • 引入各种格式的数据Ingest data in a variety of formats
  • 将数据引入新表或现有表Ingest data into new or existing tables
  • 建议使用表映射和架构,表映射和架构易于更改Table mapping and schema is suggested to you and easy to change
  • 使用事件网格通过容器轻松快速地继续引入Continue ingestion easily and quickly from a container with Event Grid

首次引入数据时,或者在你不熟悉自己数据的架构时,一键式引入特别有用。One-click ingestion is particularly useful when ingesting data for the first time, or when your data's schema is unfamiliar to you.

先决条件Prerequisites

访问一键式向导Access the one-click wizard

一键式引入向导可以引导你完成一键式引入过程。The one-click ingestion wizard guides you through the one-click ingestion process.

  • 如需从你的群集中的“欢迎使用 Azure 数据资源管理器”主屏幕访问一键式引入向导,请完成前两个步骤(群集创建和数据库创建),然后选择“引入新数据”。To access the one-click ingestion wizard from the Welcome to Azure Data Explorer home screen in your cluster, complete the first two steps (cluster creation and database creation) and then select Ingest new data.

    从“欢迎使用 Azure 数据资源管理器”引入新数据

  • 若要从 Azure 数据资源管理器 Web UI 访问该向导,请右键单击 Azure 数据资源管理器 Web UI 左侧菜单中的“数据库”或“表”行,然后选择“引入新数据(预览版)” 。To access the wizard from the Azure Data Explorer web UI, right-click the database or table row in the left menu of the Azure Data Explorer web UI and select Ingest new data (preview).

    在 Web UI 中选择一键式引入

  • 要从 Azure 门户访问该向导,请从左侧菜单中选择“查询”,右键单击“数据库”或“表”,然后选择“引入新数据(预览版)” 。To access the wizard from the Azure portal, select Query from the left menu, right click on the database or table, and select Ingest new data (preview).

    从 Azure 门户访问一键式引入向导

一键式引入向导One-click ingestion wizard

备注

本部分介绍该向导的常规知识。This section describes the wizard in general. 你选择的选项取决于要引入的数据格式、要通过其进行引入的数据源类型,以及是引入到新表还是现有表中。The options you select depend on what data format you are ingesting, what kind of data source you are ingesting from, and whether you are ingesting into a new or existing table.

有关示例场景,请参阅:For sample scenarios, see:

该向导会引导你配置以下选项:The wizard guides you through the following options:

架构映射Schema mapping

服务会自动生成架构和引入属性,你可以对其进行更改。The service automatically generates schema and ingestion properties, which you can change. 可以使用现有的映射结构,也可以创建一个新的映射结构,具体取决于是引入到新表还是现有表。You can use an existing mapping structure or create a new one, depending on if you're ingesting to a new or existing table.

在“架构”选项卡中,执行以下操作:In the Schema tab, do the following actions:

  • 确认自动生成的压缩类型。Confirm the autogenerated compression type.
  • 选择数据的格式Choose the format of your data. 不同的格式会允许你进行进一步的更改。Different formats will allow you to make further changes.

文件格式File formats

一键式引入支持从以下任意格式的源数据引入新表:One-click ingestion supports ingesting a new table from source data in any of the following formats:

  • JSONJSON
  • CSVCSV
  • TSVTSV
  • SCSVSCSV
  • SOHSVSOHSV
  • TSVETSVE
  • PSVPSV

“编辑器”窗口Editor window

在“编辑器”窗口中,可以根据需要调整数据表列。In the Editor window, you can adjust data table columns as necessary.

表类型Table type 可用列调整Available column adjustments
新建New 新建列、删除列、升序排序、降序排序New column, Delete column, Sort ascending, Sort descending
ExistingExisting 新建列、升序排序、降序排序New column, Sort ascending, Sort descending

备注

可以随时打开“编辑器”窗格上方的命令编辑器At any time, you can open the command editor above the Editor pane. 在命令编辑器中,可以查看和复制基于输入生成的自动命令。In the command editor, you can view and copy the automatic commands generated from your inputs.

数据引入Data ingestion

完成架构映射和列操作后,引入向导将启动数据引入进程。Once you have completed schema mapping and column manipulations, the ingestion wizard will start the data ingestion process.

  • 从非容器源引入数据时,引入会立即生效。When ingesting data from non-container sources, the ingestion will take immediate effect.

  • 如果数据源是容器:If your data source is a container:

初始数据探索Initial data exploration

引入后,向导会允许你选择快速命令进行数据初始探索。After ingestion, the wizard gives you options to use Quick commands for initial exploration of your data.

后续步骤Next steps