Google BigQuery

Go to: https://cloud.google.com/bigquery/web-ui-quickstart

And select query public dataset.

google_bigQuery_1

After you get to a welcome screen click on Compose Query.

Now you can query publicly available huge amounts of data.

You can copy/paste following query:

SELECT
  weight_pounds, state, year, gestation_weeks
FROM
  publicdata:samples.natality
ORDER BY weight_pounds DESC LIMIT 10;

To explore public datasets, here is a list of available sets:

https://cloud.google.com/bigquery/sample-tables

I have used github public dataset:

SELECT
 actor,
 created_at,
 repository_url,
 actor_attributes_login
 FROM
 publicdata:samples.github_timeline
 where actor is not null
 and actor = 'visualdensity'
 ORDER BY
 created_at asc
 LIMIT
 100;

And get the results like:

google_bigQuery_2

Happy querying!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s