Looker Performance Optimization - Episode 1

Key Concepts

• Looker instance performance optimization
• Project reduction and model simplification
• Henry: Open-source tool for Looker instance analysis
• Python virtual environment setup
• Looker API credentials configuration (looker.ini)

1. Introduction to Looker Performance Optimization

• Main Topic: Improving Looker instance performance.
• Key Point: Performance can be improved by reducing the number of projects and simplifying overly complex models.
• Context: This video is the first in a series about optimizing Looker instance performance.

2. Introducing Henry: The Open-Source Tool

• Main Topic: Introduction to Henry, a tool for cleaning up Looker instances.
• Key Details:
  • Henry is an open-source tool available at github.com/lookeropensource/henry.
  • Written in Python.
  • Offered free of charge without warranty.
  • Named as a pun on "Henry" vacuum cleaners.

3. System Requirements and Installation

• Main Topic: Setting up the environment to run Henry.
• Key Requirements:
  • Access to a Linux command line (any distribution).
  • Python 3.7 or higher.
  • pip (Python package manager).
  • Python 3 virtual environment module (venv).
• Specific Instructions:
  • Linux (Debian-based):
    • Check Python version: python3 --version
    • Install Python: sudo apt install python3
    • Check pip version: pip --version
    • Install pip: sudo apt install python3-pip
    • Install venv: sudo apt install python3-venv
  • Windows: Use WSL (Windows Services for Linux).
  • macOS: Should run fine, but untested.
• Note: If not using Debian-based Linux, search for appropriate install commands.

4. Creating a Python Virtual Environment

• Main Topic: Setting up a virtual environment for Henry.
• Step-by-Step Process:
  1. Create a directory: mkdir ~/henry
  2. Initialize the virtual environment: python3 -m venv ~/henry
  3. Change to the directory: cd henry
  4. Install Henry: bin/pip install henry
• Explanation: The pip command fetches Henry from Python repositories and sets it up within the virtual environment.

5. Configuring Looker API Credentials (looker.ini)

• Main Topic: Setting up API credentials for Henry to access the Looker instance.
• Key Details:
  • Credentials stored in a looker.ini file.
  • The INI file can contain multiple sections, each for a different Looker instance.
• Step-by-Step Process:
  1. In Looker:
     • Log in to Looker.
     • Navigate to Admin > Users.
     • Filter users by name and select your user.
     • Edit API Keys and create a New API Key.
     • Copy the Client ID and Client Secret.
  2. In the Terminal:
     • Open looker.ini with a text editor (e.g., Nano).
     • Create a section for your environment (e.g., [Sandbox CL]).
     • Set base_url to the URL of your Looker instance.
       • API port is typically 19999, but may be 443.
     • Set client_id and client_secret using the copied values.
     • Set verify_ssl to true.
     • Save and exit the INI file.

6. Conclusion and Next Steps

• Main Topic: Preview of the next video in the series.
• Key Point: The next video will demonstrate using Henry to analyze the health of a Looker instance.

Technical Terms and Concepts

• Looker Instance: A specific deployment of the Looker data platform.
• API Credentials: Authentication keys (Client ID and Client Secret) that allow Henry to access the Looker API.
• Linux Distribution: An operating system based on the Linux kernel (e.g., Debian, Ubuntu, Mint).
• Debian-based Systems: Linux distributions that use the apt package manager.
• WSL (Windows Services for Linux): A compatibility layer for running Linux binary executables directly on Windows.
• Python Virtual Environment: An isolated environment for Python projects, allowing different projects to have different dependencies without conflicts.
• pip: The package installer for Python.
• looker.ini: A configuration file used to store Looker API credentials.
• SSL (Secure Sockets Layer): A protocol for establishing encrypted links between a web server and a browser.

Synthesis/Conclusion

This video provides a detailed guide to setting up the environment and configuring the necessary credentials to use Henry, an open-source tool for optimizing Looker instance performance. It covers the installation of Python, pip, and the virtual environment module, as well as the creation and configuration of the looker.ini file with Looker API credentials. The video prepares the viewer for the next steps, which involve using Henry to analyze the health of a Looker instance. The emphasis is on providing clear, step-by-step instructions for users of various operating systems, particularly Linux.