directory keyboard_arrow_right embedded keyboard_arrow_right create-a-data-dictionary

Create a Data Dictionary

github repo API docs

The Data Dictionary block pulls up metadata about fields built within the Looker Model (by using the lookML_model_explore API call) and displays the fields in a digestible format that provides transparency about metric definitions. The definitions are based on dimensions and measures in the LookML model, including the data type, description of the metric, and the associated LookML sql parameter. Format the results from the lookML_model_explore call using custom CSS and HTML. Consider using JS Plugins to allow for Search and Sort functionality to make the dictionary more accessible. In this block, we use the DataTable JS Plugin.

Sample Adaptations of this Block:
  • Create a reference source for all consumers of external reports
  • Provide a location for business users to search all metrics descriptions to identify the appropriate dimension or measure for analysis
  • Make it easy for external stakeholders to identify and locate the unique metrics for their business

Related Blocks

Report Selector

Looker’s Report Selector Block empowers data consumers with real-time data exploration capabilities.

Retrieve SQL From Explore

This Block enables users to pull the SQL from queries executed through Looker’s Explore page.

List of Looks Created By a User

This Block grabs the list of all the Looks created by a particular user.