LManage is a collection of useful tools for Looker admins to help curate and cleanup content and it's associated source LookML.
Project description
Lmanage
What is it.
LManage is a collection of useful tools for Looker admins to help curate and cleanup content and it's associated source LookML.
How do i Install it.
Lmanage can be found on pypi.
pip install lmanage
How do I Use it.
Commands
LManage will ultimately will have many different commands as development continues
Status | Command | Rationale |
---|---|---|
Live | mapview | Find the LookML fields and tables that are associated with a piece of Looker content |
Planned | removeuser | Based on last time logged in, prune Looker users to ensure a performant, compliant Looker instance |
Planned | dcontent | Iterate through an input of content, delete content and back it up using gzr for easy restoration |
Planned | bcontent | Iterate through all broken content (using content validator) and email a customized message to each dashboard owner |
Planned | scoper | Takes in a model file, elminates the * includes, iterate through the explores and joins and creates a fully scoped model include list for validation performance and best practice code organization |
help and version
lmanage --help
Usage: lmanage [OPTIONS] COMMAND [ARGS]...
Options:
--version Show the version and exit.
--help Show this message and exit.
Commands:
mapview
mapview
The mapview command will find the etymology of the content on your dashboard, exporting a CSV that looks like this.
example usage
lmanage mapview --path ./output/my_output.csv --ini-file ~/py/projects/ini/k8.ini --project /test_lookml_files/the_look -table "order_items"
flags
- path (
--path
,-fp
) This is the path where you would like the outputfile for your returned dataset to be. - ini-file (
--ini-file
,-i
) This is the file path to the ini file that you've created to use the Looker SDK
#example Ini file
[Looker_Instance]
base_url=https://looker-dev.company.com:19999 (or 443 if hosted in GCP)
client_id=abc
client_secret=xyz
verify_ssl=True
- project (
--project
,-p
) This is the file path to your local project of LookML files that lmanage will scan to associate connections between your Looker content and LookML Lmanage can either return a full dataset of all content mapping, or a prefiltered dataset with all content associated with a specific table or field. - table (
--table
,-t
) Expecting input of lookml view name - field (
--field
,-f
) Expecting input of fully scoped LookML field name e.g. viewname.fieldname
Fields Returneds
- dashboard_id: the id of the looker dashboard
- element_id: the id of the visualization element on the looker dashboard
- sql_joins: the joins used in a query grouped by element id
- fields_used: the fields used by the query grouped by element id
- sql_table_name: the underlying sql value being referenced at the view level of the lookml (assuming the view is standard)
- potential_join: for the explore that powers the element query: what are all the potential joins available
- used_joins: joins used by the underlying queries obtained by parsing sql of query
- used_view_names: views that are used by each query grouped by element_id
- unused_joins: views that are unused by the specific query of the dashboard element
This is not an officially supported Google Product.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.