dimension

Usage

view: view_name {
  dimension: field_name { ... }
}
Hierarchy
dimension
Accepts
A Looker identifier to name the dimension

Definition

The dimension parameter declares a new dimension and specifies a name for that dimension.

The name must meet the following requirements:

  • It must be unique within any given view.
  • It must consist of characters a through z, 0 through 9, or _. The dimension name is case-sensitive. Because of this, we recommend using a consistent lowercase name for all LookML objects, including dimensions.
  • It must start with a letter.

There are many types of dimensions, as discussed further on the Dimension, filter, and parameter types documentation page.

Examples

Create an id and a supplier_name dimension in a view named products:

view: products {
  dimension: id {
    primary_key: yes
    sql: ${TABLE}.id ;;
  }
  dimension: supplier_name {
    sql: ${TABLE}.supplier_name ;;
  }
}