Snowflake Delete

The Snowflake Delete transfer object deletes one or more records from 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 delete operation is performed.

Filter

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

warning

Delete operations are particularly critical from a business perspective. Use Snowflake Delete only with a unique filter, and verify the impact on downstream processes and historical data. The affected records will be permanently deleted.

Notes

note

The transfer object can also be selected for database views.

Example

The OPC Router removes obsolete telemetry records from MACHINE_TELEMETRY, for example, when resetting a test station. The filter restricts the deletion based on the MACHINE_ID. The transfer object shown above is configured for this example.

Setting	Value
Table	MACHINE_TELEMETRY
Filter	MACHINE_ID = <eingang>

The OPC Router generates the following query based on this:

DELETE FROM MACHINE_TELEMETRY WHERE MACHINE_ID = ?
```</eingang>