Context : On Google cloud tools for powershell opened window
Trying to query a bigquery table
An issue occurss during Start-BqJob -Query
On Cloud Tools for PowerShell window run these cmd
gcloud auth login
gcloud config set project my_projet
$job = Start-BqJob -Query "SELECT * FROM powerbiaudit_formatted.workspaces WHERE NAME like '%Bigquery%'" <--- ISSUE
Optional questions please : -what to do to save this SQL query result on a local (no bucket) as a CSV file ?
-which programme (executable) to run on a windows scheduler to to run this *.ps1 ?
Thanks a lot
HI
Context : On Google cloud tools for powershell opened window Trying to query a bigquery table An issue occurss during Start-BqJob -Query
On Cloud Tools for PowerShell window run these cmd
gcloud auth login gcloud config set project my_projet $job = Start-BqJob -Query "SELECT * FROM
powerbiaudit_formatted.workspaces
WHERE NAME like '%Bigquery%'" <--- ISSUEOptional questions please : -what to do to save this SQL query result on a local (no bucket) as a CSV file ? -which programme (executable) to run on a windows scheduler to to run this *.ps1 ? Thanks a lot
Christophe