dimension

Stay organized with collections Save and categorize content based on your preferences.

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:

  • Be unique within any given view
  • Consist of characters a through z (no capital letters), 0 through 9, or _
  • 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 ;;
  }
}