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
Looker Folder
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
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, explore
looker_refinement_chain
Specifies the location of the refinements applied to the view.
view, explore
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_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
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.
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.
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.
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".
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
Last updated