Looker Integration Discovered Resources

Overview

The Looker integration discovers the following resources:

• LookML Explore

• LookML View

• Looker Dimension

• Looker Measure

• Looker Folder

• Looker Look

• Looker Tile

• Looker Dashboard

• Table

Note: We don't observe built-in looker models i__looker and system__activity

Looker Folder

Property	Value
name	The name of the folder.
native_id	The ID of the folder in Looker's API
parent	The parent folder of this folder. Null if the folder has no parent folder.
created at	Stores the date the resource was created within the native application.
created by	The email of the user that created the folder

LooML: Views & Explores

property	Value	Applicable to
name	The title of the LookML file	view, explore
description		view, explore
sql_dialect	The SQL dialect of the query powering the visualization	view, explore
looker_project_name	The name of the LookML project containing the LookML model	view, explore
looker_model	The name of the LookML model powering the visualization	view, explore
type	looker_view, looker_explore	view, explore
native_id	The ID of the look/tile in the Looker instance	view, explore
parent_container	For views and explores, this is the Looker project containing it.	view, explore
is_dervied	Stores whether the view is derived.	view
derived_type	Stores the type of derived view: sql_derived_view, native_derived_view	view
has_refinements	Indicates whether the view includes refinements	view
looker_refinement_chain	Specifies the location of the refinements applied to the view.	view
pdt_total_builds_30d	Total number of PDT builds in the last 30 days.	view
pdt_total_build_time_30d	Cumulative build time for PDTs in the last 30 days.	view
lookml_view_persistency	Defines the persistency triggers for PDTs in Looker, such as sql_trigger, datagroup_trigger, or interval_trigger.	view
git_repo_url	The URL of the associated Git repository.	view, explore
git_rep_branch	The branch of the Git repository being used.	view, explore
total_queries_14d total_queries_30d total_queries_60	The number of queries the resource is found within over the last 14/30/60 days, taken from the Looker API (not from a db connection) Note: This number is for all queries including cached.	view, explore
distinct_users_14d distinct_users_30d distinct_users_60d	The number of distinct users querying the resource is found within over the last 14/30/60 days, taken from the Looker API (not from a db connection) Note: This number is for all queries including cached.	view, explore
source_path	The complete file path of the resource, including both directory and filename (e.g., for Git-hosted projects, this would be like models/sales/orders.view.lkml).	view, explore
source_directory	Stores the entire path of the location of the resource, such as the entire file directory path in your git hosting solution.	view, explore

LookML Refinements

Euno discovers refinement files; however, unlike regular views, refinement files do not constitute resources themselves. Instead, Euno includes the refinement information in the view that it refines. For views with refinements, the property has_refinements will be set to true. Additionally, in the About tab of the refined resource's side panel, the property looker_refinement_chain is displayed, indicating the file locations of the refinement files that refine the resource. When viewing the code of the refined resource, it includes the dimensions and measures from the refinement file as if it were compiled.

Currently Euno does not support the discovery of refinement files for LookML Explores.

Looker data visualizations: Looker Look, Looker Tile and Looker Dashboards

The term "Looker Tile" is used to describe a visualization in a Looker Dashboard that is not a reference to a Looker Look.

In Looker, a dashboard is made up of dashboard elements. Some dashboard elements are data visualizations, which can either reference a Looker Look, or a visualization that "lives" inside the dashboard. Looker documentation uses the terms lookless and tile to describe the latter type of visualization. Euno uses the more commonly used term tile.

property	Value	Applicable to
name	The title of the visualization	Look, Tile, Dashboard
description	The description of the resource	Look, Dashboard
sql_dialect	The SQL dialect of the query powering the visualization	Look, Tile
looker_model	The name of the LookML model powering the visualization	Look, Tile
looker_project_name	The name of the LookML project containing the LookML model	Look, Tile
looker_folder	The name of the Looker folder the item is found within.	Look, Dashboard
created_at	Stores the date the resource was created within the native application.	Look, Tile, Dashboard
type	looker_look, looker_tile, looker_dashboard	Look, Tile, Dashboard
updated_at	For looker tiles, an update include all updates to the tile or the dashboard containing it	Look, Tile, Dashboard
native_id	The ID of the look/tile in the Looker instance	Look, Tile, Dashboard
created_by	The display name of the Looker user that created the Look	Look, Dashboard
updated_by	The display name of the Looker user that last updated the Look	Look, Dashboard
parent_container	For Looks, this is the Looker Folder containing it. For Tiles, this is the Looker dashboard containing the tile.	Look, Tile
last_7d_views (last_30d_views)	The total number of impressions for this Look over the last 7 (30) days	Look, Dashboard
last_viewed_at	The last impression time of the Look	Look, Dashboard
total_queries_14d total_queries_30d total_queries_60d	The number of queries the resource is found within over the last 14/30/60 days, taken from the Looker API (not from a db connection) Note: This number is for all queries including cached.	Look, Tile, Dashboard
distinct_users_14d distinct_users_30d distinct_users_60d	The number of distinct users querying the resource is found within over the last 14/30/60 days, taken from the Looker API (not from a db connection) Note: This number is for all queries including cached.	Look, Tile, Dashboard

LookML and Looker Measures and Dimensions

Euno observes fields in both LookML files (views and explores) and visualizations (looks and tiles). For visualizations, Looker may make use of Custom Fields. Euno observes each custom field as a resource in the same manner as a LookML measure or dimension. A custom measure, including a filtered custom measure, is observed with the type looker_measure. A custom dimension is observed with the type looker_dimension.

Euno observes fields in both LookML files (views and explores) and visualizations (looks and tiles). For visualizations, Looker may make use of Custom Fields. Euno observes each custom field as a resource in the same manner as a LookML measure or dimension. A custom measure, including a filtered custom measure, is observed with the type looker_measure.

A custom dimension is observed with the type looker_dimension. Looker dimension groups are also observed as dimensions with the type looker_dimension.

Property	Value
name	The name of the Looker measure or dimension
type	looker_measure or looker_dimension
parent_container	The URI of the visualization where the field is defined
is_calculated	Indicates whether the resource is a custom field true
is_identity_transformation	For measures or dimensions that directly reference an existing column in the data warehouse, the property is set to true; otherwise, it is set to false. For custom fields, this property is always set to false.
total_queries_14d total_queries_30d total_queries_60d	The number of queries the resource is found within over the last 14/30/60 days, taken from the Looker API (not from a db connection). Note: This number is for all queries including cached.
distinct_users_14d distinct_users_30d distinct_users_60d	The number of distinct users querying the resource is found within over the last 14/30/60 days, taken from the Looker API (not from a db connection). Note: This number is for all queries including cached.
tags	A list of tags associated with the measure or dimension, as defined in the LookML file.

Table

The Looker Integration will discover resources of type Table when it discovers a LookML view that refers to a database table. For example, if a LookML view is using the sql_table_name parameter, Euno will observe the referred table.

To determine the exact location of the referred table, the Looker Integration looks up the correct Looker Connection using the LookML Model's connection parameter. The Looker Connection usually has all the metadata required for Euno to uniquely determine the URI of the referred table.

In the case of a connection with dialect athena, The Looker Integration is not able to fetch from Looker's API the term "AWS account id" which is required to uniquely identify the referred tables. In this case, Euno defaults to using the aws account id default_aws_account.us_central1 . If you have multiple AWS accounts and you need to distinguish between them, set up manual "connection mapping".

Property	Value
name	The name of the table.
database_technology	The technology of the database, based on the the dialect of the connection
database	The name of the database
schema	The name of the schema