Snowflake Update

The Snowflake Update transfer object updates one or more existing records in a table or database view in the Snowflake AI Data Cloud during data transfer. The transfer object thus acts as a transfer destination.

Dialog Overview

General Properties

Property	Description
Data Source	All Snowflake connections created in the Plug-ins section are available for selection here. If the desired connection does not yet exist, you can make it available in the Plug-ins section as the “Snowflake AI Data Cloud” plug-in.
Table	Table or database view on which the update is performed.
Available Columns	Columns in the table that have not yet been used.
Used Columns	Columns whose values will be updated during the update.

Move columns by double-clicking the column name or using the <, >, <<, and >> buttons.

Filter

The update requires a filter to unambiguously specify which records are updated. The structure and operation of the Filter tab are described in detail under Filters and Filter Groups.

warning

Use the update only with filters that are appropriate for the business context. A filter that is too broad or missing may unintentionally modify many records.

Return Value

The transfer object provides the number of rows actually updated as a data source.

Notes

note

The transfer object can also be selected for database views.

Example

The Snowflake AI Data Cloud handles the actual anomaly detection using its AI functions (e.g., the IS_ANOMALY column). The OPC Router only reports back that an action has been taken on the shop floor: As soon as an operator acknowledges a detected anomaly on the machine, they update the ACKNOWLEDGED (acknowledgment flag) and ACKNOWLEDGED_AT (acknowledgment time). The transfer object shown above is configured for this example.

Setting	Value
Table	PROCESS_ANOMALIES
Columns Used	ACKNOWLEDGED and ACKNOWLEDGED_AT – the new values are bound as targets. Any number of columns can be updated simultaneously.
Filter	ID = <eingang> – the primary key limits the change to exactly one row

You do not write any SQL—the OPC Router generates the appropriate statement from the configuration, essentially:

UPDATE PROCESS_ANOMALIES SET ACKNOWLEDGED = ?, ACKNOWLEDGED_AT = ? WHERE ID = ?

You can verify that exactly one record was changed (here, 1) by checking the number of updated rows returned.