Awesome Looker

A list of resources for the data platform

Official

• Looker.com
• Community
• New features
• Release notes
• Blog
• Documentation
• User guide
• Help center > Developer
• Customer scripts
• Atom Fashion

Videos

• 06 Nov 2020 - Looker - Interesting BI platform from Google: https://www.youtube.com/watch?v=9jDREG0O_bU

Data Portal

• https://info.looker.com/hadoop/federating-data-with-presto-to-build-an-enterprise-data-portal
• https://github.com/ContrastingSounds/simple_data_portal

Embed, whitelabel, ...

• https://looker.com/product/embedded-analytics
• https://looker.com/blog/embedded-analytics-questions-answered
• Whitelabel:
  • https://docs.looker.com/admin-options/settings/whitelabel
  • https://www.hashpath.com/2019/09/looker-wld/
• Theming: https://docs.looker.com/admin-options/settings/themes
• Embed SDK: https://docs.looker.com/reference/embed-sdk/embed-sdk-intro
• API SDK: https://docs.looker.com/reference/api-and-integration/api-sdk
• Public embed: https://help.looker.com/hc/en-us/articles/360023574934-How-to-Publicly-Embed-Visualizations-and-Data-Tables

Custom viz's

• Looker:
  • https://github.com/looker/custom_visualizations_v2
• Groodlooker:
  • https://github.com/groodlooker/vega-lite
• Jim Rottinger:
  • http://lookervisbuilder.com/ | https://github.com/JimRottinger/looker-vis-builder
• Bytecode IO:
  • https://github.com/bytecodeio/leaflet-looker
  • https://github.com/bytecodeio/single_icon
  • https://github.com/bytecodeio/sparkline_viz
  • https://github.com/bytecodeio/highcharts_multi_section_viz
  • https://bytecode.io/looker-erd-generator/
• noahamac
  • Configurable visualizations: https://github.com/noahamac/vizzy -> https://vx-demo.now.sh/gallery
  • Viz inspector: https://github.com/noahamac/viz-inspector
• Thomas Banghart
  • Custom viz react template: https://github.com/thomasbanghart/looker-custom-viz/tree/main/templates/looker-custom-viz-ts
  • Go Maps ?!: https://github.com/thomasbanghart/go-looker-map-layers
• ContrastingSounds (Jon Walls):
  • Build a custom viz:
    • https://github.com/ContrastingSounds/Looker-Vis-Building-Class
    • https://github.com/ContrastingSounds/Looker-Custom-Vis
    • https://github.com/ContrastingSounds/vis-tools
  • Treemap: https://github.com/ContrastingSounds/vis-treemap
  • Report table: https://github.com/llooker/viz-report-table-marketplace, https://github.com/looker-open-source/viz-report-table-marketplace, https://github.com/ContrastingSounds/vis-report_table

Extensions

• Extension framework: https://docs.looker.com/data-modeling/extension-framework/extension-framework-intro
• Data dictionary:
  • https://github.com/looker-open-source/app-data-dictionary
  • https://help.looker.com/hc/en-us/articles/360039086454-Publishing-Content-a-Workflow-for-Authorizing-Content-as-a-Source-of-Truth
  • https://help.looker.com/hc/en-us/articles/360023562674-Creating-a-Data-Dictionary-Using-Looker-s-API

Blocks

• Covid-19: https://github.com/looker/data-block-community-mobility

Actions

• Custom action hub template: https://github.com/looker/custom-action-hub-example
• Action hub with Python and Fast API: https://github.com/ContrastingSounds/fast-hub

Developer

• General:

  • https://github.com/groodlooker
  • https://github.com/looker-open-source
  • https://github.com/looker
  • Beyond BI Developer Goodie Bag

• Template:

  • https://github.com/looker/custom-action-hub-example

• Git:

  • Bitbucket: https://help.looker.com/hc/en-us/articles/360023858513-Using-BitBucket-for-Version-Control-in-Looker

• LookML styleguide:

  • https://github.com/looker-open-source/look-at-me-sideways

• Components:

  • https://github.com/looker-open-source/components, https://looker-open-source.github.io/components/latest/

