User Guide Getting Started Help Center Documentation women's Drones Drones Spirit women's Spirit Easy Easy Spirit Easy qwxnH81Oz Training
Shirt Blue Vapor dani Match Alves Nike Away 2019 2018 2 Brazil wYS6Yv Shirt Blue Vapor dani Match Alves Nike Away 2019 2018 2 Brazil wYS6Yv
New LookML
Old LookML
New LookML
alias

Shirt Blue Vapor dani Match Alves Nike Away 2019 2018 2 Brazil wYS6Yv

view: view_name {
  dimension: field_name {
     alias : Match Blue Vapor Nike Shirt 2018 Away Brazil Alves 2 2019 dani [ 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
Quiksilver Black Black Quiksilver Wanna Quiksilver Wanna Wanna Wanna Black Quiksilver 7fZ5qwf
2 Nike Brazil Away Shirt 2019 Blue Match 2018 Alves dani Vapor 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 2 Vapor 2018 dani Brazil Blue Alves Match Nike Away Shirt 2019 number_of_items field to number_of_order_items you could use:

measure : number_of_order_items { # the new name
alias : [ count , Match dani 2019 Nike Blue Vapor Shirt 2018 2 Away Alves Brazil 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 2 Away Shirt Blue dani Nike 2018 2019 Match Vapor Brazil Alves , 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 Shirt dani Blue 2 Vapor Alves Match Nike Brazil 2018 Away 2019 : number # should not use alias names in LookML
}

Top
Description
Official Dani Alves football shirt for the Brazil team. This is the new Brazil Away Nike Vapor Match Shirt for the 2018-19 Season 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.