Model Parameters

LookML
Version

On this Page
Docs Menu

Go to Functional Reference for All Parameters

Model files define explores and their relationships to other views.

A “model” references a combination of related explores and dashboards. Unlike other LookML elements, a model is not declared with a model parameter. Instead, any file placed in the MODELS section of the Looker IDE (also known as the Develop page) defines a model. The model name is taken from the filename, and must be unique across your instance, even within different projects.

A model file typically contains any explore declarations, along with a host of model level settings.

This page links to the model-level LookML parameters. They are typically written at the top of the model file and should not be nested within other parameters.

Example Usage

Hover over a parameter name to see a quick description; click it to jump to that page.
When a parameter can be set to one of several specific options, the default value is listed first.

# STRUCTURAL PARAMETERS
explore: explore_name {
  # Desired explore parameters (described on Explore Parameters page)
}
# Possibly more explore declarations

include: "filename_or_pattern"
# Possibly more include declarations

# DISPLAY PARAMETERS
label: "Label I Want"

# FILTER PARAMETERS
case_sensitive: yes | no

# QUERY PARAMETERS
connection: "connection_name"
datagroup: datagroup_name {
  max_cache_age: "N (minutes | hours | days)"
  sql_trigger: SQL query ;;
}
# Possibly more datagroup declarations
fiscal_month_offset: N
persist_for: "N (seconds | minutes | hours)"
persist_with: datagroup_name
week_start_day: monday | tuesday | wednesday | thursday | friday | saturday | sunday

# VISUALIZATION AND FORMATTING PARAMETERS
map_layer: map_name {
  extents_json_url: "URL to JSON extents file"
  feature_key: "Name of TopoJSON object"
  file: "TopoJSON file name" # or use the url subparameter
  format: topojson | vector_tile_region
  label: "Label I want"
  max_zoom_level: number indicating max zoom
  min_zoom_level: number indicating min zoom
  projection: Preferred geographic projection
  property_key: "TopoJSON property"
  property_label_key: "Label for TopoJSON property"
  url: "URL that contains map file" # or use the file subparameter
}
# Possibly more map layer declarations

named_value_format: desired_name {
  value_format: "excel formatting string"
}
# Possibly more named value format declarations

Parameter Definitions

Parameter Name Description
Structural Parameters
explore Expose a view in the Explore menu. For more information about explores and their parameters, see the Explore Parameter Reference page.
include Add files to a model
Display Parameters
label (for model) Change the way a model appears in the Explore menu
Filter Parameters
case_sensitive (for model) Specify whether filters are case sensitive for a model
Query Parameters
connection Change the database connection for a model
datagroup ADDED4.16 Creates a datagroup caching policy for the model
fiscal_month_offset ADDED4.8Specify the month your fiscal year begins (if it differs from calendar year)
persist_for (for model) Change the cache settings for a model
persist_with (for model) ADDED4.16 Specify the datagroup to use for the model’s caching policy
week_start_day Specify the day of week that week-related dimensions should start on
Visualization and Formatting Parameters
map_layer (for model) NEW LOOKML Create custom maps to be used with map_layer_name
map_layers OLD LOOKML Create custom maps to be used with the field-level map_layer parameter
named_value_format NEW LOOKML Create a custom value format to be used with value_format_name
value_formats OLD LOOKML Create custom value formats to be used with value_format_name
Parameters to Avoid
scoping REMOVED3.52 No longer required
template AVOID AS OF3.30 Specify the template engine to be used with html parameters
Still have questions?
Go to Discourse - or - Email Support
Top