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

AI tools other than ChatGPT to improve your productivity

  Everyone's talking about  #ChatGPT . But 90% of you are missing out on the AI revolution. Here are the top AI tools you NEED to know about. 1. Krisp: Krisp's AI removes background voices, noises, and echo from your calls, giving you peace of call Link:  https://krisp.ai/ 2. Beatoven: Create unique royalty-free music that elevates your story Link:  https://www.beatoven.ai/ 3. Cleanvoice: Automatically edit your podcast episodes Link:  https://cleanvoice.ai/ 4. Podcastle: Studio quality recording, right from your computer Link:  https://podcastle.ai/ 5. Flair: Design branded content in a flash Link:  https://flair.ai/ 6. Illustroke: Create killer vector images from text prompts Link:  https://illustroke.com/ 7. Patterned: Generate the exact patterns you need for and design Link:  https://www.patterned.ai/ 8. Stockimg: Generate the perfect stock photo you need, every time Link:  https://stockimg.ai/ 9. Copy: AI Generated copy, that actual...
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