Using Google Connected Sheets

on






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 users and admins can check more info here to apply : Connected Sheets

Advantages :

  • Accessible from any connected devices like computers or mobile 
  • Easy to import data and do quick calculations/transformations on top of the data
  • It comes handy for business analysts and users.
  • To learn more : How to turn on connected sheets.

Availability 

G Suite editions 

  • Available to G Suite Business, G Suite Enterprise, G Suite for Education, G Suite Enterprise for Education, and G Suite for Nonprofits 
  • Not available to G Suite Basic.

Comments

Post a Comment