Parameters   Output Objects  

Searches Snowflake data.

Syntax

Select-Snowflake [parameters]

Remarks

The Select-Snowflake cmdlet allows you to use a syntax similar to SQL SELECT statements to search Snowflake data.

$conn = Connect-Snowflake -Url 'https://myaccount.region.snowflakecomputing.com' -User 'Admin' -Password 'test123' -Database 'Northwind' -Warehouse 'TestWarehouse' Account 'Tester1'
Select-Snowflake -Connection $conn -Table "[DemoDB].[PUBLIC].Products" -Columns @("Id","ProductName") -Where "ProductName='Konbu'"