Select-GoogleBigQuery Cmdlet
Searches Google BigQuery data.
Syntax
Select-GoogleBigQuery [parameters]
Remarks
The Select-GoogleBigQuery cmdlet allows you to use a syntax similar to SQL SELECT statements to search Google BigQuery data.
$conn = Connect-GoogleBigQuery -ProjectId 'NameOfProject' -DatasetId 'NameOfDataset' Select-GoogleBigQuery -Connection $conn -Table "[publicdata].[samples].github_nested" -Columns @("actor.attributes.email","repository.name") -Where "repository.name='EntityFramework'"