Como usar o BigQuery e o Cloud Logging para analisar o uso do BigQuery avaliações

Praveena M. · Revisado há over 5 years

Garrick Z. · Revisado há over 5 years

sim

Caio T. · Revisado há over 5 years

Vivek S. · Revisado há over 5 years

Soomin E. · Revisado há over 5 years

Ioan M. · Revisado há over 5 years

Shantanu S. · Revisado há over 5 years

Marek S. · Revisado há over 5 years

Joe F. · Revisado há over 5 years

Thibault R. · Revisado há over 5 years

Maciej W. · Revisado há over 5 years

Yonghai X. · Revisado há over 5 years

If sql errors in cloud shell run gcloud auth list to reinitialize.

Kenneth S. · Revisado há over 5 years

nice

Ramazan Can T. · Revisado há over 5 years

David J. · Revisado há over 5 years

Parthepan S. · Revisado há over 5 years

Lubna S. · Revisado há over 5 years

VIGNESH J. · Revisado há over 5 years

Gustavo C. · Revisado há over 5 years

Samu F. · Revisado há over 5 years

Lubna S. · Revisado há over 5 years

Lubna S. · Revisado há over 5 years

There is a problem with 2nd query: student_04_93348b4edaab@cloudshell:~ (qwiklabs-gcp-04-f3c3bc6b657c)$ bq query --location=us --use_legacy_sql=false --use_cache=false \ > 'select month, avg(mean_temp) as avgtemp > from `bigquery-samples.weather_geo.gsod` > where station_number = 947680 > and year = 2010 > group by month > order by month' Traceback (most recent call last): --- omitted --- File "/usr/lib/python3.7/http/client.py", line 1222, in putheader raise ValueError('Invalid header value %r' % (values[i],)) ValueError: Invalid header value b'/usr/bin/../lib/google-cloud-sdk/bin/bootstrapping/bq.py query --location=us --use_legacy_sql=false --use_cache=false select month, avg(mean_temp) as avgtemp\n from `bigquery-samples.weather_geo.gsod`\n'

Kurt S. · Revisado há over 5 years

Yoshimasa K. · Revisado há over 5 years

It wouldn't let me run the Cloud Shell queries so only 40% complete. Kept giving me error messages

Jon B. · Revisado há over 5 years