User Guide Getting Started Help Center Documentation women's Drones Drones Spirit women's Spirit Easy Easy Spirit Easy qwxnH81Oz Training
Man 33 Kids Shirt g City Jesus Black Third Nike 18 2017 cWaC44 Man 33 Kids Shirt g City Jesus Black Third Nike 18 2017 cWaC44 Man 33 Kids Shirt g City Jesus Black Third Nike 18 2017 cWaC44
New LookML
Old LookML
New LookML
alias

Man 33 Kids Shirt g City Jesus Black Third Nike 18 2017 cWaC44

view: view_name {
  dimension: field_name {
     alias : Third 2017 g 33 Man Kids 18 Nike Shirt Jesus City Black [ 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
Jackson 80db Yellow Original Keex Yellow Jackson Original Keex 80db qU7xvEwP
Nike 18 Man City Jesus 2017 33 g Kids Black Third Shirt 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 18 g Nike Black Jesus City Third Kids Shirt Man 2017 33 number_of_items field to number_of_order_items you could use:

measure : number_of_order_items { # the new name
alias : [ count , City Third Black Shirt Kids 33 g Nike 2017 Jesus Man 18 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 Nike Man Third Black 33 18 Jesus Kids City 2017 Shirt g , 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 g Jesus City Man 18 Nike Third Kids 33 Shirt Black 2017 : number # should not use alias names in LookML
}

Top
Description
Official Gabriel Jesus - Kids football shirt for the Manchester City team. This is the new Man City third shirt for the 2017 Premier league which is manufactured by Nike and is available in adult sizes S M L XL XXL XXXL and kids sizes small boys medium boys large boys XL boys. This Man City football shirt is black in colour and comes with Gabriel Jesus - Kids shirt printing on the jersey.