Skip to main content
Documentation
Technology areas
close
AI and ML
Application development
Application hosting
Compute
Data analytics and pipelines
Databases
Distributed, hybrid, and multicloud
Generative AI
Industry solutions
Networking
Observability and monitoring
Security
Storage
Cross-product tools
close
Access and resources management
Costs and usage management
Google Cloud SDK, languages, frameworks, and tools
Infrastructure as code
Migration
Related sites
close
Google Cloud Home
Free Trial and Free Tier
Architecture Center
Blog
Contact Sales
Google Cloud Developer Center
Google Developer Center
Google Cloud Marketplace
Google Cloud Marketplace Documentation
Google Cloud Skills Boost
Google Cloud Solution Center
Google Cloud Support
Google Cloud Tech Youtube Channel
/
English
Deutsch
Español
Español – América Latina
Français
Indonesia
Italiano
Português
Português – Brasil
中文 – 简体
中文 – 繁體
日本語
한국어
Console
Sign in
Looker
Overview
Looker
Guides
How-to guides and feature descriptions
Best Practices
Best practices and specific use cases
LookML Reference
Reference for Looker's LookML modeling language
API Reference
Reference for Looker's APIs
Resources
Release, support, and contract information
Community
Community forum for Looker
Looker Studio
Guides
How-to guides and feature descriptions
Community
Community forum for Looker Studio
Guides
Contact Us
Start free
Documentation
Overview
Looker
More
Looker Studio
More
Guides
Technology areas
More
Cross-product tools
More
Related sites
More
Console
Contact Us
Start free
Looker introduction
Landing pages
Looker introduction
Looker releases
Find and organize content
Send and share content
Retrieve and chart data
Create and edit dashboards and Looks
Get ready for development
Write LookML
Use embedding and the API
Set up and administer Looker
Improve your skills in Looker and Looker Studio
Personalizing Looker
Personalizing your user profile
Personalizing user account settings
Viewing your query history
Viewing your scheduled data deliveries
Viewing your conditional alert notifications
Viewing information about your session
Keyboard shortcuts in Looker
Looker glossary
Looker and Looker Studio shared terms and concepts
Looker error catalog
Find and organize content
Finding and viewing content
Finding content in Looker
Viewing dashboards
Viewing Looks in Looker
Looker filter expressions
Organizing content
Organizing and managing access to content
Presenting content with boards
Deleted and unused content for admins
Send and share content
Sharing data
One-time sharing
Downloading content
Public sharing, importing, and embedding of Looks
Sharing data from URLs
Periodic sharing
Using the Looker Scheduler to deliver content
Scheduling and sending dashboards
Scheduling deliveries to the Slack integration
Sharing data through an action hub
Configuring content deliveries for Looker users (Looker admins)
Conditional sharing
Conditionally delivering Looks and Explores
Alerts overview
Configuring alerts for Looker users (Looker admins)
Retrieve and chart data
Retrieving data using the Looker UI
Exploring data in Looker
Creating and editing Explores
Viewing and interacting with Explores
Filtering and limiting data
Merging results from different Explores
Looker filter expressions
Looker functions and operators
Adding custom formatting to numeric fields
Time formatting for charts
Retrieving data using connectors
Google Sheets
Looker Studio
SQL Interface
Microsoft Excel
Power BI
Tableau
ThoughtSpot
Creating your own fields
Using table calculations
Adding custom fields
Creating Looker expressions
Looker functions and operators
List of Looker functions and operators
abs
exp
ln
power
rand
pivot_index
pivot_where
matches_filter
Creating charts
Creating visualizations and graphs
Selecting an effective data visualization
Visualization types
Visualization types list
Column chart options
Bar chart options
Scatterplot chart options
Line chart options
Area chart options
Boxplot chart options
Waterfall chart options
Pie chart options
Donut Multiples chart options
Funnel chart options
Timeline chart options
Single value chart options
Single Record chart options
Table chart options
Table (legacy) chart options
Word cloud chart options
Google Maps chart options
Map (Legacy) chart options
Static Map (Regions) chart options
Static Map (Points) chart options
Color collections
Time formatting for charts
Customizing visualizations using the Chart Config Editor
Customizing visualizations using the Chart Config Editor
Creating a bullet chart
Creating a solid gauge chart
Creating a streamgraph chart
Creating a treemap chart
Creating a Sankey chart
Creating a dependency wheel chart
Creating a Venn diagram
Creating a sunburst chart
Creating an item chart
Create dashboards and Looks
Saving and editing Looks
List of dashboard documentation
Comparing user-defined and LookML dashboards
Creating user-defined dashboards
Creating user-defined dashboards
Editing user-defined dashboards
Adding saved content to dashboards (legacy feature)
Using Markdown in Markdown tiles
Adding and editing user-defined dashboard filters
Looker filter expressions
Cross-filtering dashboards
Creating and managing LookML dashboards
LookML dashboard overview
Building LookML dashboards
LookML dashboard parameters
Dashboard element parameters
Dashboard visualization list
Column chart parameters
Bar chart parameters
Scatter chart parameters
Line chart parameters
Area chart parameters
Pie chart parameters
Donut multiples chart parameters
Funnel chart parameters
Timeline chart parameters
Waterfall chart parameters
Text tile parameters
Button parameters
Single value chart parameters
Single record chart parameters
Table (legacy) chart parameters
Table chart parameters
Google Maps parameters
Map parameters
Coordinate map parameters
Choropleth map parameters
Boxplot chart parameters
Dashboard reference line parameters
Converting from LookML to user-defined dashboards
Getting dashboard LookML from a user-defined dashboard
Gemini in Looker
Gemini in Looker overview
Enable and administer Gemini in Looker
Enable for Looker (Google Cloud core)
Enable for Looker (original)
Enable for Looker Studio
Analyze and export data
Create custom Looker visualizatons
Write LookML using natural language
Conversational Analytics
Conversational Analytics - Query your data in natural language
Conversational Analytics in Looker
Conversational Analytics - Data agents
Troubleshooting Gemini in Looker issues
Looker reports
Enabling and disabling Looker reports
Create, view, and edit Looker reports
Overview of permissions for Looker reports
Move, share, and copy reports
Download charts and reports
Upload CSV files to Looker reports
Embed reports
Feature availability in Looker reports
Managing report connectors
Troubleshooting Looker reports
Monitoring Looker reports with System Activity
SQL in Looker
How Looker generates SQL
SQL Runner
SQL Runner basics
Using SQL Runner to create queries and Explores
Using SQL Runner to create derived tables
Managing database functions with SQL Runner
Develop in LookML
LookML overview
Introduction to LookML
LookML terms and concepts
Development Mode and Production Mode
Accessing LookML project files
Types of files in a LookML project
Concepts for SQL experts
LookML for SQL experts
SQL concepts for view files
SQL concepts for joins
SQL concepts for derived tables
LookML models and projects
Generating a LookML model
Creating a new LookML project
Accessing and editing project information
The Looker IDE
Looker IDE overview
File browser
Object browser
LookML metadata panel
Git and version control
Setting up and testing a Git connection
Configuring project version control settings
Using version control and deploying
Advanced deploy mode
Configuring the webhook deploy secret
Git command reference
Developing a data model with LookML
Managing LookML files and folders
Validating your LookML
Incorporating SQL and referring to LookML objects
Working with joins in LookML
Common LookML patterns
Customizing the user experience with LookML
Changing the Explore menu and field picker
Formatting data values with LookML
Creating required filters with LookML
Changing filter suggestions
Advanced LookML customization with Liquid
Templated filters and Liquid parameters
Liquid variable reference
Period over period measures
Creating derived tables from queries
Derived tables in Looker
Creating native derived tables
Incremental PDTs
Reusing and extending LookML code
Reusing code with extends
LookML refinements
Importing files from other projects
Looker Blocks
Optimizing performance with LookML
Caching queries
Aggregate awareness
Continuous Integration
Continuous Integration (CI) overview
SQL Validator
Assert Validator
Content Validator
LookML Validator
Creating a CI suite
Running CI suites
Viewing the results of a CI run
Content validation
Localizing your model
Connect your IDE to Looker using MCP Toolbox
LookML reference
Optimizing Looker performance
Index of Looker performance documentation
Performance overview
Using the Explore query tracker and Performance panel to monitor query performance
Considerations when building performant Looker dashboards
Optimize Looker performance
Aggregate awareness
Database connection pooling
System Activity dashboards
Understanding query performance metrics
Looker Marketplace
Looker Marketplace overview
Using the Looker Marketplace
Customizing Looker Marketplace Blocks
Using the Looker Data Dictionary
Configuring the LookML Diagram
Using the LookML Diagram
Application Development with Looker
Looker application API
Looker 4.0 API reference (latest)
Deprecated API reference
Notices
Looker API 4.0 Generally Available
Looker API 3.x Deprecation Notice
The Looker API now uses query slug values for query IDs
Getting started
Looker API overview
Getting started with the Looker API
API details
Looker API authentication
Using the API Explorer
I mastered Looker's API Explorer. What now?
Looker API authentication using OAuth
Looker API versioning
Looker API troubleshooting
Looker API and SDK support policies
SDKs
Looker API SDKs
Python
TypeScript
Ruby
Community posts
Using the Looker API to generate PDFs
Using Looker API to Create a Unique Schedule Plan from Every Distinct Dimension Value
Creating Users and Sending Custom Welcome Emails via API
How to Bulk Convert Looks to Lookless Dashboard Tiles (Using the Looker API)
Manage Folder Access with the API
Embedding Looker Content in Salesforce
Creating a Data Dictionary Using Looker's API
Localizing Looker with the Looker API and Google Translate API
Embedding
Getting Started
Embedding overview
Embedding Looker
Private embedding
Enabling signed embedding
Applying custom themes
Administering embed users
Security best practices for embedded analytics
Viewing embedded content
Private embedding
Signed embedding
Getting a signed embed URL
Cookieless embedding
Embedded Javascript events
Signed embedding time zone reference
Custom themes for embedded dashboards
Introduction to the Embed SDK
Embed SDK Demo
Embed SDK Reference
Implementing row-level segmentation for embedded Looker content
Troubleshooting Signed Embed Authentication Errors
Troubleshooting Signed Embed Permissions
Signed embed tool
Extension framework
Looker Extensions Overview
Looker extension framework
Building a Looker extension
Extension framework React and JavaScript code examples
Building tile extensions
Setting permissions for Looker extensions
Custom data delivery actions
Looker Actions Overview
Sharing data through an action hub
Looker actions - Google Drive
Looker actions - Google Sheets
Setting up a local action hub for actions that use OAuth and streaming
BigQuery writebacks using Looker actions on Cloud Run functions
Adding Actions to the Looker-Authored Actionhub
Running an Action Hub on Heroku
Action API Reference
Components
Looker components list of documentation
Looker components overview
Filter components overview
Visualization components overview
Get started with Looker visualization components
Building a tabbed dashboard with Looker components
Using visualization components and a dashboard ID to render a simple visualization
Using visualization components to render custom visualizations
Using visualization components to build a custom visualization
Visualization and Query property tables
Components reference documentation
Set up and administer Looker
Set up and administer Looker overview
Installation and maintenance
Choosing a hosting option
Looker-hosted installation steps
Customer-hosted installation
Managing a customer-hosted deployment
Configuring sign-in options for users
Looker instance hosting locations
Adding CI/CD workflow to Looker
Create a CI/CD workflow in Looker
Install and configure a CI/CD workflow in Looker
Use a CI/CD workflow in Looker
Setting up a database connection
Enabling secure database access
Database configuration instructions
Connecting Looker to your database
Database connection pooling
Dialect-specific instructions
Actian Avalanche
AlloyDB for PostgreSQL
Amazon Aurora PostgreSQL
Amazon Athena
Amazon Aurora MySQL
Amazon RDS for MySQL
Amazon RDS for PostgreSQL
Amazon Redshift, Redshift 2.1+, and Redshift Serverless 2.1+
Apache Druid
Apache Hive 2.3+ and 3.1.2+
Apache Spark 3+
ClickHouse
Cloudera Impala 3.1+
Databricks
DataVirtuality
Denodo
Dremio
Exasol
Firebolt
Google BigQuery Legacy SQL
Google BigQuery Standard SQL
Google Cloud SQL for MySQL
Google Cloud SQL for PostgreSQL
Google Spanner
Greenplum
MariaDB
Microsoft Azure Synapse Analytics
Microsoft Azure SQL Database
Microsoft Azure PostgreSQL
Microsoft SQL Server (MSSQL)
MongoDB Connector for BI
MySQL
Oracle
Oracle ADWC
PostgreSQL
PrestoDB
SAP HANA
SingleStore (formerly MemSQL)
Snowflake
Teradata
Trino
Vector
Vertica
Admin tutorials
Access control and permission management
Designing and configuring a system of access levels
Creating connections
System Activity pages
Creating Looker usage reports with System Activity Explores
Understanding query performance metrics
Making announcements to your users
Managing business user features
Deleting personal user information
Using time zone settings
Supported user-interface languages
Localizing number formatting
Admin panel reference
General pages
General pages overview
Settings
Labs
Legacy features
Homepage
Private Label
Internal Help resources
Support Access
Localization
Export
System Activity dashboards
Users pages
Users pages overview
Users
Groups
Roles
Content access
User attributes
Custom welcome email
Login lockouts
Database pages
Database pages overview
Connections
Queries
Persistent Derived Tables
Datagroups
Alerts & Schedules pages
Alerts & Schedules pages overview
Alerts
Alert History
Schedules
Schedule History
Scheduled Emails
Platform pages
Platform pages overview
Actions
API
BI Connectors
Continuous Integration
Embed
Extension Framework
Gemini in Looker
Marketplace
Themes
SMTP
Visualizations
Looker Studio Pro
Authentication pages
Authentication pages overview
Password requirements
Two-factor authentication
Google authentication
LDAP authentication
SAML authentication
OpenID Connect authentication
Sessions
Enabling the alternate login option
Performance Center pages
Content guardrails
Server pages
Server pages overview
IP Allowlist
Log
Usage
Looker mobile application
Administration
Enabling the mobile application for your instance
Installing the mobile application on your mobile device
Using the Looker mobile application
Signing in to the mobile application
Navigating to content in the mobile application
Viewing Looks in the mobile application
Viewing dashboards in the mobile application
Alerts in the mobile application
Looker Mobile (Legacy) application
Looker (Google Cloud core)
Overview of Looker (Google Cloud core)
List of documentation
Looker (Google Cloud core) overview
Feature availability
Features and entitlements
Networking options
The Looker service account
Release overview
Locations
Use the sample LookML project
Quickstarts
Quickstart overview
Create a Looker (Google Cloud core) public secure connections standard edition instance
Create a database connection for a public secure connections instance
Generate a model from sample data
Model your data in LookML
Build a Look with sample data
Build a dashboard with sample data
Create OAuth authorization credentials
Create a public secure connections instance
Create a private connections (Private Service Connect) instance
Looker (Google Cloud core) Private Service Connect documentation
Use Private Service Connect
Create a Private Service Connect instance
Create a private connections (private services access) instance
Looker (Google Cloud core) private services access documentation
Create a private services access instance
Set up access to an instance
Access an instance from the internet
Set up and access a custom domain for a public secure connections instance
Access a Private Service Connect instance from the internet
Access an instance through a private network
Access a private connections instance with private services access
Access a Private Service Connect instance through a private network
Connect to external services
BigQuery default connection for Looker (Google Cloud core)
Connect to your database
Connect to an instance that uses private connections (private services access) from Looker Studio Pro or Looker reports
Access external services using private services access
Outbound access to external services using Private Service Connect
Authentication and authorization
Authentication methods
Access control with IAM
Use Google OAuth for user authentication
Use SAML for user authentication
Use OpenID Connect for user authentication
Administer a Looker (Google Cloud core) instance
Administer an instance from within Looker
Looker (Google Cloud core) admin settings
Managing users within Looker (Google Cloud core)
Prepare an instance for users
Administer an instance from the Google Cloud console
List of administration documentation
View and edit details about an instance
Set up a custom domain for an instance
View information about a custom domain
Delete a custom domain
Accept Looker Studio Pro licenses for an instance
VPC Service Controls
Enable CMEK
Enable FIPS 140-2 level 1 compliance
Restrict TLS cipher suites
Import or export data from an instance
Manage maintenance policies for an instance
Back up and restore an instance
Self-service migration from Looker (original) to Looker (Google Cloud core)
Delete and restart an instance