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

Properties

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. This property is set to null for looker views that are not derived.	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