• SDK:

  • https://github.com/looker/sdk-examples
  • Flask example: https://github.com/looker-open-source/sdk-codegen/tree/main/examples/python/lookersdk-flask

• Developers with Looker skill:

  • https://beiatrix.github.io/#about

• Python LookML API:

  • https://github.com/ContrastingSounds/lookml

• SDK for Python:

  • https://github.com/looker-open-source/sdk-codegen/tree/master/python

• SQL Runner:

  • Explain: https://help.looker.com/hc/en-us/articles/360023513514-How-to-Optimize-SQL-with-EXPLAIN

• API / SDK:

  • https://looker.com/blog/introducing-looker-api-explorer
  • Generate PDF: https://help.looker.com/hc/en-us/articles/360023624154-Using-the-Looker-API-to-Generate-PDFs
  • Flask Wrapper for Looker API: https://gist.github.com/janikas/ded7fa57844e7e5a66332faab649373d
  • Output calculcations: https://gist.github.com/DanielWeitzenfeld/f13bd8892dbe091eaa38
  • Query health: https://gist.github.com/jayozer/96d42c9b12eecfd2b3d95eb70198ee04
  • Disable users: https://gist.github.com/beniyama/ee0a4e9c34acb293cdbcc20888a7369b
  • ERD Generator: https://community.looker.com/looker-api-77/looker-erd-generator-14999
  • LookML parser in Python: https://community.looker.com/open-source-projects-78/introducing-lkml-a-speedy-lookml-parser-in-pure-python-13065
  • pyLookML: https://community.looker.com/open-source-projects-78/pylookml-17215
  • generate LookML dynamically with Python: https://community.looker.com/open-source-projects-78/announcing-lookml-generation-for-python-4835
  • Sample webservice to wrap Looker API and instrument Restful API get via URL

• Connecting Tableau to Looker

  • Write your own Web Data Connector ? https://tableau.github.io/webdataconnector/

LookML

• LookML style guide and linter (LAMS): https://community.looker.com/open-source-projects-78/introducing-lams-a-lookml-style-guide-and-linter-10603

Home / Portal

• Default homepage: https://help.looker.com/hc/en-us/articles/360043039033-How-do-I-set-up-the-default-homepage-for-my-organization-
• Organize content: https://help.looker.com/hc/en-us/articles/360025911434-How-do-I-curate-content-for-a-team-or-an-initiative-within-Looker-

Explores

• Forecast in Tables: https://help.looker.com/hc/en-us/articles/360041728973-How-to-Forecast-in-Looker-with-Table-Calculations
• URL parameters: https://help.looker.com/hc/en-us/articles/360023571954-Override-Look-Filters-in-the-URL

Dashboards

• t.b.d.

Administration

• Administration overview: https://help.looker.com/hc/en-us/categories/360000085607-Administration
• User activity: https://community.looker.com/lookml-5/analytic-block-daily-weekly-monthly-active-users-1499
• Performance: https://help.looker.com/hc/en-us/articles/360001847227-Best-Practice-Optimize-Looker-Performance
• Dev/Test/Prod: https://help.looker.com/hc/en-us/articles/360033946033-Looker-Multistage-Development-Framework-Dev-QA-Prod-for-Customer-Hosted-Deployments
• Find unused fields: https://help.looker.com/hc/en-us/articles/360023633674-Finding-Unused-Fields
• Gazer: command line tool for looker content management: https://community.looker.com/open-source-projects-78/gazer-a-command-line-tool-for-looker-content-management-8066
• Spectacles: continuous integration tool for looker: https://www.spectacles.dev/post/introducing-spectacles

On Premise Installation and Configuration:

• Cookbook for chef: https://supermarket.chef.io/cookbooks/looker
• Update instance: https://help.looker.com/hc/en-us/articles/360023639354-Best-Practices-when-Updating-your-Looker-Instance

Special topics

• LookML:
  • Masking-Sensitive-Fields-for-All-Users

Other

• Bryan at Looker: several github projects for looker: https://github.com/bryan-at-looker?tab=repositories
• another awesome-looker repo :) https://github.com/alison985/awesome-looker