User Guide

Getting Started

Help Center

Documentation

Community

Training

Articles in this section

Creating a Data Dictionary Using Looker's API

Avatar
Looker Team
  • Updated
Follow

You can make use of certain API calls to create a data dictionary based on fields definitions and descriptions defined in the Looker modeling layer.

Step 1:

You can view instructions on how to connect to the API here.

Step 2:

Define fields with descriptions and other parameters within the model in your Looker instance.

Step 3:

Call the method (lookML_model_explore) via the API and pull in the appropriate fields you want to identify within your data dictionary.

Here is some sample Ruby code:

        #Get Data Dictionary

        require 'looker-sdk'

        module ApplicationHelper

            def self.api_auth
              sdk = LookerSDK::Client.new(
              # Looker/API Credentials
                :client_id => ENV['API_CLIENT_ID'],
                :client_secret => ENV['API_SECRET'],
                :api_endpoint => ENV['API_ENDPOINT']
              )
              return sdk
            end

            def self.get_field_values(model_name, explore_name)

                sdk = self.api_auth()
                fields = {:fields => 'id, name, description, fields'}

                #API Call to pull in metadata about fields in a particular explore
                fields = sdk.lookml_model_explore(model_name, explore_name, fields)


                my_fields = []

                #Iterate through the field definitions and pull in the description, sql, and other looker tags you might want to include in  your data dictionary.
                fields[:fields][:dimensions].to_a.each do |x|
                    dimension = {
                        :field_type => 'Dimension',
                        :view_name => x[:view_label].to_s,
                        :field_name => x[:label_short].to_s,
                        :type => x[:type].to_s,
                        :description => x[:description].to_s,
                        :sql => x[:sql].to_s
                    }
                    my_fields << dimension
                end

                fields[:fields][:measures].to_a.each do |x|
                    measure = {
                        :field_type => 'Measure',
                        :view_name => x[:view_label].to_s,
                        :field_name => x[:label_short].to_s,
                        :type => x[:type].to_s,
                        :description => x[:description].to_s,
                        :sql => x[:sql].to_s
                    }

                    my_fields << measure
                end

                return my_fields
            end

        end

Step 4:

Format the results from the get_field_values call. Consider using plugins to allow for search and sort functionality. In our example, we use the DataTable JS plugin.

Examples:

Default Dictionary with Pagination and Sorts

Dictionary Filtered to Fields that Contain the Word lifetime

Additional information on data dictionaries combining the API and Python can be found here: Writing a simple data dictionary to csv using the Looker API and the Python requests library.

Related articles