{"id":8674,"date":"2026-09-17T07:21:24","date_gmt":"2026-09-17T07:21:24","guid":{"rendered":"https:\/\/prwatech.in\/blog\/?p=8674"},"modified":"2026-09-18T17:10:32","modified_gmt":"2026-09-18T17:10:32","slug":"loading-public-data-into-big-query","status":"publish","type":"post","link":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/loading-public-data-into-big-query\/","title":{"rendered":"Loading Public Data into Big Query"},"content":{"rendered":"\r\n<h1>Accessing Public Datasets in BigQuery<\/h1>\r\n<p class=\"wp-block-paragraph\">BigQuery hosts a large collection of public datasets, real data covering everything from taxi trips to weather records, that anyone can query directly without loading or copying anything. This walks through finding one, exploring it, running a few real queries against it, and saving your work.<\/p>\r\n<h2>Step by Step Process of Accessing Public Datasets in BigQuery<\/h2>\r\n<h3>Step One: Open BigQuery<\/h3>\r\n<p>Open the console, then the menu, then BigQuery, then SQL Workspace.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Open Menu &gt; <a href=\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/\" target=\"_blank\" rel=\"noreferrer noopener\" data-type=\"URL\" data-id=\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/\">Big Query <\/a>&gt; SQL Workspace<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"358\" height=\"315\" class=\"wp-image-8675\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-75.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-75.png 358w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-75-300x264.png 300w\" sizes=\"auto, (max-width: 358px) 100vw, 358px\" \/><\/figure>\r\n<h3>Step Two: Add Public Data<\/h3>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Click on Add Data &gt; Explore Public Data sets.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"358\" height=\"205\" class=\"wp-image-8676\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-76.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-76.png 358w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-76-300x172.png 300w\" sizes=\"auto, (max-width: 358px) 100vw, 358px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3>Step Three: Find and Select a Dataset<\/h3>\r\n<p class=\"wp-block-paragraph\">Type NYC bike. The New York Citi Bike trips dataset appears. Click it.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"555\" height=\"280\" class=\"wp-image-8677\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-77.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-77.png 555w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-77-300x151.png 300w\" sizes=\"auto, (max-width: 555px) 100vw, 555px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3>Step Four: Add the Dataset<\/h3>\r\n<p class=\"wp-block-paragraph\">Click View Dataset.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"397\" height=\"270\" class=\"wp-image-8678\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-78.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-78.png 397w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-78-300x204.png 300w\" sizes=\"auto, (max-width: 397px) 100vw, 397px\" \/><\/figure>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">The dataset is added to your project. Expand it to see what is inside.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"628\" height=\"186\" class=\"wp-image-8679\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-79.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-79.png 628w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-79-300x89.png 300w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3>Step Five: Open a Table<\/h3>\r\n<p class=\"wp-block-paragraph\">Go to new_york_citibike, then citibike_trips.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"571\" height=\"313\" class=\"wp-image-8680\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-80.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-80.png 571w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-80-300x164.png 300w\" sizes=\"auto, (max-width: 571px) 100vw, 571px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3>Step Six: Explore the Table<\/h3>\r\n<p class=\"wp-block-paragraph\">Click Schema to see the table&#8217;s columns and types.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"608\" height=\"474\" class=\"wp-image-8681\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-81.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-81.png 608w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-81-300x234.png 300w\" sizes=\"auto, (max-width: 608px) 100vw, 608px\" \/><\/figure>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Click on Details. It will show the details of the\u00a0 Table.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"478\" height=\"440\" class=\"wp-image-8682\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-82.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-82.png 478w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-82-300x276.png 300w\" sizes=\"auto, (max-width: 478px) 100vw, 478px\" \/><\/figure>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Click on Preview. It will show the table.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"504\" height=\"536\" class=\"wp-image-8683\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-83.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-83.png 504w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-83-282x300.png 282w\" sizes=\"auto, (max-width: 504px) 100vw, 504px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3>Step Seven: Run a Query<\/h3>\r\n<p class=\"wp-block-paragraph\">Click Compose New Query.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"548\" height=\"224\" class=\"wp-image-8684\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-84.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-84.png 548w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-84-300x123.png 300w\" sizes=\"auto, (max-width: 548px) 100vw, 548px\" \/><\/figure>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Paste in the following, which finds the ten station pairs with the most trips between them:<\/p>\r\n<p>SELECT<br \/>\u00a0\u00a0MIN(start_station_name) AS start_station_name,<br \/>\u00a0\u00a0MIN(end_station_name) AS end_station_name,<br \/>\u00a0\u00a0COUNT(tripduration) AS num_trips<br \/>FROM<br \/>\u00a0\u00a0bigquery-public-data.new_york_citibike.citibike_trips<br \/>WHERE<br \/>\u00a0\u00a0start_station_id != end_station_id<br \/>GROUP BY<br \/>\u00a0\u00a0start_station_id,<br \/>\u00a0\u00a0end_station_id<br \/>ORDER BY<br \/>\u00a0\u00a0num_trips DESC<br \/>LIMIT<br \/>\u00a0\u00a010<\/p>\r\n<p>Click Run.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"562\" height=\"350\" class=\"wp-image-8685\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-85.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-85.png 562w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-85-300x187.png 300w\" sizes=\"auto, (max-width: 562px) 100vw, 562px\" \/><\/figure>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">The results appear below.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"437\" height=\"356\" class=\"wp-image-8686\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-86.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-86.png 437w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-86-300x244.png 300w\" sizes=\"auto, (max-width: 437px) 100vw, 437px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3>Step Eight: Review Query History and Job Details<\/h3>\r\n<p class=\"wp-block-paragraph\">Click Query History to see past queries you have run.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"445\" height=\"378\" class=\"wp-image-8687\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-87.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-87.png 445w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-87-300x255.png 300w\" sizes=\"auto, (max-width: 445px) 100vw, 445px\" \/><\/figure>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Click Job Information for a description of the job itself.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"478\" height=\"429\" class=\"wp-image-8688\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-88.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-88.png 478w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-88-300x269.png 300w\" sizes=\"auto, (max-width: 478px) 100vw, 478px\" \/><\/figure>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Click Execution Details for a breakdown of how the query actually ran.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"582\" height=\"353\" class=\"wp-image-8689\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-89.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-89.png 582w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-89-300x182.png 300w\" sizes=\"auto, (max-width: 582px) 100vw, 582px\" \/><\/figure>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">To save Query,<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Click on Save Query button.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"562\" height=\"102\" class=\"wp-image-8690\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-90.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-90.png 562w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-90-300x54.png 300w\" sizes=\"auto, (max-width: 562px) 100vw, 562px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3>Step Nine: Save the Query<\/h3>\r\n<p class=\"wp-block-paragraph\">Click Save Query.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"549\" height=\"285\" class=\"wp-image-8691\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-91.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-91.png 549w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-91-300x156.png 300w\" sizes=\"auto, (max-width: 549px) 100vw, 549px\" \/><\/figure>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Give it a name, choose its visibility, then click Save.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"628\" height=\"127\" class=\"wp-image-8692\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-92.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-92.png 628w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-92-300x61.png 300w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\" \/><\/figure>\r\n<h2>Step Ten: Set a Destination Table for Query Results<\/h2>\r\n<p>Click More, then Query Settings.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">In Query settings, you can choose the engine for query.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">You can change the destination for your query result. Instead of temporary table, you can choose a table in the project itself.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Select the destination table for query dataset.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Choose the <a href=\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/gcp-google-cloud-platform\/\" target=\"_blank\" rel=\"noreferrer noopener\" data-type=\"URL\" data-id=\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/gcp-google-cloud-platform\/\">project<\/a> and dataset.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Give the table name and write preference.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Click Save.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"448\" height=\"696\" class=\"wp-image-8693\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-93.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-93.png 448w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-93-193x300.png 193w\" sizes=\"auto, (max-width: 448px) 100vw, 448px\" \/><\/figure>\r\n<h3>Step Eleven: A Geospatial Distance Query<\/h3>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">This query uses BigQuery&#8217;s built in geography functions to calculate the real world distance each bike traveled, using each trip&#8217;s start and end station coordinates, then totals it per bike:<\/p>\r\n<p>WITH<br \/>\u00a0\u00a0trip_distance AS (<br \/>\u00a0\u00a0SELECT<br \/>\u00a0\u00a0\u00a0\u00a0bikeid,<br \/>\u00a0\u00a0\u00a0\u00a0ST_Distance(ST_GeogPoint(s.longitude, s.latitude),<br \/>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0ST_GeogPoint(e.longitude, e.latitude)) AS distance<br \/>\u00a0\u00a0FROM<br \/>\u00a0\u00a0\u00a0\u00a0bigquery-public-data.new_york_citibike.citibike_trips,<br \/>\u00a0\u00a0\u00a0\u00a0bigquery-public-data.new_york_citibike.citibike_stations AS s,<br \/>\u00a0\u00a0\u00a0\u00a0bigquery-public-data.new_york_citibike.citibike_stations AS e<br \/>\u00a0\u00a0WHERE<br \/>\u00a0\u00a0\u00a0\u00a0start_station_id = s.station_id<br \/>\u00a0\u00a0\u00a0\u00a0AND end_station_id = e.station_id)<br \/>SELECT<br \/>\u00a0\u00a0bikeid,<br \/>\u00a0\u00a0SUM(distance) \/ 1000 AS total_distance<br \/>FROM<br \/>\u00a0\u00a0trip_distance<br \/>GROUP BY<br \/>\u00a0\u00a0bikeid<br \/>ORDER BY<br \/>\u00a0\u00a0total_distance DESC<br \/>LIMIT<br \/>\u00a0\u00a05<\/p>\r\n<p>ST_GeogPoint turns a longitude and latitude pair into a point on the map, and ST_Distance calculates the straight line distance between two such points, in meters. Dividing by 1000 converts the total into kilometers.<\/p>\r\n<p>Click Run.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"472\" height=\"435\" class=\"wp-image-8694\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-94.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-94.png 472w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-94-300x276.png 300w\" sizes=\"auto, (max-width: 472px) 100vw, 472px\" \/><\/figure>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">The results are saved into the destination table you configured earlier.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"341\" height=\"294\" class=\"wp-image-8695\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-95.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-95.png 341w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-95-300x259.png 300w\" sizes=\"auto, (max-width: 341px) 100vw, 341px\" \/><\/figure>\r\n\r\n\r\n\r\n<h2>Step Twelve: Query a Public Weather Dataset<\/h2>\r\n<p class=\"wp-block-paragraph\">This pulls daily rainfall readings for a specific weather station from a public weather dataset:<\/p>\r\n<p>SELECT<br \/>\u00a0\u00a0wx.date,<br \/>\u00a0\u00a0wx.value \/ 10.0 AS prcp<br \/>FROM<br \/>\u00a0\u00a0bigquery-public-data.ghcn_d.ghcnd_2015 AS wx<br \/>WHERE<br \/>\u00a0\u00a0id = &#8220;USW00094728&#8221;<br \/>\u00a0\u00a0AND qflag IS NULL<br \/>\u00a0\u00a0AND element = &#8220;PRCP&#8221;<br \/>ORDER BY<br \/>\u00a0\u00a0wx.date<\/p>\r\n<p>Click Run.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"363\" height=\"288\" class=\"wp-image-8696\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-96.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-96.png 363w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-96-300x238.png 300w\" sizes=\"auto, (max-width: 363px) 100vw, 363px\" \/><\/figure>\r\n\r\n\r\n\r\n<h2>Do You Pay to Query a Public Dataset<\/h2>\r\n<p class=\"wp-block-paragraph\">Storing a public dataset costs you nothing, Google covers that as the publisher. Querying one is different. Query costs are billed to whichever project runs the query, the same as querying your own data, and they count against the same monthly free tier that applies to all your BigQuery usage, the first terabyte processed each month at no charge. In practice, this means casual use of public datasets is genuinely free for most people, but a large or repeated query against a big public dataset uses up the same free allowance as querying your own tables would.<\/p>\r\n<h2>Common Mistakes to Avoid<\/h2>\r\n<ul>\r\n<li>Copying a query from a document with curly quotation marks left in. Retype straight quotes around any string values before running it.<\/li>\r\n<li>Assuming a saved query without a destination table will keep its results. Query results land in a temporary table by default, which disappears after your session, unless you set a real destination table in Query Settings.<\/li>\r\n<li>Running a broad, unfiltered query against a very large public dataset without checking the estimated bytes processed first. It still counts toward your monthly free tier the same as any other query.<\/li>\r\n<\/ul>\r\n<p>That covers exploring, querying, and saving your work with a BigQuery public dataset. To go further, explore <a href=\"https:\/\/prwatech.in\/gcp-training-institutes-in-bangalore\/\"><strong><b>Prwatech&#8217;s Google Cloud training<\/b><\/strong><\/a>\u00a0program, which includes placement assistance.<\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>Accessing Public Datasets in BigQuery BigQuery hosts a large collection of public datasets, real data covering everything from taxi trips to weather records, that anyone can query directly without loading or copying anything. This walks through finding one, exploring it, running a few real queries against it, and saving your work. Step by Step Process [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1632,1],"tags":[728,1401,1403,736,732,1402,605,729,699,700,1399,984,735,617,683,684,685,611,1400,692],"class_list":["post-8674","post","type-post","status-publish","format-standard","hentry","category-bigquery","category-google-cloud-platform","tag-bigquery","tag-bigquery-console","tag-bigquery-documentation","tag-bigquery-in-cloud","tag-bigquery-sql","tag-bigquery-tutorial","tag-gcp","tag-gcp-bigquery","tag-gcp-certification","tag-gcp-cloud-console","tag-gcp-console","tag-gcp-course","tag-google-bigquery","tag-google-cloud","tag-google-cloud-certification","tag-google-cloud-console","tag-google-cloud-courses","tag-google-cloud-platform","tag-google-cloud-platform-tutorial","tag-google-cloud-training"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Accessing Public Datasets in BigQuery | Step by Step Process<\/title>\n<meta name=\"description\" content=\"Master accessing Public Datasets in BigQuery. Explore, query, &amp; save a public BigQuery dataset, like a geospatial example, &amp; whether querying public data actually costs you.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/loading-public-data-into-big-query\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Accessing Public Datasets in BigQuery | Step by Step Process\" \/>\n<meta property=\"og:description\" content=\"Master accessing Public Datasets in BigQuery. Explore, query, &amp; save a public BigQuery dataset, like a geospatial example, &amp; whether querying public data actually costs you.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/loading-public-data-into-big-query\/\" \/>\n<meta property=\"og:site_name\" content=\"Prwatech\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prwatech.in\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-09-17T07:21:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-09-18T17:10:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-75.png\" \/>\n\t<meta property=\"og:image:width\" content=\"358\" \/>\n\t<meta property=\"og:image:height\" content=\"315\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Prwatech\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@Eduprwatech\" \/>\n<meta name=\"twitter:site\" content=\"@Eduprwatech\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prwatech\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/loading-public-data-into-big-query\/\",\"url\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/loading-public-data-into-big-query\/\",\"name\":\"Accessing Public Datasets in BigQuery | Step by Step Process\",\"isPartOf\":{\"@id\":\"https:\/\/prwatech.in\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/loading-public-data-into-big-query\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/loading-public-data-into-big-query\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-75.png\",\"datePublished\":\"2026-09-17T07:21:24+00:00\",\"dateModified\":\"2026-09-18T17:10:32+00:00\",\"author\":{\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3\"},\"description\":\"Master accessing Public Datasets in BigQuery. Explore, query, & save a public BigQuery dataset, like a geospatial example, & whether querying public data actually costs you.\",\"breadcrumb\":{\"@id\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/loading-public-data-into-big-query\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/loading-public-data-into-big-query\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/loading-public-data-into-big-query\/#primaryimage\",\"url\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-75.png\",\"contentUrl\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-75.png\",\"width\":358,\"height\":315},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/loading-public-data-into-big-query\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/prwatech.in\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Loading Public Data into Big Query\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/prwatech.in\/blog\/#website\",\"url\":\"https:\/\/prwatech.in\/blog\/\",\"name\":\"Prwatech\",\"description\":\"Share Ideas, Start Something Good.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/prwatech.in\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3\",\"name\":\"Prwatech\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g\",\"caption\":\"Prwatech\"},\"url\":\"https:\/\/prwatech.in\/blog\/author\/prwatech123\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Accessing Public Datasets in BigQuery | Step by Step Process","description":"Master accessing Public Datasets in BigQuery. Explore, query, & save a public BigQuery dataset, like a geospatial example, & whether querying public data actually costs you.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/loading-public-data-into-big-query\/","og_locale":"en_US","og_type":"article","og_title":"Accessing Public Datasets in BigQuery | Step by Step Process","og_description":"Master accessing Public Datasets in BigQuery. Explore, query, & save a public BigQuery dataset, like a geospatial example, & whether querying public data actually costs you.","og_url":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/loading-public-data-into-big-query\/","og_site_name":"Prwatech","article_publisher":"https:\/\/www.facebook.com\/prwatech.in\/","article_published_time":"2026-09-17T07:21:24+00:00","article_modified_time":"2026-09-18T17:10:32+00:00","og_image":[{"width":358,"height":315,"url":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-75.png","type":"image\/png"}],"author":"Prwatech","twitter_card":"summary_large_image","twitter_creator":"@Eduprwatech","twitter_site":"@Eduprwatech","twitter_misc":{"Written by":"Prwatech","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/loading-public-data-into-big-query\/","url":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/loading-public-data-into-big-query\/","name":"Accessing Public Datasets in BigQuery | Step by Step Process","isPartOf":{"@id":"https:\/\/prwatech.in\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/loading-public-data-into-big-query\/#primaryimage"},"image":{"@id":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/loading-public-data-into-big-query\/#primaryimage"},"thumbnailUrl":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-75.png","datePublished":"2026-09-17T07:21:24+00:00","dateModified":"2026-09-18T17:10:32+00:00","author":{"@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3"},"description":"Master accessing Public Datasets in BigQuery. Explore, query, & save a public BigQuery dataset, like a geospatial example, & whether querying public data actually costs you.","breadcrumb":{"@id":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/loading-public-data-into-big-query\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/loading-public-data-into-big-query\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/loading-public-data-into-big-query\/#primaryimage","url":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-75.png","contentUrl":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-75.png","width":358,"height":315},{"@type":"BreadcrumbList","@id":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/loading-public-data-into-big-query\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prwatech.in\/blog\/"},{"@type":"ListItem","position":2,"name":"Loading Public Data into Big Query"}]},{"@type":"WebSite","@id":"https:\/\/prwatech.in\/blog\/#website","url":"https:\/\/prwatech.in\/blog\/","name":"Prwatech","description":"Share Ideas, Start Something Good.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/prwatech.in\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3","name":"Prwatech","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g","caption":"Prwatech"},"url":"https:\/\/prwatech.in\/blog\/author\/prwatech123\/"}]}},"_links":{"self":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/8674","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/comments?post=8674"}],"version-history":[{"count":8,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/8674\/revisions"}],"predecessor-version":[{"id":11790,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/8674\/revisions\/11790"}],"wp:attachment":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/media?parent=8674"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/categories?post=8674"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/tags?post=8674"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}