Parameters   Output Objects  

Deletes Snowflake data.

Syntax

Remove-Snowflake [parameters]

Remarks

The Remove-Snowflake cmdlet allows you to use a syntax similar to SQL DELETE statements to delete Snowflake data.

$conn = Connect-Snowflake -Url 'https://myaccount.region.snowflakecomputing.com' -User 'Admin' -Password 'test123' -Database 'Northwind' -Warehouse 'TestWarehouse' Account 'Tester1'
Remove-Snowflake -Connection $conn -Table "[DemoDB].[PUBLIC].Products" -Id "22"

The Where parameter can also be used to specify the primary key:

Remove-Snowflake -Connection $conn -Table "exTablePowershell;" -Where "Id = 22"

The primary key can also be passed to the cmdlet along the pipeline:

Select-Snowflake -Connection $conn -Table [DemoDB].[PUBLIC].Products -Where "ProductName = 'Konbu'" | Remove-Snowflake