alias

LookML
Version

On this Page
Docs Menu

Go to Field Parameter List

Definition

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 alias: count # the old name type: count

You can also provide multiple alias’, in case you re-name a field multiple times. For example, if you renamed the above number_of_items field to number_of_order_items you could use:

- measure: number_of_order_items # the new name alias: [count, number_of_items] # the old names type: count

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: number # should not use alias names in LookML

Still have questions?
Go to Discourse - or - Email Support
Top