Cmdlets for Google BigQuery

Build 24.0.9060

Select-GoogleBigQuery Cmdlet

Parameters   Output Objects  

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'"

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060