Hi everyone,
Connected Sheets for Looker is a super useful tool that just got even better! Your pivot tables can now pull up to 100,000 rows from a Looker explore. That’s a big bump up from the previous limit of 30,000!
In case you haven’t tried it yet, Connected Sheets provides an intuitive, built-in interface for querying your LookML explores, saved looks, or BigQuery tables directly in Google Sheets. This makes it easier than ever to analyze your data in the powerful & familiar spreadsheet format – without sacrificing your carefully curated data model and governed metric definitions. And of course, the queries can be refreshed with one click, or using AppSheet or the Sheets API to build custom automated workflows.
Check out the quick demo video below. You can find more information in the Looker documentation for Connected Sheets, or let us know your questions in the comments below. We’d also love to hear how Connected Sheets has unlocked new analytical use cases for you.
Note: the increased row limit does not apply when connecting to a saved look. Also, Connected Sheets still has limits on the total data size it is able to import.
