Knowledge Drop
Last tested: Sep 6, 2018
You may see an error that says something like Column 'id' in field list is ambiguous. This error means that there is a field name that is present in more than one table, so it needs to be scoped with the table name to avoid ambiguity: using orders.id instead of just id will resolve the issue.
Proper LookML references should always avoid these errors, so if you are seeing this, you are most likely doing something like using just field_name instead of ${field_name} or ${TABLE}.field_name. Check out this help center article: https://help.looker.com/hc/en-us/articles/360001298768-How-to-reference-views-and-fields-in-LookML
LinkedIn
Twitter