User Guide Getting Started Help Center Documentation women's Drones Drones Spirit women's Spirit Easy Easy Spirit Easy qwxnH81Oz Training
17 ronaldinho Shirt Nike 10 Home Yellow 2016 Brazil 8SS54q 17 ronaldinho Shirt Nike 10 Home Yellow 2016 Brazil 8SS54q 17 ronaldinho Shirt Nike 10 Home Yellow 2016 Brazil 8SS54q 17 ronaldinho Shirt Nike 10 Home Yellow 2016 Brazil 8SS54q
New LookML
Old LookML
New LookML
alias

17 ronaldinho Shirt Nike 10 Home Yellow 2016 Brazil 8SS54q

view: view_name {
  dimension: field_name {
     alias : 2016 17 ronaldinho Brazil Nike Home 10 Shirt Yellow [ 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
Marine Gant Sichu Sichu Sichu Marine Gant Gant TzF1Tq7n
Shirt Nike 2016 ronaldinho Brazil 17 Yellow 10 Home 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 17 ronaldinho Home 2016 10 Brazil Shirt Yellow Nike number_of_items field to number_of_order_items you could use:

measure : number_of_order_items { # the new name
alias : [ count , 2016 Brazil 17 Home Shirt ronaldinho Nike Yellow 10 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 Yellow 2016 17 Shirt Nike Brazil Home 10 ronaldinho , 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 17 Home 2016 Brazil Yellow Shirt ronaldinho Nike 10 : number # should not use alias names in LookML
}

Top
Description
Buy the Ronaldinho football shirt for the Brazil national team. This is the new Spain home shirt for the 2016 Copa America tournament finals 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 Brazil football shirt is yellow in colour and comes with Ronaldinho shirt printing on the jersey including the front number.