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