Open source projects
Build on top of the Looker platform
- 56 Topics
- 163 Replies
I sometimes edit LookML in VSCode, because I find it’s easier to jump around amongst multiple files, search-and-replace, and generally crush code. Of course there’s no syntax highlighting, autocomplete, or any of the other code-editor niceties to be found in Looker’s built-in editor. I’ve written a couple of VSCode plugins over the years (yes I have weird hobbies) and I’ve thought about writing a VSCode plugin for looker, which would provide syntax coloring, error squigglies and autocomplete in LookML. But I’m not sure it would have any users other than me. Does anyone else wish there was a “LookML mode” for VSCode?
The Problem As a Looker model grows in size and sophistication, it will also experience an ever-increasing number of Explores, Views and Fields. Unfortunately, a common side effect of this is model bloat, which typically means a less than great end-user experience. The Why Henry is a command line tool that helps determine model bloat in your Looker instance and identify unused content in models and explores. It is meant to provide recommendations that developers can validate in order to cleanup models from unused explores and explores from unused joins and fields, as well as maintain a healthy and user-friendly instance. The How The tool currently has three main commands: pulse, analyze and vacuum. The pulse command runs a number of tests that help determine the overall health of the Looker instance. Among the tests are: connection checks, which confirm that all connections are in working order; query history checks to determine if there are any whose runtime stands out; the use of an
The Problem User Defined Content (Dashboards and Looks) are not easily portable across Looker instances, nor can they be backed up and restored to a known state easily. It is not easy to monitor content creation, user activity, etc. In particular, it is not easy to do these activities from scripts that can be run by an operations team. The Why Gazer is a command line tool that provides an interface to a Looker instance for the purpose of managing content, users, schedules, etc. It can be used interactively, but also be included in scripts. Finally, it serves as a reference implementation for developers that want to build their own tools. The How Gazer currently has 11 commands. The most common commands are user, space, dashboard, look, and plan. Each command has several subcommands tailored for that command. The ls subcommand is very common and will produce a list of objects. The cat subcommand is also common, and will provide the json representation of an object. Typing gzr alone wil
Yes, please! Introducing Node LookML Parser - https://www.npmjs.com/package/lookml-parser (Disclaimer: I made this myself - it is provided 100% as-is, without warranty, and probably unwarranted!) It’s an open-source Nodejs module which can be used from the command line, or as a dependency in your Nodejs application. It can process either a single string of LookML, or a whole directory of files, and outputs the results into an easy-to-navigate JSON-compatible object. Here’s what it looks like on the command line:
We’re announcing a new project that we’ve just open sourced: LookML-Gen for Python ##Overview If you have dynamic data definitions or if aspects of your system are driven by changing metadata, reporting on it is often cumbersome and not at all user friendly. Entity-Attribute-Value (EAV) models are a classic example of this. (See this Looker discource post for background.) As adopters of Looker know, LookML provides a powerful way to describe data. The Looker platform processes LookML and allows end users to explore data according to the descriptions and relationships found in LookML files. LookML-Gen allows Python developers to examine dynamic data definitions then programmatically generate LookML to describe that data. By outputting LookML, end users get the benefit of reporting in a way that makes sense to them, picking dimensions and measures with meaningful names. Simple Example Code Install it: pip install lookml-gen Use it: from lookmlgen.view import View from lookmlgen.field im
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.