如何从Azure数据工厂更新Azure表记录！ [英] How to Update Azure Table Record from Azure Data factory !!

问题描述

大家好，

我已经在Azure存储表中创建了一个具有lastupdatedate和表名的表.

I have created a table in Azure Storage table With lastupdatedate and tablename.

我正在尝试通过azure数据工厂覆盖此记录，但无法这样做.

I am trying to overwrite this record through azure data factory , But unable to do so.

它没有覆盖它，而是在表中创建了一条新记录.

Instead of overwriting it created a new record in the table.

请在这里帮助.

推荐答案

您可以使用azureTableInsertType 属性.

You could use the azureTableInsertType property.

https://docs.microsoft.com/zh-cn/azure/data-factory/connector-azure-table-storage#azure-table-as-a-sink-type

https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-table-storage#azure-table-as-a-sink-type

The mode to insert data into Azure Table. This property controls whether existing rows in the output table with matching partition and row keys have their values replaced or merged.

插入或合并实体 插入或替换实体

This setting applies at the row level not the table level. Neither option deletes rows in the output table that do not exist in the input. To learn about how the merge and replace settings work, see Insert or merge entityand Insert or replace entity.

如果只想为一个表名键入一个记录，也许可以将tableName用作RowKey?

Maybe you could use tableName as RowKey if you only want to key one record for one table name?

这篇关于如何从Azure数据工厂更新Azure表记录！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！