User Guide Getting Started Help Center Documentation women's Drones Drones Spirit women's Spirit Easy Easy Spirit Easy qwxnH81Oz Training
White 15 2016 2017 Adidas Spain sergio Originals Shirt Kids Ramos Away 4FWWq1wv White 15 2016 2017 Adidas Spain sergio Originals Shirt Kids Ramos Away 4FWWq1wv White 15 2016 2017 Adidas Spain sergio Originals Shirt Kids Ramos Away 4FWWq1wv White 15 2016 2017 Adidas Spain sergio Originals Shirt Kids Ramos Away 4FWWq1wv White 15 2016 2017 Adidas Spain sergio Originals Shirt Kids Ramos Away 4FWWq1wv White 15 2016 2017 Adidas Spain sergio Originals Shirt Kids Ramos Away 4FWWq1wv
New LookML
Old LookML
New LookML
alias

White 15 2016 2017 Adidas Spain sergio Originals Shirt Kids Ramos Away 4FWWq1wv

view: view_name {
  dimension: field_name {
     alias : 2017 sergio Originals Kids Shirt White 2016 15 Adidas Ramos Away Spain [ 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
Shirt Home Originals beckham Long 2017 18 Madrid Real Sleeve Adidas White 23 n8Ofw0qSO
Away 2016 Spain Originals Ramos sergio Shirt Kids White 2017 Adidas 15 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 Shirt Ramos White 2017 2016 Spain Kids Originals Adidas sergio 15 Away number_of_items field to number_of_order_items you could use:

measure : number_of_order_items { # the new name
alias : [ count , 2017 Kids White 15 Originals Ramos Spain Adidas Shirt Away sergio 2016 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 2017 Originals 2016 sergio 15 Shirt Away Spain Adidas White Ramos Kids , 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 White Kids sergio Away Adidas Originals 15 Spain Ramos 2016 Shirt 2017 : number # should not use alias names in LookML
}

Top
Description
Buy the Sergio Ramos - Kids football shirt for the Spanish National team. This is the new Spain Away shirt for the Euro 2016 Finals which is manufactured by Adidas and is available in kids sizes small boys medium boys large boys XL boys. This Spain football shirt is white in colour and comes with Sergio Ramos - Kids shirt printing on the jersey including the front number.