Parameters   Output Objects  

Searches Teradata data.

Syntax

Select-Teradata [parameters]

Remarks

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

$conn = Connect-Teradata -User 'Admin' -Password 'test123' -Database 'Northwind' -DataSource '127.0.0.1'
Select-Teradata -Connection $conn -Table "`"CData`".`"dbo`".NorthwindProducts" -Columns @("ProductId","ProductName") -Where "CategoryId='5'"