Wednesday, February 1, 2023

Explore Google Cloud hosted Looker instances using Connected Sheets

What’s changing

We’re adding the ability to interactively explore modeled data from Looker, Google Cloud’s modern business intelligence platform, using Connected Sheets. This brings connectivity between the familiar interface of Google Sheets and the 50+ data sources available within Looker’s open ecosystem, including BigQuery, Cloud SQL, Snowflake, and Redshift. 

From a single source of truth, you can analyze data using pivot tables, charts, formulas, and other integrated data sources. Additionally, with this live connection, access is secured and your data will stay up to date. 

Getting started 

  • Admins: 
    • In order for users to take advantage of this feature, make sure Connected Sheets for Looker is enabled in Looker's Admin menu
    • Visit the Help Center to learn more about using Connected Sheets
  • End users: 
    • If enabled by your admin, follow these steps to explore Looker data using Connected Sheets: 
      • In a Google Sheet navigate to “Data” > “Data connectors” > “Connect to Looker” > enter in the URL of a Looker instance, for example: https://example.looker.com. You will then need to authorize Sheets to access your Looker data. After you connect to an Explore, you can see the available data and continue your analysis in Google Sheets. 
      • Visit the Help Center to learn more about Connected Sheets for Looker

Rollout pace 


Availability 

  • Available to Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Plus, Education Standard, the Teaching and Learning Upgrade, Frontline, and Nonprofits 
  • Not available legacy G Suite Basic and Business customers 
  • Available to users with personal Google Accounts 

Resources