Get Started with BigQuery

Load data from Cloud Storage into BigQuery

Perform a query on the data using the BigQuery web UI

select int64_field_6 as hour, count(*) as hitcount from logdata.accesslog group by hour order by hour

Perform a query on the data using the bq command

bq query "select string_field_10 as request, count(*) as requestcount from logdata.accesslog group by request order by requestcount desc"

--

--

--

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Linux commands

How to install a Kubernetes Cluster on CentOS 8

Think less on servers… But How? Azure Functions! Tutorial with Docker integration

Cleaning our Rust with Monadic Functions

Best way to handle Git Push

7 fantastic ways to easily teach and learn coding in preschool today

coding in early childhood education

The cuStreamz Series: The Accelerated Kafka Datasource

How to run Nebula Mesh VPN on Synology DSM 7

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Prajwol KC

Prajwol KC

More from Medium

BigQuery: A guide to managing Cron Expression using UDF

Multi Cloud Data Security with GCP BigLake

How to read and write (sync) data from Google sheets to Bigquery

Ok google, Introduce me to GCP