Skip to main content

Posts

Showing posts with the label it google docs

Using Google Connected Sheets

Google has released a beta version of Google Connected Sheets with which you could play around bigger data sets on Google sheets. It makes its analytics datawarehouse BigQuery data available on web based Google sheets. With this new feature, there won't be any row limitations and can import and analyze billions of records on sheets. Google took a leap on UI by introducing Connected Sheets feature, that eventually becomes the face of BigQuery data. Connected sheets provides a new integration between Sheets and BigQuery that is designed to make analysis on data stored in BigQuery very easy, with no knowledge of SQL required. Changes in Sheets You may find : There is one extra option called "Sheets Data Connector" . It enables users to perform import/export of larger data sets up to 10 billion rows of BigQuery data without using any SQL commands/scripts. Other options in sheets remain intact such as formulas,pivot tables and other add-ons. GCP us...