dimension

Usage

view: view_name {
  dimension: field_name { ... }
}

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.

Subparameters for dimension

See the Field parameters reference page for a list of subparameters that are available for LookML fields.

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 ;;
  }
}