LookML
The LookML types you can search for, with an example of each
Read from a LookML context source. Write LookML types with the lookml. prefix.
See Search for the query syntax. Properties listed as Exact match the whole value only.
lookml.model
A LookML model.
anfra search 'type:lookml.model connection:warehouse'Finds the models that use the warehouse connection.
Properties: name, label, connection, path
lookml.explore
An explore: a base view and the views joined to it.
anfra search 'type:lookml.explore model_name:ecommerce hidden:false'Finds the visible explores of the ecommerce model.
Properties: model_name, name, label, description, view_name, group_label, sql_always_where. Exact: hidden
lookml.join
A view joined into an explore.
anfra search 'type:lookml.join relationship:many_to_many'Finds the many-to-many joins, which can fan out measures.
Properties: model_name, explore_name, name, view_name, sql_on, foreign_key, view_label. Exact: relationship, join_type
lookml.view
A table or derived table.
anfra search 'type:lookml.view derived_table_sql:customer_id'Finds the derived tables whose SQL mentions customer_id.
Properties: model_name, name, label, sql_table_name, table_name, derived_table_sql, explore_source, connection, extends, path
lookml.dimension
A dimension or dimension_group of a view. field_kind says which.
anfra search 'type:lookml.dimension view_name:orders field_kind:dimension_group'Finds the dimension groups, such as time dimensions, of the orders view.
Properties: model_name, view_name, name, label, description, field_type, view_label, group_label, sql. Exact: field_kind, hidden, value_format_name, primary_key, timeframes, intervals
lookml.measure
A measure of a view.
anfra search 'type:lookml.measure field_type:count_distinct'Finds the measures that count distinct values.
Properties: model_name, view_name, name, label, description, field_type, view_label, group_label, sql. Exact: field_kind, hidden, value_format_name
lookml.parameter
A parameter or filter-only filter field of a view. field_kind says which.
anfra search 'type:lookml.parameter field_kind:filter'Finds the filter-only fields.
Properties: model_name, view_name, name, label, description, field_type, view_label, group_label, sql, allowed_values. Exact: field_kind, hidden, value_format_name
lookml.dashboard
A LookML dashboard.
anfra search 'type:lookml.dashboard depends_on:(type:lookml.explore name:orders)'Finds the dashboards with a tile that queries the orders explore.
Properties: name, title, description, path. Exact: layout
lookml.dashboard_element
A tile of a LookML dashboard.
anfra search 'type:lookml.dashboard_element element_type:single_value'Finds the single value tiles.
Properties: dashboard_name, name, title, model_name, explore_name, fields. Exact: element_type
lookml.tag
A tag.
anfra search 'type:lookml.dimension depends_on[depth=1]:(type:lookml.tag name:pii)'Finds the dimensions tagged pii.
Properties: name
lookml.project
The project of manifest.lkml.
anfra search 'type:lookml.project'Shows the ingested LookML project.
Properties: name
lookml.file
A LookML source file. Its contents are not searchable.
anfra search 'type:lookml.file file_type:view'Finds the view files, the ones named *.view.lkml. file_type is the part of the file name before .lkml, or manifest for manifest.lkml.
Properties: path. Exact: file_type