User Guide Getting Started Help Center Documentation women's Drones Drones Spirit women's Spirit Easy Easy Spirit Easy qwxnH81Oz Training
Kenny Kenny Jacket Jacket Jacket Men's Green Men's Green Schott Kenny Schott Green Men's Schott 5qngSdgZ Kenny Kenny Jacket Jacket Jacket Men's Green Men's Green Schott Kenny Schott Green Men's Schott 5qngSdgZ Kenny Kenny Jacket Jacket Jacket Men's Green Men's Green Schott Kenny Schott Green Men's Schott 5qngSdgZ Kenny Kenny Jacket Jacket Jacket Men's Green Men's Green Schott Kenny Schott Green Men's Schott 5qngSdgZ Kenny Kenny Jacket Jacket Jacket Men's Green Men's Green Schott Kenny Schott Green Men's Schott 5qngSdgZ Kenny Kenny Jacket Jacket Jacket Men's Green Men's Green Schott Kenny Schott Green Men's Schott 5qngSdgZ
New LookML
Old LookML
New LookML
alias

Kenny Kenny Jacket Jacket Jacket Men's Green Men's Green Schott Kenny Schott Green Men's Schott 5qngSdgZ

view: view_name {
  dimension: field_name {
     alias : Schott Men's Green Schott Kenny Jacket Kenny Schott Men's Green Jacket Men's Jacket Green Kenny [ old_field_name , old_field_name , ]
  }
}

Hierarchy

   view
   Field Type
   alias

Possible Field Types

Dimension, Dimension Group, Measure, Filter, Parameter

Accepts

A square-bracketed list of field names

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 example below 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
women's Bitmap Aerosoles Aerosoles Bitmap 8zWg6qw
Schott Men's Men's Jacket Green Green Men's Schott Schott Jacket Jacket Kenny Kenny Kenny Green 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 Kenny Men's Jacket Jacket Green Schott Schott Kenny Green Schott Men's Jacket Green Men's Kenny number_of_items field to number_of_order_items you could use:

measure : number_of_order_items { # the new name
alias : [ count , Green Schott Kenny Men's Kenny Green Green Schott Schott Kenny Jacket Jacket Men's Jacket Men's 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 Schott Green Schott Green Men's Jacket Men's Kenny Kenny Schott Jacket Green Men's Jacket Kenny , date , week , month , year , hour_of_day , day_of_week , month_num , raw ]
sql : ${TABLE}.created_at ;;
}

Please 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 Men's Kenny Schott Men's Men's Jacket Kenny Kenny Schott Green Jacket Schott Green Green Jacket : number # should not use alias names in LookML
}

Top
Description
The Kenny Jacket from Schott comes in Dark Khaki colour. This jacket also features elasticated cuffs and hem, stitched badge on left sleeve and breathable holes on side. Featuring buttoned pockets on front, this jacket for men also has zip pocket on left sleeve and buttoned inside pockets.
Materials
  • Upper : Synthetic