New to LookML development? Below is a list of resources to jump-start your learning.
1. Get access to Looker’s learning environment
One of the best ways to learn Looker and LookML is to play in a safe environment with plenty of code examples to copy. Looker can provide you with an account on our learning environment, learn.looker.com. Register for our free eLearning course, Getting started with LookML, and complete the first section, Learn.looker.com sign-up, to receive an account.
2. Learn how to use Looker to query and explore data
Knowing how to explore data in Looker will help you a great deal when you’re modeling your data in LookML. If you’re not familiar with using Looker to query, filter, and drill into data, we suggest the following:
- Start with the Retrieve and chart data tutorials. The links at the bottom of each page will guide you through a sequence of the most important Looker features.
- These videos will take you through the basics of exploring.
3. Review SQL basics before diving into LookML
Writing LookML requires an understanding of SQL queries. You don’t have to be a SQL guru, and even beginners can create powerful Looker models. But, in general, the deeper you go in LookML, the more you benefit from a deeper knowledge of SQL.
If you need a SQL refresher, here are some of our favorite resources:
- Khan Academy’s SQL Lessons interactive SQL tutorials
- SQLzoo interactive SQL tutorials
- Sam’s Teach Yourself SQL in 10 Minutes book by Ben Forta
4. Learn LookML fundamentals
These resources will jump-start your LookML knowledge. Use your learning account to experiment with different design patterns.
- Start with What is LookML? and LookML terms and concepts.
- Check out our LookML parameter reference by function.
- Continue to How Looker generates SQL and Advanced LookML concepts.
- Once you have a good grasp of LookML and SQL, read about our more advanced features like derived tables and templated filters.
After you’ve learned LookML basics, use these pages for details on each LookML parameter:
|Model LookML||Go to the Model parameters reference page|
|Explore LookML||Go to the Explore parameters reference page|
|Join LookML||Go to the Join parameters reference page|
|View LookML||Go to the View parameters reference page|
|Field LookML||Go to the Field parameters reference page|
|Dashboard LookML||Go to the Dashboard parameters reference page|
5. Consider Looker training
Looker offers several classes for business users, beginning Looker developers, and advanced Looker developers. Check out our training events page for more information.