Usage

view: view_name {
  dimension: field_name {
    alias: [old_field_name, old_field_name, …]
  }
}

Hierarchy

View File

view

Field Type

alias

Possible Field Types

Dimension, Dimension Group, Measure, Filter, Parameter

Accepts

A square-bracketed list of field names

Definition

The alias parameter provides alternative names for a field that might appear in the URL for a query. It can be useful in cases when field names in a model change, but you have pre-existing URLs to queries that you want to keep functioning.

The following example shows how you could change a field named count to the new name number_of_items, without breaking any existing queries that refer to count.

measure: number_of_items { # the new name alias: [count] # the old name type: count }

You can also provide multiple aliases, in case you rename a field multiple times. For example, if you renamed the above number_of_items field to number_of_order_items, you could use:

measure: number_of_order_items { # the new name alias: [count, number_of_items] # the old names type: count }

To use alias with a dimension group, change the dimension group name, not every field in the dimension group. For example, to rename the dimension group created_date to order_date:

dimension_group: order_date { # the new name alias: [created_date] # the old name type: time timeframes: [time, hour, date, week, month, year, hour_of_day, day_of_week, month_num, raw] sql: ${TABLE}.created_at ;; }

Note that alias is used only to keep URLs functioning. It should not be used when referencing fields in LookML. For example:

measure: number_of_items { alias: [count] type: count } measure: percent_items_sold { sql: ${sold_items} / ${number_of_items} ;; # will work because there type: number # is a measure named number_of_items } measure: percent_items_sold { sql: ${sold_items} / ${count} ;; # will NOT work because you type: number # should not use alias names in LookML }

Things to know

If you alias a field as a name already taken by another field, the LookML Validator will return an error.

Articles in this section