To unlock the magic of Looker, data experts at each organization describe their data in a lightweight modeling language called LookML. LookML tells Looker how to query data, so everyone in the organization can create reports and dashboards without needing to understand the behind-the-scenes details. This page outlines the documentation on preparing to write LookML.
The following pages help you understand the basics of developing in Looker:
- How a Project Works in Looker — Understand the basic concepts and structure of a project in Looker.
- Development Mode and Production Mode — Understand the differences between Development Mode and Production Mode.
- LookML Project Files — Get an overview of the types of files that may exist in a project in Looker.
- Understanding Model and View Files — Build model and view files.
- Understanding Other Project Files — Add dashboard, document, data, project manifest, locale strings, explore, data test, and other files to your project.
- Working with Folders in the IDE — Use IDE folders to organize your files in your LookML project.
SQL in Looker
The following pages help you understand how to use SQL with Looker:
- How Looker Generates SQL — Learn how Looker generates SQL from LookML.
- SQL Runner Basics — Learn about SQL Runner and how to use it.
- Using SQL Runner to Create Queries and Explores — Use SQL Runner to issue and debug SQL queries.
- Using SQL Runner to Create Derived Tables — Use SQL Runner to create and debug derived tables.
- Managing Database Functions with SQL Runner — Issue SQL queries, create derived tables, and get database information with SQL Runner.
Creating and Editing Projects
The following pages help you understand how to create and edit projects with Looker:
- Creating a New LookML Project — Create a LookML project and configure a model.
- Accessing and Editing Project Information — Access and make changes to LookML projects.
- Generating a Model — Automatically generate a basic LookML model.
Git and Version Control
The following pages help you understand how to set up and configure version control for Looker developers:
- Setting Up and Testing a Git Connection — Connect to a Git repository and integrate it with Looker.
- Configuring Project Version Control Settings — Configure a project for use with Git and set options for using your Git repository with Looker.
- Configuring the Webhook Deploy Secret — Configure, change, or remove the deploy secret for a repository’s webhook.
- Using Version Control and Deploying — Create and manage Git branches, commit, and deploy using Git.
- Git Command Reference — View a list of available Git commands and their descriptions.
Setting Up a Database Connection
The following pages help you understand how to connect to a database that can be used for LookML modeling:
- Enabling Secure Database Access — Take the first step in connecting a database: Choose an option to secure data between Looker and your database.
- Database Configuration Instructions — View links for database-specific instructions for configuring your database to work with Looker.
- Connecting Looker to Your Database — Learn how to connect your database and Looker.
- Testing Database Connectivity — Test and troubleshoot the connection to your database.
Using the Looker Marketplace — Use the Looker Marketplace to install, deploy, and manage pre-built Looker applications, models, Looker-managed databases for popular data sources, and visualization types.