Google has increased the maximum row limit for Connected Sheets for Looker pivot tables to 100,000 rows, matching the earlier BigQuery expansion. This enhancement enables users to analyze substantially larger datasets from Looker within Google Sheets.
Feature Accessibility
The update is currently rolling out to both Rapid Release and Scheduled Release domains. It's available across all Google Workspace customers, including:
- Workspace Individual Subscribers
- Personal Google account users
- All Google Workspace customers
Enhanced Data Analysis Capabilities
Connected Sheets for Looker offers comprehensive data analysis features including:
Integration with over 60 databases that can be live-connected to Looker Ability to combine Looker data with existing Sheets data Access to familiar Sheets features like pivot tables Analysis of petabytes of data directly within Sheets
Technical Requirements
Users need access to their Looker instance URL to establish the connection. This integration enables analysis of Looker-modeled data from a single source of truth, providing a seamless experience for data manipulation and insight generation.
Data Integration Benefits
The platform allows users to maintain data consistency while leveraging the familiar Google Sheets interface. This combination facilitates deeper analysis through the integration of multiple data sources, all while working within the spreadsheet environment users are accustomed to.
