Looker (Google Cloud core) provides a sample LookML project that can help you achieve the following:
- Learn to write LookML
- Use the Explore interface to query data
- View existing analyses with dashboards
The sample LookML project is provided on Looker (Google Cloud core) instances of all edition types.
The sample LookML project on Looker (Google Cloud core) instances includes curated LookML models that are based on the public BigQuery dataset
the Look eCommerce. This project is a good starting point for learning to build your own LookML models and modify existing models to customize the user experience.
When you create a Looker (Google Cloud core) instance, the sample LookML project is already configured on your instance as a bare repository using application default credentials (ADC) to connect to a BigQuery database managed by Google.
Before you begin: Enable the BigQuery API
Before you can modify the LookML, query the Explores, and view the sample dashboards from the sample LookML project, an admin must enable the BigQuery API for your Google Cloud project. You may need to refresh the console page to confirm that the API has been enabled.
View and interact with the sample LookML project
You can view the sample LookML project by navigating to the project called
sample_thelook_ecommerce in the Looker IDE. The
sample_thelook_ecommerce project includes four folders:
3_advanced_lookml. These folders include the following elements:
README.mdfiles with instructions and explanations of basic, intermediate, and advanced LookML concepts
- Predefined LookML models with a connection to the sample BigQuery connection
- Predefined LookML Explores and views that you can customize
By following the instructions in the project's
README.md files, you can learn to make changes to the sample LookML and see how those changes affect the Explore interface. The sample LookML project also includes pre-built dashboards that you can add to and modify to create sample analyses.
Access and edit the LookML project files
To access the LookML files within the sample LookML project, follow these steps:
- In the left navigation panel, select Develop to open the Develop menu.
- Select the
sample_thelook_ecommerceproject. By default, navigating to the sample project opens the
- Read the instructions in the
START_HERE_README.mdfiles, or navigate to a different project file.
- If you want to start testing out changes to the LookML, enter Development Mode and follow the instructions in the
Build queries using the sample Explores
By default, the sample LookML project has the following Explores defined:
- 1) Basic Ecommerce
- 2) Intermediate Ecommerce
- 3) Intermediate Ecommerce (Valid Orders only)
- 4) Advanced Ecommerce (Valid Orders only)
To access the sample Explores, follow these steps:
- In the left navigation panel, select Explore to open the Explore menu.
- In the Explore menu, select one of the sample Explores.
For more information about querying data with Explores, follow the instructions in the
README.md files or visit Viewing and interacting with Explores in Looker.
View and edit the sample dashboards
By default, when you create your instance, the following sample user-defined dashboards from the sample project appear in the Shared folder (called Your organization's folders) for your instance:
- Sample 1) Ecommerce Business Pulse - Basic
- Sample 2) Ecommerce Business Pulse - Intermediate
- Sample 3) Ecomerce Business Pulse - Advanced
To access the sample dashboards, follow these steps:
- In the left navigation panel, select Folders.
- On the All folders page, select Shared folders.
- On the Your organization's folders page, select one of the sample dashboards.
Change user access to the project
By default, users who have any of the default Looker roles will have the All model set on your Looker (Google Cloud core) instance. Therefore, by default, all users will be able to access all the models that are defined in the
If you want to exclude specific users from viewing or interacting with one or more models from the project, you can create a model set that doesn't include the models in
sample_thelook_ecommerce. Then, create a new role or update an existing role that is linked to the new, more limited model set.
Remove the sample LookML project
You can remove the sample project and connection from your instance. To remove the project, follow the instructions in Accessing and editing project information.
You can also delete the
sample_bigquery_connection connection by following the instructions on the Connections documentation page.
- Introduction to LookML
- LookML terms and concepts
- Creating a new LookML project
- Accessing LookML project files