Geo Awesomeness: CARTO boosts public geospatial data with Google BigQuery. “When location intelligence platform CARTO built its Data Observatory, the chief idea was to create an up-to-date index of location data. The recently released Data Observatory 2.0 takes that vision forward to provide Data Scientists with a scalable platform full of rich data in the format they really need it in! CARTO is now hosting geospatial datasets on Google Cloud’s BigQuery public datasets program.” You can learn more about CARTO via this article from TechCrunch.
Medium: Analysis of Google Political Ads using BigQuery. “Hello everyone, this is my first article on Medium. I have been interested in data science and analytics while working on my Masters project. I have tried my hand with different beginner datasets to learn some of the basics of Python, SQL, and other languages. However, I felt that repeating the same exercises got boring after a while, and I started losing interest in the subject. Then I got a hold of Google Cloud Services and the BigQuery platform.”
CBR: BigQuery: It’s Now Easier to Collaborate with Others and Public Datasets. “Google’s enterprise data warehouse BigQuery has released new collaboration and public dataset features. BigQuery enables researchers to conduct Structured Query Language queries within Google Cloud Platform.”
The Next Web: Google releases tools for probing Ethereum’s blockchain. “Google has provided users with a new avenue for directly interacting with Ethereum data. Services already exist that show information about wallet addresses and transactions, but until now, investigating the full breadth of data stored on the blockchain has been a cumbersome process. BigQuery can also connect directly with the Parity client.”
Google Blog: Analyze your business data with Explore in Google Sheets, use BigQuery too. “A few months back, we announced a new way for you to analyze data in Google Sheets using machine learning. Instead of relying on lengthy formulas to crunch your numbers, now you can use Explore in Sheets to ask questions and quickly gather insights. Check it out.”
The Met: Celebrating Six Months of Open Access, plus The Met on Google BigQuery. “It’s been six months since The Met launched its Open Access initiative, which made available all 375,000+ images of public-domain works in The Met collection under Creative Commons Zero (CC0). During what is just the dawn of this new initiative, the responses so far have been incredible.” Don’t miss the bit on BigQuery!
InfoQ: Google BigQuery Adds New Public Datasets . “Stack Overflow recently announced making its dataset available through Google’s BigQuery. Using regular SQL statements, developers can query the full set of Stack Overflow data including posts, votes, tags, and badges. Using BigQuery’s REST API developers can export data on demand using their tool of choice. Available datasets in BigQuery can be JOINed using plain SQL allowing developers to derive useful insights across domains.” Other data sets are available as well.
Google is connecting BigQuery to Google Drive and Google Sheets. “So here is what you can do now: Google will now allow BigQuery users to export results right to Google Sheets, its Excel competitor. In addition, BigQuery will also now be able to directly access files from Google Drive for analysis without having to first load them into BigQuery and the service can also directly query Google Sheets spreadsheets now as you edit them.”