The Delete rows action deletes rows from the specified Snowflake table using the column name in which the rows are available.
概览
The Delete rows action removes one or more rows from a Snowflake table using the column name and the set of values to match the data in that column. The action returns the number of rows deleted as the response data.
注： Ensure that you add and configure the Connect action before proceeding with configuring the Delete rows action, as the Connect action provides the authentication context for the automation session.
设置
The following settings are available in the Delete rows action:
- 会话名称
-
指定连接操作创建的会话名称。 会话名称用作该操作的身份验证上下文。 根据连接设置选择以下两个选项之一。
- 会话名称： 直接指定会话名称，或为名称创建一个字符串变量，并使用插入值选项选择。
- 变量： 请选择使用插入值选项的现有 Snowflake 会话变量。
- 表名称
- Specifies the name of the target table.
- 主键列
- Specifies the name of the column that the action uses to identify the rows to delete.
- 主键值
- Specifies the values that are available in the column identified using the Primary Key Column setting. Use one of the following option to provide the values:
- 列表： Specify each value in a list with type and value. For each entry, select the value type and enter the value.
- 变量： Specify all values in a list variable and select the variable using the Insert a value option.
- 将输出分配到变量
- Specifies the number variable to store the response data that contains the number of rows that the action deletes from the table. 您可以从下拉列表中选择一个现有的数字变量，或使用创建变量选项创建一个并选择。