Skip to main content

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 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.
Labels:

Comments

Post a Comment

Popular posts from this blog

ChatGPT Prompting Cheat Sheet

Post a Comment
Read more

30 Free APIs to Boost Your Productivity

  APIs (Application Programming Interfaces) allow developers to access and integrate the functionality of other software systems into their own applications. In the world of productivity, there are numerous APIs available that can help you streamline your workflows, manage your tasks and projects, and get more done in less time. Here are 30 free productive APIs that you can use to boost your productivity: Google Maps API: This API allows developers to access and customize Google Maps for their own websites and applications. It includes features such as directions, geocoding, and real-time traffic updates. Documentation can be found at https://developers.google.com/maps/ Trello API: This API allows developers to access and manipulate data from Trello, a popular project management and organization tool. It can be used to create, read, update, and delete Trello boards, lists, and cards. Documentation can be found at https://developers.trello.com/ Asana API: This API allows developers...
Post a Comment
Read more

How To Download Popular e-books for free?

 T here are many reading enthusiasts out there who crave the daily dose of reading. Reading is the best form of escape from bitter and hectic lives. Reading stimulates mental activity and helps in pacifying many mental disorders. It keeps the brain active and makes it retain power and capacity.  Here are some benefits of reading : Mental Wellness Reduces stress tremendously Improves knowledge and turns you into an SME (subject matter expert) by touching upon the length and breadth of a topic. Exhaustive vocabulary expansion Improves focus and concentration Steps to download free PDFs : Go to oiipdf.com You may use free text search or go for the alphabetic search given on the home page Click on your favourite book Click on Download PDF button  Clear the captch as shown in the screenshot  Click on Download and Voila!! you have the pdf copy ready .
Post a Comment
Read more